All Questions
102 questions
6
votes
2
answers
176
views
Pydantic model <-> neomodel OGM (neo4j) <-> python dict converter
I've written a converter between pydantic models of arbitrary complexity (thus, with submodels, nulls, lists) and neomodel models (library for ...
- 177
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
5
votes
2
answers
106
views
Accessing and editing a database in python using JSON
I am a beginner programmer and have recently started learning python. I wrote this code as a little project to understand dictionaries better and ended up having to learn to use JSON. I am self-taught,...
- 53
7
votes
4
answers
2k
views
Program for an employee database using python
In this program I'm defining functions to perform different tasks on a data record book for employees.
Here is a summary of the code:
Intro() to make the presentation of the home page.
create_record()...
7
votes
3
answers
777
views
Optimal Algorithm to Append and Access Tree Data
I have been studying intermediate or more advanced data structures in Python, one of which I've decided to try out is the Tree Data Structure. I've been studying the theories as well as the ...
- 177
2
votes
1
answer
77
views
Delete duplicates from SQL database with Python and reset ID's
I tried to create a peice of code that helps me remove duplicates from my sql database and reset the ID's as well.
I am not sure that it's error proof.
...
- 137
2
votes
1
answer
72
views
Python SQLAlchemy database model for Version Control system
This is my first time creating a non-trivial database and I was wondering what I could do better. As the title says this will be used a in toy version control system. Most of my choices feel "...
- 433
2
votes
3
answers
222
views
Inventory Management System
I'm trying to learn Django by building an inventory management system, here's my final models.py.
I'm looking for feedback!
...
- 335
1
vote
1
answer
82
views
DB Layer of a project management CLI
I am (re)writing a project management CLI and want to put it on a solid foundation concerning the database connections and testing. My focus was to build a DB class which is easy to test and could be ...
- 113
2
votes
1
answer
526
views
How to structure in handling websocket and inserting data to databse in Python
I connected to the websocket, and the data response in the callback function handle_message. I wish to insert all the data to influxdb using ...
- 127
1
vote
1
answer
191
views
Efficient way to read files python - 10 folders with 100k txt files in each one
i am looking for an efficient way to read and append texts of .txt files to a dataframe. I currently have 10 folders with 100k documents each.
What i specifically need to do is:
getting the names of ...
8
votes
2
answers
1k
views
High traffic website that shows users subscription status
I was in two minds as whether to post this question on stackoverflow or dba stackexchange but because I am asking for review, I thought of posting here.
I am new to Python and looking for feedback on ...
- 183
3
votes
1
answer
212
views
Summing categories of financial records per month in a query
My program is working properly but I'm unconfortable with code repetition.
...
- 183
3
votes
1
answer
449
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
62
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