All Questions
10 questions
2
votes
2
answers
157
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 ...
- 103
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
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
4
votes
3
answers
2k
views
Optimizing the insertion of 400 000 records in sqlite
I have the python script that creates a sqlite database and fills it with data (originally coming from a json file). At the time I execute the code below, my word ...
- 155
4
votes
1
answer
1k
views
Login function with python and SQLite
I'm a new programmer who is currently working on a personal project. It is supposed to be a login program which stores user data in a SQLite database.
I was wondering if anyone could look at my code ...
- 41
5
votes
2
answers
99
views
Add as newest ID to SQLite Database
At our company we use an SQLite Database to manage our Drawing IDs (CAD Drawings). The code is written in Python and I need to update it. I think the code I have has some problems, but I am quite ...
- 357
5
votes
2
answers
782
views
Searching for a word in a list of tuple extracted from a db via SQL
Python 3.6 and Sqlite3.
I have a database with something like 300K entries, each entry has several fields (date, username, etc) and a "text" one. I have a list of 200 words and for each word i have ...
- 249
5
votes
2
answers
1k
views
Flagging employees whose spending is close to the budgeted amount
I am working with an SQLite database. Is this code written the best way it can be and correct? The code:
Selects from the db adding a column for the percentage difference between two columns
Loops ...
- 169
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
3
votes
1
answer
229
views
Package Manager in Python
I've written a package manager for OS X in order to improve my Python skills. This is the second programming project I've ever worked on, so I do not expect it to be great, or anything, but I would ...
- 161