how to store likes data in flutter
I'm developing an app in which I need to show come "coupons" I get from the API. I also have a "liked coupons" page where I need to show the ones the user has liked. I'm facing 2 problems here:…
MySQL: 8.0.31 – Large gaps (thousands) in ID Field after few months of usage
We see large gaps in primary key column with auto_increment in mysql 8.0.31 release version in multiple tables (with default - innodb_autoinc_lock_mode = 2 (“interleaved” lock mode)). Also I understand some smaller gaps can happen in this mode. We have…
Postgresql how to remove duplicated rows by columns value from a table without index or id
I'm using Postgresql,and I have a table named stock,this table has no index or id: open high low close volume datetime 383.97 384.22 383.66 384.08 1298649 2022-12-16 14:25:00 383.59 384.065 383.45 383.98 991327 2022-12-16 14:20:00 383.59 384.065 383.45 383.98 991327…
Rails, Postgres, Heroku: Cannot Commit, Migrate, or Seed To Heroku – Mysql
Can't do anything with Heroku using Rails and Postgres. It was working a few days ago and I upgraded from the Free plan to the Mini postgres plan and from the Free dyno to the Eco dyno. I get this…
How to copy paste a part of SQL table in the same table with updated column value – Mysql
i have one table TABLE 1 ID CLASS GENDER SUBJECT A1 6A A1 ENG A1 6A A1 MATH A1 4A A1 COMPUTER A1 3A A1 GK I want to copy and paste the records in the same table(table1) with ID…
how can i search and filter the data in table using php? – Mysql
i want to search and filter the data in my table but i dont know how to do it im currently studying php. this is my php script to search data <?php require('./conn.php'); if (isset($_POST['search'])) { $valueToSearch = $_POST['query']; //…
Attempt to read property "id" on integer – Laravel
I am new in laravel and working on E-Commerce Project. Plz Help me! I am trying to get data from the database but I can't. My function public function add_product_attributes($id) { $attributes = Product::where(['id' => $id])->with('attributes')->first(); $attributes_data = $attributes->toArray(); dd($attributes_data);…
Suggestion for Automatically Match Data in MysQL
I have limited access to the MySQL database, I just can see a view called customer contains customer_id, name, and their location id_customer name location 1 Andy Detro.it 2 Ben CALiforNIA 3 Mark uk 4 Niels London123 5 Pierre Paris…
Sorting data based on JSON content with Laravel
I have a table in my database that stores a student's progress in a course. Schema::create('course_student', function (Blueprint $table) { $table->primary(['course_id', 'user_id']); $table->char('user_id'); $table->char('course_id'); $table->timestamp('lesson_timestamp')->nullable(); $table->text('course_progress')->nullable(); $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade'); $table->foreign('course_id')->references('id')->on('courses')->onDelete('cascade'); $table->timestamps(); }); Course progress is stored as a JSON object and consists…
Issues connecting to postgres – Postgresql
ConnectionRefusedError [SequelizeConnectionRefusedError]: connect ECONNREFUSED 127.0.0.1:5432 at Client._connectionCallback (/home/gene/capital_greek_project/api/node_modules/sequelize/lib/dialects/postgres/connection-manager.js:131:24) at Client._handleErrorWhileConnecting (/home/gene/capital_greek_project/api/node_modules/pg/lib/client.js:305:19) at Client._handleErrorEvent (/home/gene/capital_greek_project/api/node_modules/pg/lib/client.js:315:19) at Connection.emit (node:events:527:28) at Socket.reportStreamError (/home/gene/capital_greek_project/api/node_modules/pg/lib/connection.js:52:12) at Socket.emit (node:events:527:28) at emitErrorNT (node:internal/streams/destroy:157:8) at emitErrorCloseNT (node:internal/streams/destroy:122:3) at processTicksAndRejections (node:internal/process/task_queues:83:21) { parent: Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect…