SQLite is a relational database management system contained in a C programming library. In contrast to many other database management systems, SQLite is not a client–server database engine. Rather, it is embedded into the end program. (from Wikipedia)
Questions tagged [sqlite]
69 questions
116
votes
4 answers
Why is Web SQL database deprecated?
I am making a hybrid Android app.
At first I decided to use localStorage, after spending 2 days, I realized that it is very strange and so dropped it.
Then, I picked up indexedDB, after spending today's whole day and actually getting the output in…
user52009
83
votes
2 answers
Why are concurrent writes not allowed on an SQLite database?
I am doing database programming using Java with SQLite.
I have found that only one connection at a time to the database has write capabilities, while many connections at once have read capability.
Why was the architecture of SQLite designed like…
SteelToe
- 1,539
- 3
- 13
- 22
63
votes
1 answer
What is a realistic, real-world, maximum size for a SQLite database?
According to this article on Appropriate Uses For SQLite it says that, while SQLite is limited to 140 terabytes, a client/server RDBMS may work better:
An SQLite database is limited in size to 140 terabytes (247 bytes, 128 tibibytes). And even if…
Ben Harrison
- 1,183
- 1
- 11
- 12
23
votes
2 answers
Internal-use websites: Is there a compelling case against SQLite?
Many web frameworks, such as Flask or Django use SQLite as their default database. SQLite is compelling because it's included in python, and administrative overhead is pretty low.
However, most high traffic public production sites wind up using a…
Mike Pennington
- 404
- 3
- 11
22
votes
1 answer
SQLite with two python processes accessing it: one reading, one writing
I'm developing a small system with two components: one polls data from an internet resource and translates it into sql data to persist it locally; the second one reads that sql data from the local instance and serves it via json and a restful api.…
rgb
- 879
- 2
- 8
- 18
13
votes
1 answer
Where to store SQLite Database file?
I'm writing an application for learning foreign words of exactly one language (english at the moment), which has currently an ineffective design.
I use Java and SQLite-jdbc for saving the words. After starting, the application downloads a comma…
toogley
- 846
- 1
- 9
- 16
12
votes
2 answers
Should I use a plain text database, or SQLite?
I'm creating a point of sale system for a small shop. I am particularly interested in finding patters from all items purchased, which I will log in their entirety. I'm thinking of even making queries on things like temperature to sales of specific…
infinite-etcetera
- 237
- 1
- 2
- 6
11
votes
1 answer
Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
In SQLite the following statement would be successful and the string would be inserted/updated into the SALARY column which is of type INTEGER:
update employee set salary='TOO MUCH' where emp_id=1;
Note that zero will not be inserted/updated but…
Tulains Córdova
- 39,201
- 12
- 97
- 154
11
votes
1 answer
Why do Core Data sqlite table columns start with 'Z'?
I was looking at the sqlite table that Core Data generates and noticed that all table columns start with 'Z'. I realize this is an implementation detail, but I was curious as to why that's the case and if there was a design decision involved in…
Dia
- 213
- 2
- 6
7
votes
2 answers
SQLite database as a data interchange format?
Is it sensible/reasonable to consider using an SQLite database file as a data interchange format? Are there any obvious gothchas or reasons not to do this?
Example. Say I have a master SQL Server database and periodically need to SELECT a set of…
redcalx
- 345
- 3
- 14
5
votes
3 answers
Storing settings in a table in my SQLite database or separately?
I'm building an application which uses SQLite, and now want to add settings that are stored between sessions
I'm considering if I'm going to store the settings in a config file or if I'm going to use a table in the database for this
(Please note…
sunyata
- 449
- 5
- 16
5
votes
1 answer
Can anyone explain to me what problem Core Data solves?
Core Data seems to add a needless layer of complexity. If you want to save data created natively by the user in an app why not just use an object and then write the data all to SQLite or back to a server using a RESTful script if necessary.
Android…
Curtis Sumpter
- 171
- 3
4
votes
1 answer
How can we rollback a database synchronized over multiple systems?
On a mobile device, a set of operations has been saved in the local DB with a wrong date (because the system date was set in the future). Then the device regularly doing synchronisation with a server DB, the erroneous operations have been propagated…
Yahia
- 143
- 3
4
votes
4 answers
Algorithm for scheduling a set of real life tasks that are input by the user
I am trying to write some code to schedule a set of real life tasks that are input by the user. These tasks are stored in an SQLite database. And at the moment, the only parameters I am taking into consideration are the,
The project to which a task…
Jay
- 157
- 3
3
votes
2 answers
Where should I store the SQLLite file when it is shared between a web and a desktop app?
I am developing an application that can be simplified as follows:
The application is basically a mailing list.
Users browse to http://mysite/subscribe.
It's on the intranet, and the site is using Windows Auth, so I can retrieve their email adress…
Maxime
- 300
- 2
- 6