Unable to load dynamic library because php_sqlite.dll canot be found
I use windows 7 and XAMPP V 3.2.1 For some reasons, I need to move my old data in old PC in XAMPP to New PC. So I download the exact XAMPP to New PC and move all the database…
Mysql – Syntax error by using alter table statement
I am trying to change column name in SQL but it is showing me error query alter table cust rename column first name to first_name(30) ; error ERROR: syntax error at or near "name"LINE 2: rename column first name to…
Laravel seeder dont fill table with foreing keys
I'm working on a Laravel project, and I have the following migrations: public function up(): void { Schema::create('customers', function (Blueprint $table) { $table->id('customer_id'); $table->string('first_name', 50); $table->string('last_name', 50); $table->string('address', 100)->nullable(); $table->string('phone', 15)->nullable(); $table->string('email', 50)->unique(); $table->timestamp('registration_date')->default(DB::raw('CURRENT_TIMESTAMP')); $table->timestamps(); }); } /** * Reverse…
Drizzle ORM in react native expo does not show database file
I am having hard times visualizing my sqlite database , i am using react native under expo with drizzle ORM to manage a sqlite database locally , the issues is that when i run all the setup commands it says…
Ios swift – Alter the reference to foreign key of an existing table with GRDB
In table Case_Supplies_Media I have column SupplyID_XRef. It currently has a foreign key reference to Media_List. I need to change the reference to Supplies_DVD_List. I found some bits and pieces, but I'm not sure how to put the whole thing…
Ios swift – SQLite Expression – name space conflict with Xcode 16/iOS 18
When you will update Xcode 15 to Xcode 16, you will get many errors using SQLite.swift library. For example: Missing argument label 'value:' in call etc, etc. How to fix them?
APK Size Increased by 100 MB After Adding sqflite and path Packages in Flutter
I recently added the following packages to my Flutter project: dependencies: sqflite: ^2.3.2 path: ^1.8.3 Since adding these packages, I've noticed that my APK size has increased by approximately 100 MB, bringing the total size to around 200 MB. This…
Postgresql – Select object that has multiple relations
Example tables would be: object id name 0 obj0 1 obj1 2 obj2 attr id description 0 attr0 1 attr1 2 attr2 link o_id a_id 0 0 0 1 0 2 1 1 I now want to generate a SQL…
Html – is it possible to build a local website that can access a .db file and dynamically update pages without a webserver?
I have a .db file made using sqlite that contains information about stories that were scraped from the internet (title, author, summary, file path, .etc). I plan for all the story files to be in one folder and then use…
Laravel – SQLite database Table not found
I'm doing laravel project, and trying to create a database factories and migration, where i want to put random data. I'm using PHP artisan tinker to generate random data for the database. But I get error message : It sounds…