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)
73 questions
-2
votes
2
answers
203
views
SQLite - Design use of Variable Length Integers - explain the design flaw
The Carnegie Mellon Database Group invited the creator of sqlite D. Richard Hipp to talk about SQLite - The Databaseology Lectures - CMU Fall 2015.
Richard Hipp shows this slide (~ 39m51s) and says ...
- 141
1
vote
0
answers
47
views
How can I use django to render a rotating view of a database?
As a toy problem for learning Django, I am trying to create a simple web app that tracks encounters and initiative for one of my D&D campaigns. I have a database with models for combatants:
class ...
0
votes
0
answers
65
views
How to structure my DB setup?
I have made a small project to try and learn to implement SQLite-DBs into my projects. For the DB part, I use sqlmodel and followed their tutorial. For the creation of the engine however, they use a ...
- 251
2
votes
1
answer
221
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 ...
- 251
-2
votes
1
answer
339
views
Should I update local storage every new event in a chat app? [closed]
I am building a chat app using flutter and sqflite. In the chats screen we display a list of chats, each contain name and last message. Every time a user sends a message, should I update the last ...
- 105
1
vote
0
answers
1k
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-...
- 111
0
votes
1
answer
107
views
Data Class: spread boilerplate for each different database over multiple class copies, or add complexity to original class?
I'm creating a prototype mobile app that will store data locally in an sqLite database and also on the cloud (CloudKit for now). The cloud storage uses a certain way of storing the data, and sqlite ...
- 1,660
0
votes
0
answers
432
views
How do I migrate Core Data data to a React Native application?
I have an iOS application that uses the Core Data framework. I'm migrating the application from Objective-C/Swift to TypeScript + React Native. My Core Data configuration uses SQLite as a backend.
The ...
- 2,063
-1
votes
1
answer
560
views
File based database via smb
We currently have a hotel and a restaurant management software (named Top-Sys and Pointex CHR), and they are working completely without server software.
These are designed to be installed locally but ...
- 159
-1
votes
1
answer
998
views
How to represent EITHER in UML Diagram [closed]
I am working on a small project and I tried to represent the following two requirements in my diagram:
An album may be performed by either a singer or a band (not both).
My plan to implement this ...
- 11
0
votes
1
answer
965
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-...
- 3,623
0
votes
2
answers
214
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 ...
- 2,280
0
votes
2
answers
552
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 ...
- 139
-2
votes
1
answer
296
views
Designing a sqlite component in C++
I work on a small component in an embedded device (sensor). This component :
Every 5 seconds, sends requests to other components using sockets
(get health check status, operating status etc) and ...
- 137
1
vote
0
answers
44
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 ...
- 225
0
votes
1
answer
232
views
How to implement FNV-1(a) in SQLite?
Moved
I originally posted this on SoftwareEngineering because that's where this related question was; but having looked into the Help in detail, I think my question is more on-topic for stackoverflow,...
- 153
1
vote
1
answer
343
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-...
- 113
-2
votes
1
answer
120
views
Should i use Sqlite integer as a datatype for my primary key column?
I am developing a library management software in javafx and I am using sqlite as a database for that. I have to store data of almost 50000 books. And all those books would have a barcode. Obviously, ...
- 23
-1
votes
1
answer
49
views
TEXT column as key for a table when there are other tables referencing that table?
I have a UNIQUE TEXT column (“name”) in SQLite for one of my tables (let’s call it “table A”) and i’m considering using that column as the key for the table
The reason i can see for continue using a ...
- 459
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 ...
- 459
2
votes
1
answer
151
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 ...
- 121
9
votes
3
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 ...
- 365
0
votes
2
answers
404
views
Can one Sqlite db support interaction by two server programs all on the raspberry pi
Say you are running two server programs on a single raspberry pi.
Can they both interact with a SQLite db at the same time?
Or seem to be happening at the same time as requests wait for each other to ...
- 13
-1
votes
2
answers
241
views
What is the .sqlite file for? [closed]
I would like to know what the .sqlite file is for. When I use MySql or MongoDB, the database is on disk, its something I never see. The documentation tells me with SQLite, everything is contained in a ...
- 117
1
vote
2
answers
824
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 ...
- 19
0
votes
4
answers
2k
views
Concurrent database access on shared network drive
I'm part of a small team that currently uses an Access database for scheduling a larger team's availability. This has presented some issues with corruption of the Access database. Additionally, I want ...
- 1,238
0
votes
1
answer
184
views
Database checking for updates
Using SQLite in a WPF application that schedules events for people. The application will be used by 2-4 users concurrently. I'm wondering how to ensure each user has the most current database ...
- 1,238
1
vote
1
answer
145
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) ...
- 123
3
votes
2
answers
821
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 ...
- 310
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 ...
- 85
6
votes
3
answers
10k
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 ...
- 459
2
votes
3
answers
537
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 ...
- 459
0
votes
1
answer
183
views
Develop for MySQL and SQLite3 Concurrently
I am developing a javascript (Node.js) desktop program that works with an existing MySQL database. I would like to (eventually) distribute to others with based on SQLite, or MySQL if they need (or ...
- 109
1
vote
1
answer
543
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 ...
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.
...
- 1,569
71
votes
1
answer
73k
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 ...
- 1,263
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 ...
13
votes
1
answer
6k
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. ...
- 856
2
votes
1
answer
934
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-...
- 856
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 ...
- 3,018
1
vote
0
answers
47
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 ...
- 11
4
votes
1
answer
196
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 ...
- 143
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 ...
1
vote
1
answer
60
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-...
- 11
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 ...
- 232
0
votes
2
answers
2k
views
Uploading text data to server from SQLite is faster or text files?
My application receives a lot of data every milliseconds(name,id,value,.. of a signal from a simulator device). and I should upload this data to MySQL server. First I need to save them in a database ...
- 1
3
votes
0
answers
884
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 ...
- 571
11
votes
1
answer
950
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;
...
- 39.5k
3
votes
0
answers
486
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 ...
- 131