All Questions
65 questions
2
votes
1
answer
69
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
135
views
Need assistance in Optimizing the Recursive Query in Pyspark
I am trying to convert a SQL Server stored procedure to Pyspark code.
This is my SQL Server query:
...
- 21
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
4
votes
1
answer
112
views
Python SQL insert to MSAccess with VBScript
I have a business use case that required running SQL insert queries to a local MSAccess database with a Python script. The actual script does many other things and the SQL function is just one of them,...
- 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
5
votes
1
answer
3k
views
Student report card management Python program
The program is designed to take data from a MySQL database, using mysql-connector-python, and print it as a table in Python using the texttable module. The program also plots charts based on the data ...
- 151
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
1
vote
2
answers
2k
views
A discord.py bot that logs every messages sent in a discord server
Hello Code Review community !
I'm making a bot with discord.py that listens to every message sent in a server and stores it in a database that could be retrieved by admin/mod later.
Here's the ...
- 103
1
vote
0
answers
35
views
Django Models for an ESL school
I am working on building a management interface for an ESL (English as a Second Language) institute, basically it is a language school where people learn English.
I have prepared my models for each ...
- 11
2
votes
1
answer
79
views
Managing a store in PostgreSQL
I have been trying to improve python combined with Postgres.
At this moment im only sending two values to database which are etc:
...
- 619
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
2
votes
1
answer
72
views
Functional Python Script to write a large amount of CSVs to database
I just finished up this script that crawls hundreds of local git repos for csv files and then stores them into a database. I've tried to follow a "functional" paradigm for this script but am kind of ...
- 235
4
votes
1
answer
135
views
Postgres Shopping Database using Python
So I have just started to work with SQL and I have tested my script and is working very well when it comes to my database.
The database is used for shopping. What I mean by that is that I scrape a ...
- 619
2
votes
2
answers
146
views
Receive data from SQL and CSV and send it to MySQL database using Python
Details:
I have a code, which does the following:
Get data from CSV and insert it into MySQL table
Get data from SQL Server and insert it into MySQL table
Run this code every 240 seconds - to refresh ...
- 235