Questions tagged [sqlite]
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)
71
questions
116
votes
4
answers
96k
views
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 ...
83
votes
2
answers
24k
views
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.
...
68
votes
1
answer
67k
views
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 ...
23
votes
2
answers
2k
views
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 ...
22
votes
1
answer
17k
views
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 ...
13
votes
1
answer
5k
views
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. ...
12
votes
2
answers
14k
views
Should I use a plain text database, or SQLite? [closed]
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 ...
11
votes
1
answer
6k
views
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 ...
11
votes
1
answer
938
views
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;
...
9
votes
2
answers
2k
views
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 ...
5
votes
3
answers
9k
views
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 ...
5
votes
1
answer
511
views
Can anyone explain to me what problem Core Data solves? [closed]
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 ...
4
votes
1
answer
193
views
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 ...
4
votes
4
answers
2k
views
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 ...
3
votes
1
answer
9k
views
External sqlite db file from sdcard in android
I just searched for the same but didn't get the answers. What I have is a db file which is around 100MB. I have saved the db file in sdcard .
Through this db file I'm going to populate the contents ...
3
votes
0
answers
853
views
how to import large amounts of data without locking sqlite database
Background Information
I have a web app that provides the user with the usual CRUD functionality for "widgets" let's say.
But I also have give them the option of creating widgets in bulk via ...
3
votes
0
answers
483
views
Syncing structured data and files in Android App with an ORM?
I am developing an Android App which I have developed for iOS before.
The app requires that structured data and files are synced across android devices.
In iOS, I was using Core Data and synced to ...
3
votes
2
answers
696
views
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 ...
2
votes
3
answers
518
views
Bundling of related boolean values for an SQLite database or keeping them separate?
I'm writing a reminder application where reminders can be shown or not for each day of the week (similar to Google Calendar). So I'd like to store the following in my SQLite database:
Monday: True or ...
2
votes
1
answer
242
views
Database structure for various items
I'm building a sqlite database for an android app which will hold a list of items, each of which have different characteristics.
Some of the characteristics are available for all objects, some are ...
2
votes
1
answer
139
views
How do I structure my functions (and classes?) which interact with my Database/ORM?
So I am working on my first project using SQLite and SQLModel as ORM. Creating and handling the first table in my database was easily structured: A function for each CRUD-Operation.
But now I have ...
2
votes
1
answer
141
views
Preloaded/Starter Data in an Android App when installing?
I'm working on my first android app. It's a companion app for a video game, and it should come with preloaded data. I'm not entirely sure how to best go about this. I apologize if this has been asked ...
2
votes
1
answer
429
views
How to run thread if multiple data is insert in the multiple table
I'm facing problem in gsoap , if two user go to register
at a same time then database is
locked, i think its threading problem ,
how to handle it, please insist me. I am running multiple ...
2
votes
1
answer
2k
views
Conflict resolution for two-way sync offline sync
How do you manage two-way synchronization between a 'main' database server and many 'secondary' servers, in particular conflict resolution, assuming a connection is not always available(offline ...
2
votes
1
answer
240
views
Handling Dynamic amount of Strings for persistent and runtime storage in an IOS App
Background
I am dynamically building an FQL query statement and because of the nature of the app, I exclude FB family members, this is the base portion of the query and remains fairly static. The ...
1
vote
1
answer
912
views
Why does Google Chrome use SQLite if the usage of threads results in parallel access?
I don't know much about how Google Chrome or SQLite works, but I know that Chrome makes heavy use of threads (I think a thread per tab). Additionally, I know that SQLite suggests to use a client-...
1
vote
1
answer
3k
views
sqlite trigger or application event?
I've have two event queues(table mapped queues) based on two different states of same data stored in two different tables. The events are generated on create/update/delete on both the tables.
...
1
vote
2
answers
1k
views
Using UNIQUE (col1, col2) or using a composite primary key for a relation table in SQLite/SQL?
i’m working on a project where i’m using SQLite and where i have a few relation tables looking similar to this one:
CREATE TABLE tag_entry_relation
(
id INTEGER PRIMARY KEY,
tag_id INTEGER REFERENCES ...
1
vote
2
answers
808
views
Converting one-to-many relationships into relations
Please check this in sqlite :
agents may make bookings for performers, and performers may also make bookings for themselves. It is only possible for agents to make bookings for functions that ...
1
vote
1
answer
526
views
How to quickly present 1000s of pictures in a jlist
I need people opinions on how to improve a code I've written. Let's assume we have an application cataloging movies (~3500 of them) and actors (~1000, but I need to double-check this).
Both actors ...
1
vote
1
answer
868
views
Why chaining matters (Python & SQLite3)?
Why does
cursor = connection.cursor()
cursor.execute("...
return cursor.fetchall()
return the expected non-empty result whereas
connection.cursor().execute("...
return connection.cursor().fetchall()...
1
vote
1
answer
1k
views
In Android, is there any reason to set up a content provider for a local database?
I have an android application with a custom content provider set up to load data asychonously. The database is a local file so I'm not sure if I needed to set up a content provider at all. Sometimes I ...
1
vote
2
answers
5k
views
Sync SQLite using only HTTP
I currently have a SQLite DB on my server that is needed by an android app I am currently developing. I download the DB to the android device using HTTP each time the contents are changed.
Does ...
1
vote
1
answer
136
views
architecture of gui app with several indepedent windows and sqlite backend
Let's assume that I have such a simple database scheme:
CREATE TABLE tbl(key INTEGER PRIMARY KEY, cap TEXT NOT NULL);
I want to show at least three independent GUI windows.
One window (window A) ...
1
vote
1
answer
181
views
Better way to organize query methods in Android?
In my Android app I have:
A SQLiteHelper class that extends SQLIteOpenHelper, and takes care of things like table-creation and upgrades.
A SQLiteDatasource class that performs CRUD operations on the ...
1
vote
1
answer
59
views
Storing mutliple selected values in DB
In my Android app, there is a question like "Which of the following foods did you eat today?" (not the actual question), with a fixed list of foods (e.g. "Apples, Banana, Pizza, Burgers") from which ...
1
vote
3
answers
3k
views
What's the best way to track updates when syncing data from MySQL remote server to local SQLite database?
I'm making an iOS App, well, two actually. App A will be able to write TO-DOs to a remote MySQL database, and App B will be able to read what App A has written/modified. App B needs to be always up-to-...
1
vote
1
answer
157
views
A way to include SQlite into an application where the drivers aren't already installed on the system?
I'm an open source web application for use in my university. Currently professors usually have a website, but do to the fact that they're teaching multiple classes in a given term, they don't care to ...
1
vote
0
answers
941
views
Versioning JSON data in db
I'm curious if there are any obvious pitfalls to the following:
I have a database table that, because it is storing many objects of various subclasses, I'm using a JSON field to hold the non-...
1
vote
0
answers
42
views
Offloading database joins to IOT devices
Solution as it is right now
I have this solution where I gather information from a proprietary product of a different company in various sites. The solution is based on a single go binary that ...
1
vote
1
answer
317
views
How to work with multiple databases efficiently (Development, Testing & Production)
Brief background
I'm currently designing a COM DLL in .NET for use in MS Access by a few other developers. The Access application is hooked up to a SQL-Server & is supposed to just act as a front-...
1
vote
0
answers
46
views
Creating a new table referencing older one vs just creating a column
I'me developing an iOS chat application and working on the db design for the contacts feature. There are 2 kinds of contacts-
Unsaved Contacts - Contacts with who you've conversed with, but not saved ...
1
vote
0
answers
4k
views
A way to trace each sqlite query
I've got big and hairy app with sqlite via dbi (from .c) as a backend - plenty of select/insert/update/delete queries.
From looking through documentation I did not found a way to log all the queries ...
1
vote
0
answers
125
views
What will be the better way for data retrieval on application that needs to handle limited amount of data? [duplicate]
Just moved this question from Stack Overflow. Since, adding my code snippets itself would make this question really long. Instead, I am pretty interested in knowing a better ways for data retrieval on ...
1
vote
3
answers
1k
views
Representing category splits in a personal finance database
I'm working on developing a personal finance applications (e.g. Quicken/Mint.com/etc..). I plan to store the data in a SQLite database. I'm stuck trying to determine how I want to represent splits in ...
0
votes
3
answers
4k
views
For what kind of websites is it ok or even better to use SQLite? [closed]
I'm familiar with the process of setting up Postgresql. And I'm also thinking of using SQLite for some of my websites for I don't need that much functionality that Postgresql offers. And I also want ...
0
votes
1
answer
848
views
Why shouldn't I be using SQLITE instead of the INI format in all cases?
Backstory
In an effort to store partial and full downloads to file in a clean manner, I had utilized QSettings which stores its key value pairs in the INI format in a single file.
https://doc.qt.io/qt-...
0
votes
2
answers
197
views
Is it possible to query data in a RDMS without writing SQL?
Disclaimer: I'm not very knowledgeable when it comes to SQL or RDBMS in general.
I've encountered this interesting answer about SQL as a language: https://stackoverflow.com/a/1643440/414063
This ...
0
votes
2
answers
439
views
Is it true that ORM allows for changing the type of SQL that you use easily?
Hey so I have been looking into ORM since my last question and I am wondering.
Instead of worrying alot right now about whether I will use mysql, postgre, or sqlite, would it be better to use ORM ...
0
votes
1
answer
3k
views
Sqlite3 slow on standard queries, is it expected? [closed]
Using Python and sqlite3. This simple print loop takes a few seconds to execute. I don't know much about databases, so I'm guessing I'm not using these queries correctly. Surely sqlite should be ...