# SQLiteException: \[SQLITE\_ERROR\] SQL error or missing database **URL:** \ **Category:** Ignition\ **Tags:** perspective, ignition81, scripting, database\ **Created:** [March 23, 2023, 12:23pm UTC](https://forum.inductiveautomation.com/t/sqliteexception-sqlite-error-sql-error-or-missing-database/71488 "2023-03-23T12:23:49Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![arjunrajas](https://avatars.discourse-cdn.com/v4/letter/a/6de8d8/32.png) [@arjunrajas](https://forum.inductiveautomation.com/u/arjunrajas)\ **Post date:** [March 23, 2023, 12:23pm UTC](https://forum.inductiveautomation.com/t/sqliteexception-sqlite-error-sql-error-or-missing-database/71488/1 "2023-03-23T12:23:49Z")
when i try to push data into the SQLITE database on running a timer script but i end up getting the error "SQLiteException: [SQLITE\_ERROR] SQL error or missing database " but when i check the database configuration is Valid and i am able to query the table in database query browser ![MicrosoftTeams-image (1)](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/f/af761bdb6616301cf67900d418cb4b83f234b3bc.png) ---
**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Post date:** [March 23, 2023, 12:26pm UTC](https://forum.inductiveautomation.com/t/sqliteexception-sqlite-error-sql-error-or-missing-database/71488/2 "2023-03-23T12:26:07Z")
Please post the entire error _ **text** _ and format it with the `` button. The screenshot doesn't show everything. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [March 23, 2023, 12:31pm UTC](https://forum.inductiveautomation.com/t/sqliteexception-sqlite-error-sql-error-or-missing-database/71488/3 "2023-03-23T12:31:30Z")
_Psssst!_ SQLite is not a full-featured database and is _ **NOT** _ suitable for ordinary Ignition DB connections. Before you get yourself in the weeds with this, switch to a more robust DB. If you need something free, use PostgreSQL or MariaDB. ---
**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Post date:** [March 23, 2023, 12:36pm UTC](https://forum.inductiveautomation.com/t/sqliteexception-sqlite-error-sql-error-or-missing-database/71488/4 "2023-03-23T12:36:43Z")
I've seen it said before online that SQLLite is good for prototyping the db before migrating to a real db, but I would suggest to always start with the real db - the initial setup for MySQL or PostgreSQL is minor /quick once you learn it, and then you can avoid the headache that can be migration. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [March 23, 2023, 12:52pm UTC](https://forum.inductiveautomation.com/t/sqliteexception-sqlite-error-sql-error-or-missing-database/71488/5 "2023-03-23T12:52:08Z")
> [@bkarabinchak.psi](#): > > that SQLLite is good for prototyping Not no, [expletive] **NO**. That's just _ **wrong** _. ---
**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Post date:** [March 23, 2023, 12:56pm UTC](https://forum.inductiveautomation.com/t/sqliteexception-sqlite-error-sql-error-or-missing-database/71488/6 "2023-03-23T12:56:14Z")
Ignitions page on connecting to SQLite "This is ideal for small scale applications, as well as testing and demonstrations." For testing and demos and especially for small applications, I would still say just use MySQL or PostgreSQL. You only need to install it once on your computer to have a playground for testing. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [March 23, 2023, 1:30pm UTC](https://forum.inductiveautomation.com/t/sqliteexception-sqlite-error-sql-error-or-missing-database/71488/7 "2023-03-23T13:30:53Z")
> [@bkarabinchak.psi](#): > > Ignitions page on connecting to SQLite Well, that's wrong, too. IMNSHO. ---
**Author:** ![Felipe\_CRM](https://avatars.discourse-cdn.com/v4/letter/f/dfb087/32.png) [@Felipe\_CRM](https://forum.inductiveautomation.com/u/Felipe_CRM)\ **Post date:** [March 23, 2023, 1:39pm UTC](https://forum.inductiveautomation.com/t/sqliteexception-sqlite-error-sql-error-or-missing-database/71488/8 "2023-03-23T13:39:48Z")
So what _would_ one use SQLite for? Toy projects? ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [March 23, 2023, 1:40pm UTC](https://forum.inductiveautomation.com/t/sqliteexception-sqlite-error-sql-error-or-missing-database/71488/9 "2023-03-23T13:40:58Z")
The primary purpose it is designed to handle is as a replacement for read-mostly configuration files. Like Ignition's internal DB. (Imagine that.)