Questions tagged [sqlite]
SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
183
questions
1
vote
2answers
24 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
17 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. ...
1
vote
1answer
34 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
24 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
32 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
64 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
73 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
231 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
50 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
611 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
197 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
76 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
71 views
Insert into SQLite3 database
I have a tsv file containing the mapping for two kinds of identifiers.
...
2
votes
1answer
54 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
1k 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
100 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
84 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
473 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
47 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
102 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
37 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
125 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
105 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
1k 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
135 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
469 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
2k 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
77 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 ...
1
vote
0answers
141 views
Extracting data from a used car sales site
I am developing code for extracting data from a used car sales site. There are 4 sites in total. In 3 of them I use requests and beautifulsoup. The time taken to extract data from these sites was ...
7
votes
1answer
407 views
Importing XML dump of Stack Overflow questions and answers into SQLite3
I have a 60gb+ XML file and, as you can see, I am using a Python script to extract the data and execute 'INSERT' statements to update my database.
Being that the file is so large, will I run into ...
3
votes
1answer
57 views
SQLiteOpenHelper for multi string tables
I wrote this simple SQLiteOpenHelper in order to use in one database various tables containing String records (each record having a String identifier, and ...
1
vote
1answer
831 views
C++ SQLite insert statement
I insert a value into a SQLite database and return the id of the last inserted value as a result of the method.
I asked a question on Stackoverflow and I found this solution to my problem. Now I ...
5
votes
2answers
478 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 ...
2
votes
1answer
255 views
SQLite Quiz with Questions Table and Categories Table
Edit: I changed my approach.
I am trying to add categories to my existing SQLite quiz. This is my approach, what do you think about it? Do you think the foreign key restriction is necessary? I am a ...
3
votes
1answer
575 views
Register and track product inventory
KeepStock: Database Query
KeepStock is a lightweight inventory tracker written in python
All business logic is done via 4 classes:
Database- Queries sqlite3 database file
Excelwb- Creates and ...
1
vote
0answers
53 views
Basic Java Android app for computer data logging in an SQLite database
This is a pretty basic app I made to collect data necessary for a separate project. However it's also my first go at doing any Android programming, so I know there's definitely issues with it (the ...
0
votes
1answer
196 views
Android SQLite database with 3 tables
I want to show you the SQLiteOpenHelper and Contract class for a little quiz app I made for practicing purposes. I have 3 tables ...
1
vote
2answers
131 views
Unwinding shortened URLs with Python, SQLite, and multithreading
I spent the last couple of days reading/researching and learning sqlite and python multithreading.
I'm unwinding shortened urls stored in a sql table with three fields...
id | url_starting | ...
5
votes
2answers
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 ...
3
votes
2answers
181 views
Haskell API for accessing a SQLite database
I have a SQLite database, and I'm trying to make a web API for it. I've been writing it in Haskell, and using scotty as the server. I templated out the website from ...
5
votes
0answers
3k views
Minimal SQLite table view in PyQt5
I have just started digging into PyQt5 in order to write a small GUI for editing a lexical database. Before I dig deeper into this, I would like to have feedback on the progress so far. Some ...
3
votes
0answers
87 views
Investment tracker allowing users to store investment information and later access it
This investment tracker allows users to store investment information and later call upon it. This is a simple solution to making investing easier to maintain. This application has a simple login ...
6
votes
1answer
3k views
Expense Tracker for keeping track of payment information
This system is a expense tracker. It allows ordinary people to track expenses, like bills , car notes, and keep up with the payments they make. I had this idea after my father and mother began to mess ...
4
votes
1answer
384 views
Darts — Assisting Console Program for Track-Keeping & Statistics
Since I bought a professional steel-darts-kit two weeks ago, I created this little python console program that aids me with track-keeping of the game score and further statistical data I may need in ...
1
vote
1answer
298 views
Makefile for CGI program using SQLite library
I am developing a CGI program in C on Linux using gcc, GNU make and the SQLite library. How does my makefile look?
...
0
votes
1answer
530 views
Excel VBA Filtering: AODB vs Autofilter vs SQLite
I have an Excel sheet with data in about 100,000 rows, 16 columns. I have to extract data (one value from the 1 row I find) from this table a few thousand times. I have been using Autofilter to ...
5
votes
1answer
3k views
Python simple Class with sqlite and unit testing
I am trying to learn best practices for OOP and unit testing. I have implemented a simple User class here which checks if the user exists in the database. If yes, then it loads the user data into the ...
1
vote
0answers
31 views
Save Position on the cloud or locally
I have a tracking software. At first I just send the position to the web Service
...
4
votes
2answers
116 views
Scrape a jobs board and keep persistent record
I'm trying to improve my pretty basic coding skills, and I've written this program to scrape a jobs board (I'd ultimately add several) and put the data in a db file with SQLITE3. The code works, but I ...
10
votes
3answers
4k views
