LateInitializationError in flutter&Firebase app
I have a question about this error that I have in my code. So, the app should show a list of products read from firebase. This is the code placed in the screen where I want to show Products: import…
Mysql – Is it sensible to create a different table for the same data for each date?
I have a MYSQL InnoDB table table with the following columns (table and column names changed): date (PK, DATE) var_a (PK, FK, INT) var_b (PK, FK, INT) rel_ab (DECIMAL) where rel_ab is a column that describes a relationship between 2…
Laravel – SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'namapenerima' cannot be null
I'm using a Livewire component, why is it still showing "cannot be null" even though all fields in the form have been filled out? I want the data that I fill in the form to be inserted into the database.…
How can I get postgresql local configuration parameter's current value?
I'm practicing with queries optimization. In particular, tuning work_mem parameter. There's the DB diagram: https://postgrespro.com/docs/postgrespro/12/apks02. I have a sql function get_passengers_and_flights: CREATE FUNCTION get_passengers_and_flights(d timestamptz) RETURNS TABLE(passenger_name text, flight_no text) AS $$ SELECT t.passenger_name, f.flight_no FROM tickets t JOIN ticket_flights…
Postgres consecutive ID numbers end user – Postgresql
Members, Hope you and yours are keeping safe and well. Am an end user not a coder as in we use software written on Postgres and just hoping for some information comment about a issue we have. We have a…
Visual Studio Code – Migrating from TFVC to GitHub for large SQL solution
The team I work in is currently migrating from TFVC to GitHub for a large database solution. When making changes to either code, objects or SSIS packages in TFVC from Visual Studio, they appear "Checked Out" (red tick). So only…
Using resource route to create dynamic URL's which is not based on id – Laravel
I have a database which contains id and randomString columns (also unique value), i set up a resource route so i can dynamically get the url of the database like this /editor/1 etc. In standart use of the resource controller…
how to retrieve records from yesterday's date at the exact same hour and minute as the current time – Mysql
I want to retrieve yesterday's record in an exact hour and minute time For example, this is today's date and time 2023-04-22 14:32:15 I want the records in 2023-04-21 14:32:15 I tried some queries but non of them works for…
Database WordPress
I came across the table name __wp_actionscheduler_actions in my WordPress database, and I noticed that there's an underscore before 'wp'. What is the purpose of the underscore and can I remove it, since there's already a table named 'wp_actionscheduler_actions'? Is…
Laravel database migration
I changed only user table and add several columns and when I try migrate:refresh it tells me this error message SQLSTATE[42S02]: Base table or view not found: 1146 Table 'basename.categories' doesn't exist (SQL: select * from `categories`) how can I…