All Questions
25
questions
3
votes
1
answer
341
views
Why are my read speeds so bad using sqlite?
I know very little about databases and even less about how to optimize them, but I have a problem which calls for a database so here I am...
I created a sqlite3 database using the following script:
<...
- 906
1
vote
0
answers
45
views
UPDATE on Newspaper Bill Calculator CLI with Python (3 of 3, Database)
Code is posted after explanation.
Due to the size of the project, this is being posted in three separate posts. This also ensures each post is more focused.
Post 1 of 3, Core: UPDATE 1 on Newspaper ...
- 358
3
votes
1
answer
75
views
Newspaper Bill Calculator CLI with Python (3 of 3, Database)
Code is posted after explanation.
Due to the size of the project, this is being posted in three separate posts. This also ensures each post is more focused.
Post 1 of 3, Core: Newspaper Bill ...
- 358
3
votes
1
answer
79
views
Acupuncture database builder
The following code builds a rudimentary acupuncture database by collecting data from the web.
I would like to hear suggestions about improvements to the database structure, code organization, web-...
- 417
2
votes
0
answers
232
views
SQLite C/ADO VBA library with reflection
SQLite C/ADO VBA library with reflection
The SQLiteCAdo library is a VBA middleware facilitating access to SQLite databases. Its two subpackages provide alternative connectivity options: via ADODB/...
- 415
3
votes
1
answer
298
views
VBA introspection library for SQLite
SQLiteDB VBA Library is a set of VBA helper functions for the SQLite engine. The primary motivation behind this project is to provide convenient access to extended introspection features. Because of ...
- 415
1
vote
1
answer
2k
views
SQLite and Python: commit once every 10 seconds maximum, and not after every client request
In a Python Bottle server using SQLite, I noticed that doing a DB commit after each INSERT is not efficient: it can use 100ms after each client request. Thus I wanted to improve this in How to commit ...
- 244
4
votes
1
answer
998
views
Interface class for SQLite databases
I am learning the basics about managing an SQLite database by using Python and, mainly for practice purposes, I have then defined an interface class in order to let operations on database as clear as ...
- 223
3
votes
2
answers
196
views
Database Design for representing category relationships
So I am new to Databases.Recently I was asked this question in an interview where they expected me to come with a schema for storing and retrieving categories for an E-commerce website in an RDBMS. ...
- 143
1
vote
1
answer
65
views
Scenario creator database design
I am working on moving a save system from loose files to a (spatial sqlite) database.
The user places objects from a library in a 3d simulation. Scenarios are "what-ifs", what if we place 5 wind ...
- 11
1
vote
0
answers
199
views
c++ sqlite3 wrapper
this is a simple wrapper for sqlite3 to make working with databases easier
it isn't a professional implementation but it is much better than the raw c interface
I saved much time and code using this ...
- 293
1
vote
2
answers
2k
views
Extensive use of exception for database wrapper
My favourite programming language is Java and I usually use JDBC for database operations.
I'm using Swift for one of my projects and I should use a database. The problem is SQLite is only available ...
- 165
2
votes
0
answers
1k
views
Inserting large datasets into SQLite db becomes very slow over time
I'm using the program below to insert values from very large .csv files (~2.5 million lines) into an SQLite DB. It starts very fast, but begins to slow over time, before eventually hanging ...
- 191
2
votes
1
answer
2k
views
List<List<string>> vs DataTable
I have an application which uses SQLite. In that database I have several tables that I need to be able to read and update in my application. Often I need to 'cross-reference' these tables to get the ...
- 427
6
votes
1
answer
245
views
Car leasing system - add lease to database
I just came back to programming and decided to create a car leasing system (GitHub page here.) to teach myself about databases, gui programming and web development. And I would like some input on what ...
- 113
3
votes
1
answer
290
views
SQLite database for a micro/tumble blog application
I'm creating a personal website where, among other things, there is a blog, or a "microblog" (I'm still not sure how to define the two), where I will be writing articles and having users, who will ...
- 133
5
votes
2
answers
12k
views
Check existence of a row then update a column
not too experienced with SQL, wondering if I can make this better... I am trying to check if a row exists and then add one to the frequency column if it does, if it does not exist it should return ...
- 263
6
votes
2
answers
10k
views
Saving and Loading data with SQLite
I'm in the process of learning SQLite in C# and I've come up with some generic methods for finding and updating data. I would appreciate any pointers with the design of my methods and/or my SQL syntax....
- 197
8
votes
1
answer
1k
views
Generic asynchronous SQLite search builder
I am writing a database manager that reads and writes to a local SQLite database on a mobile device. It works pretty well for the most part, but read access is somewhat slow - it takes about 2-5 ...
- 133
2
votes
1
answer
1k
views
Key Value Store for Android on top of Sqlite3
I wrote this simple key-value interface on top of Sqlite3 to use in my Android app. I am using this to persist Java objects as strings converted using Gson.
The public API has 3 methods.
get(...
- 167
7
votes
3
answers
8k
views
Create SQLite backups
I have this script for creating SQLite backups, and I was wondering whether you'd have any suggestions on how to improve this. I was thinking that maybe it should create the backup ...
- 587
6
votes
1
answer
3k
views
Persistent key value store for Python using SQLite3
This is a module to implement a key value store in Python using SQLite3. Originally written to allow sharing of configuration among multiple threads that are already sharing a SQLite3 database, I have ...
- 61
6
votes
2
answers
182
views
3
votes
2
answers
178
views
Querying a database with PHP
I'm new to PHP programming. I would love some feedback on this simple code I wrote which queries a database based on some arguments supplied by a user and returns an HTML table displaying the data.
...
- 133
7
votes
4
answers
454
views
Storing .h files in SQLite using SQLJet
I’m trying to learn as much as I can on my own by reading lots of examples, documentations, and asking here. I would like to improve my style to write efficient code and adhere to Java standards.
In ...
- 499