All Questions
26 questions
1
vote
1
answer
110
views
Database design using Closure Table for tagging system
I created these database tables with the inspiration in NjDevPro github repository. The design uses Closure Table for implementation of hierarchical tagging system in ...
- 37
2
votes
1
answer
59
views
Database schema for project management app
As a side project, I'm developing a desktop app for project management, especially for students, self-employed, freelancers, etc. as a general purpose productivity tool, not from any business or ...
- 497
3
votes
1
answer
433
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:
<...
- 926
1
vote
0
answers
54
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 ...
- 400
3
votes
1
answer
100
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 ...
- 400
3
votes
1
answer
105
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-...
- 427
2
votes
0
answers
424
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
553
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
3k
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 ...
- 264
4
votes
1
answer
1k
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
624
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
72
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
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
3k
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