[sqlite] SQLITE Return Exponential value in the latest version(3.28.0) rather than integer number .

Hello SQLite Community Members, I am facing an issue with SQLite latest version(3.28.0). SQLITE Return Exponential value in the latest version(3.28.0) rather than integer number . The old version (3.6.2) return the same integer value which is inserted . Below is the screenshots of my

[sqlite] sqlite - Delete large table in sqlite

I have a 4GB SQLite database (currently using SQLCipher for encryption). I have created a physical table in the SQLite DB which has approx 20 rows x 183 columns. When I am trying to delete the table. Sqlite is taking up a lot of time to delete the huge table. I tried drop table and also

[sqlite] SQLite - how to get number of active connection?

I want to run certain clean-up tasks on the SQLite database only and only when there is only 1 connection(self) to SQLite. I do not want to lock the database during the cleanup process. The main application(s) using the SQLite DB is given 1st preference. the cleanup application is executed at

[sqlite] sqlite database is locked when query SQLITE_MASTER table

I have the huge size of the database file (approx 5.5GB). I have two processes. 1.The first process: It executes master table query. (Ex. "SELECT "type", "tbl_name" FROM "SQLite_MASTER"). It creates the new table using the dump of the existing table and database file size has been increased