Questions tagged [sqlite]
SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
227 questions
4votes
2answers
70views
better-SQLite3 and JS/Next.js - updating data using "transaction"- shorter / better code?
I am pretty new to SQL databases and in particular to the better-SQLite3 database. I have managed to insert, update, and delete data in a way I desire. All of it running in the background of a self-...
- 143
1vote
1answer
110views
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
2votes
1answer
59views
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
1vote
2answers
37views
QGIS - SpatiaLite - Getting info from contained and nearest features [closed]
I’m working on QGIS with a SpatialLite DB (SQLite). I have four layers, and the fourth one (table: "ESPECES_HABITATS_POLY") is populated with the contents of two other layers (table: "...
- 169
1vote
0answers
88views
comment-monk - Comment hosting script for static blogs and websites
So few days ago, I had created another review request for sqlite database schema for a comment hosting system. Now that the app development is complete, I have pushed the initial version on github. As ...
- 497
4votes
2answers
770views
Database schema for an upcoming comment hosting system
I'm working on a small and simple comment hosting platform in PHP (SQLITE database) to host comments for my static blog https://prahladyeri.github.io/. No login, sign-ups or third party OAuth, just ...
- 497
2votes
2answers
157views
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 ...
3votes
3answers
120views
Improving efficiency of database searches under SQLite (SpatiaLite - QGIS)
I'm new to SQL, but I've always heard that it's a very efficient way of searching databases. For the same task, in VBA I get a result in a few seconds for 1000 queries. In SQL it takes several minutes....
- 169
1vote
1answer
104views
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
1vote
1answer
129views
My Drawing Finder
I developed this application for the company I work for. It became increasingly challenging to locate drawings within the myriad of folders, especially when searching for the most up-to-date versions. ...
- 13
1vote
1answer
106views
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, ...
5votes
3answers
678views
Mapping named parameters to indices for PreparedStatement
I needed something to map named SQL parameters into indices for JDBC queries so I wrote the ParameterMap class that takes an SQL query, searchers for parameters ...
- 44.4k
1vote
2answers
4kviews
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
0votes
0answers
84views
Generate INSERTs from function parameters with jinja2
I'm writing unit-tests with pytest for sqlite database and reporting functions and I need to arrange them by inserting minimal ...
- 44.4k
5votes
1answer
255views
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
