All Questions
87 questions
9
votes
3
answers
1k
views
Repository with SQLite in Python
This repository class is supposed to be used for saving information extracted from RAR, SFV archives or files that contain the hash sum in their filenames.
The abstract parent class can be found here)....
- 625
1
vote
1
answer
123
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
3
votes
2
answers
170
views
SQLite querybuilder class in python
Motivated by the first commentor's suggestion on my MSAccess question:
Python SQL insert to MSAccess with VBScript
I am moving to use SQLite databases for a python application and I created this query ...
- 123
1
vote
1
answer
119
views
Managing users via SQLAlchemy DB model (updated)
I am currently in the process of writing a system application that will be operated by multiple users. This will require individual users to access the application while limiting access to those that ...
- 303
1
vote
1
answer
116
views
Python Django image upload API with 6 fixed slots
I built an image upload API with Python Django. There are a fixed number of 6 slots, which can either be null or filled with something. There are two entities, Profile, which contains the six photos, ...
- 497
1
vote
2
answers
4k
views
Simple Connection Pool for SQLite in Python
When I talk to people regarding connection pooling in SQLite most of them always laugh and say "You don't know about SQLite", "It is not a client server DB, and only overhead in ...
- 113
5
votes
1
answer
266
views
decorator to execute sqlite statement
I'd like to wrap all my sqlite statement functions with a decorator which collects the statement and the lists of values I will inject in place of placeholders in my statement (to avoid sql injection)....
- 195
2
votes
1
answer
1k
views
Concurrently write results to SQLite database
The goal is to run a function compute in parallel on many inputs (10**6 in total, say) and store the results.
Each call to ...
- 21
2
votes
0
answers
338
views
A thin Python wrapper about the Python sqlite3 module
This wrapper incorporates the logging feature and provides a few convenience methods, including a scalar values fetcher, a generator for paged row sets, a wrapper retrieving a row set via a JSON ...
- 415
3
votes
1
answer
448
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
58
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
1
vote
0
answers
355
views
To do application using python's tkinter and sqlite3
I program python as a hobby and wanted to learn how to apply databases in a functional program, while at the same time make something useful. so I made a to do application with some basic ...
- 65
3
votes
1
answer
105
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
111
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
4
votes
1
answer
639
views
Code to scan filesystem, store every path into sqlite and update only when something has changed
I have made a program that does what the title explains. It also hashes the file to check for changes. I will be doing this for a project to keep track of files that has been changed when doing ...
