Questions tagged [sqlite]
SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
205
questions
4
votes
3answers
1k 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 ...
0
votes
2answers
75 views
Getting a username from a database and displaying it in HTML
I'm using Flask on Python and I'm displaying the username at the top of the site (and it's working) as follows:
...
2
votes
1answer
36 views
Adding iterators to C++ sqlite wrapper class
I recently put up my C++ class to wrap the sqlite3 c library here:
Thin C++ wrapper for sqlite3 C library
One of the suggestions was rather than to specify a vector for arguments to functions instead ...
2
votes
1answer
61 views
Thin C++ wrapper for sqlite3 C library
I originally wrote a rough C++ wrapper of the sqlite3 c library which did not use prepared statements. This code is my attempt at using prepared statements. I have attempted to make the wrapper as ...
0
votes
1answer
32 views
Speed performance of sqlite3 queries looped in python
I have a table data stored in a database ships.db,
the data are informations of tracked ships hourly.
The table data looks like ...
2
votes
0answers
32 views
Covid Tracker + Notify people = Ideal for small coffee place or similar
This is my second project since I started with Python, this time I learned a little bit of SQL that is so useful and beautifully simple.
Starting idea: Generate a program that will store information ...
2
votes
1answer
102 views
Generate a bar chart of weekly data from SQLite.NET
I am using Xamarin.Forms, Microcharts and SQLite.NET to create a mobile app. The SQLite.NET database stores details about books (book ID and entry date - the date it was entered in the system).
The ...
3
votes
1answer
260 views
C# Password Security Login System with SQLite
I want to start by just mentioning I'm a semi-beginner at C# and cyber security so any feedback is appreciated :)
What I think I need reviewing is the SQLite queries and maybe the hashing functions
I'...
0
votes
0answers
23 views
How to effectively sperate CRUD operations from the main SQLiteOpenHelper - android studio
I'm conflicting about how I want my database architecture to be built.
First of all, I use a singleton pattern for the database in order to insure one instance of it (so its thread-safe), and also for ...
3
votes
1answer
40 views
Simple Safe for Loading and Retrieving Digital Images
I wrote this little utility program that saves and load digital images such as videos, pictures among others in a database. I used click module for it's interface. ...
0
votes
1answer
99 views
Sqlite select and delete operation using C API in Swift
I've following sqlite code using C api within Swift having a read and a delete operation for review.
For those not familiar with Swift, defer will execute after the ...
0
votes
0answers
88 views
Is my Android Room SQLite migration code written without flaw, as I wish to have 0 impact on my existing users?
Currently, we plan to perform an intensive SQLite DB migration code in Android. We really want to avoid from having any bad impact (data corruption) on existing users.
Can anyone help me to take a ...
2
votes
0answers
161 views
Simple Sqlite-driven WinForms app in C# 7.0 - database interaction code
Description
This is a simple "demo" app designed to help gain familiarity with interacting with an Sqlite database from C#, particularly storing images as blobs. The database has a single ...
1
vote
1answer
90 views
Load data from SQLite table, modify them and save in to new SQLite table
My goal was to create a script that would:
Pull certain data from an existing SQLite table
Apply a simple mathematical formula
Save the new values to another SQLite table
I’m just starting to learn ...
1
vote
1answer
112 views
Improving sqlite3 code in swift using c api
Trying to come up with a pattern where the code to open db, writing queries is elegant and clean while handling all possible error conditions.
Following code
...
3
votes
0answers
364 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 ...
2
votes
0answers
29 views
Uploading to DB from Excel with Pandas
I have this python script that uses pandas read an excel sheet then to update a sqlite db it works perfectly just wondering if I can speed it up as I am at about 70k lines
...
0
votes
1answer
54 views
QCombobox Case selection - Pyside2 Index via Sqlite
I have a very simple file where I have a Qcombobox Filter. When you select the filter, I run through a case on the index and output results.
So, on selection I trigger:
...
1
vote
1answer
501 views
SQLite and Python: commit once every 10 seconds maximum, and not after every client request
In a Python Bottle server using SQLite, I noticed that doing a DB commit after each INSERT is not efficient: it can use 100ms after each client request. Thus I wanted to improve this in How to commit ...
3
votes
1answer
281 views
Gold Price Tracker Web Scraper using Python
Hi I've written a web scraper for tracking gold price. Can someone please review my code and suggest improvements. It gets the price of gold from a specific url then stores the price against date in a ...
4
votes
1answer
138 views
Interface class for SQLite databases
I am learning the basics about managing an SQLite database by using Python and, mainly for practice purposes, I have then defined an interface class in order to let operations on database as clear as ...
4
votes
0answers
70 views
Optimizing hundreds of millions of SQLite database inserts in Python
Some background
Feel free to skip this if you're not interested.
There is a very popular bioinformatics program called tabix that permits interval-based searches for genetic variants in VCF files. ...
5
votes
3answers
429 views
Simple Python and SQLAlchemy Text Password Manager
Out of boredom, I decided to start my personal project and I've chosen a simple Text Password Manager.
Note: For anyone out there, I strongly recommend you NOT to use this for any sensitive storage ...
1
vote
1answer
40 views
Count distinct records in a JOINed SQL query
I have two tables with a 1-many relationship, Device and TestResult.
My application has a filter builder front-end that allows a user to retrieve TestResults based on whatever filters they specify. ...
3
votes
2answers
61 views
Database Design for representing category relationships
So I am new to Databases.Recently I was asked this question in an interview where they expected me to come with a schema for storing and retrieving categories for an E-commerce website in an RDBMS. ...
1
vote
0answers
76 views
Uses SeekBar to adjust the data displayed in UI from my Room database
I wrote code that takes the value of the progress bar in my Android app which influences what is displayed on the UI. If the user's progress bar value is above or below a certain number, data will be ...
1
vote
1answer
50 views
Scenario creator database design
I am working on moving a save system from loose files to a (spatial sqlite) database.
The user places objects from a library in a 3d simulation. Scenarios are "what-ifs", what if we place 5 wind ...
5
votes
2answers
74 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 ...
3
votes
0answers
88 views
Sending push notifications to a user
I have a function whose responsibility is to send a push notification to a user. I call this function from a view in flask framework.
I have read multiple articles around refactoring and good designs ...
3
votes
3answers
425 views
RAII wrapper for SQLite transactions
I'm using this nice C++ wrapper to work with SQLite3 in my project. I wanted to handle errors gracefully and automatically rollback if piece of code fails, so wrote this simple helper class:
...
1
vote
0answers
79 views
c++ sqlite3 wrapper
this is a simple wrapper for sqlite3 to make working with databases easier
it isn't a professional implementation but it is much better than the raw c interface
I saved much time and code using this ...
9
votes
3answers
623 views
School House Points (Python + SQLite)
I am creating a database to store house points for our school running events. I would like to be able to tally all the points for the houses and it is working fine, however, I think it may be a bit ...
7
votes
1answer
781 views
SQLite In-memory Database That Inserts Data Read From a CSV File
I wrote this program to make a simple in-memory database using SQLite and JDBC. Requirements I was trying to accomplish are below.
It should consume a CSV file, parse the data, and insert it into the ...
2
votes
1answer
162 views
SafeBlockPopulator to ensure neighboring chunks are generated before population
Bukkit/CraftBukkit/Spigot are Minecraft server extenders that allow for creating and using plugins. A particular type of plugin is a generator, which creates the game world. Generators operate chunk-...
4
votes
1answer
160 views
Insert into SQLite3 database
I have a tsv file containing the mapping for two kinds of identifiers.
...
2
votes
1answer
108 views
SQLite3 account creator
This program allows users to create and log into their account. The database is created using SQLite3 and the GUI is just simple tkinter boxes. I just want to know how to improve my code, organise it, ...
5
votes
2answers
3k views
OOP bank account program in Python 3
Python beginner here. Building an OOP bank account program with SQLite and starting to struggle a bit with its design. From a design standpoint I have a file (bank) which calls ATM. ATM simulates an ...
2
votes
2answers
111 views
Optimize Multiple Insert SQLite Coming From MySQL
I'm currently developing an app that requires sending and receiving of data from android studio going to MySQL and then data coming from MySQL will be saved from the SQLite. I need advice on how to ...
3
votes
1answer
155 views
Sending and receiving of JSON data to and from Android Studio
I'm currently developing an app that requires sending and receiving of data from android studio going to MySQL and then data coming from MySQL will be saved from the SQLite. I need advice on how to ...
5
votes
2answers
585 views
Python update SQLite DB Values
At the moment I try to get used to SQLite and Python. I started with insert, select and so on. But now i want to get a bit further.
Now I have a DB with 200 rows for testing and in want to update two ...
2
votes
0answers
52 views
Database code for Python-based URL shortener
I had implemented a URL shortener with Python and a database. Please review the database part of the code. The idea is to create an MD5 hash of the URL in question and then store it in a database. The ...
4
votes
1answer
128 views
Uploading songs from website to database and then to Spotify
My Python program parses songs from a website, corrects song titles and artists with the Last.fm API, searches for the spotify uri using the Spotify API, stores all the information in a SQLite ...
1
vote
1answer
38 views
Database as a config and class structure to call it
I have question regarding best practices. I've decided instead having config inside either app.config or xml file to have my config file inside SQLite file database. This config will contain basic ...
2
votes
0answers
211 views
Python CLI app for tracking budget
I'm making a CLI app for myself for tracking my budget. How can I improve this code?
...
4
votes
0answers
124 views
Perl PasteBin scraper
I'd like to optimize my code and get a better of understanding of how I can perform the task I am doing better. I've only used Perl threads about 3 or 4 times now.
The purpose of my script / code ...
3
votes
2answers
3k views
Simple one time pad cipher
I had this idea not to long ago on creating a secure chat for people who need to be not meddled with when talking (like whistleblowers, hackers, etc) talking to one of my friends about it he said I ...
3
votes
2answers
180 views
Displaying 21 spinners to select body parts
I just wanted to ask how can I make my code a bit shorter. As of now, I have way too much code in the class. The program should display about twenty one spinners. I know it's a lot, but in this layout,...
2
votes
0answers
617 views
Simple web API that access sqlite database
This is a very simple web API for a school assignment, as a part of a bigger system. The web API returns a list of courses or a single course as json. I doubt that I will get any feedback on the code ...
3
votes
0answers
3k views
Structure and Implementation of Generic Repository and Unit of Work patterns with Dapper and SqlTransactions
I am attempting to update some legacy code that I work with, but my knowledge of data access is limited to a basic use of Entity Framework and simple Dapper. After some research, I have a loose ...
2
votes
1answer
89 views
Iterable and .db file searcher that imports data
This Program is a tool that allows me to import data from files that may not be easy to read just by opening; such as .db files which are wayyyyy to hard to understand just by opening the file in ...
