Questions tagged [sqlite]
SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
174
questions
9
votes
3answers
469 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 ...
4
votes
0answers
49 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
39 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
43 views
Insert into SQLite3 database
I have a tsv file containing the mapping for two kinds of identifiers.
...
2
votes
1answer
43 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
467 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 ...
1
vote
1answer
53 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
74 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
446 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
41 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
85 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
63 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
69 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
406 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
109 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
278 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
1k 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
65 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
90 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
239 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
498 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
452 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
148 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
483 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
152 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
115 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
160 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 ...
4
votes
0answers
2k 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
81 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
993 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
252 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
217 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
392 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 ...
4
votes
1answer
2k 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
102 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
2k views
1
vote
0answers
33 views
Find record with minimum value in column(s)
I've a table with plant names where I need to select one English synonym for each code:
...
4
votes
1answer
80 views
Optimize and accelerate bash script to transform XML to SQLITE
I have this script in which I read an XML and I pass it to CSV and at the end of the script I transform it into SQLITE
...
6
votes
2answers
769 views
Loading records from an XML file into SQLite
I have a script and I need to optimize it to reduce the execution time of this, currently, 6000 lines takes 1 minute and 38 seconds, I would like to reduce the time to take much less and I do not know ...
3
votes
1answer
96 views
Shell script for reading /etc/passwd into SQLite
I want to read 4 columns, namely UID, GID, username and home directory of specific users from /etc/passwd into an SQLite database. I found this to create many ...
2
votes
1answer
271 views
Applying EF core in Universal Windows Apps using a large database
I am building my UWP app and really stuck in the architecture. For the past few days, I have been reading MVVM, Entity Framework, SQLite, Code First, etc and I am confused how I will implement ...
0
votes
1answer
1k views
Loop to check isNullOrEmpty then setVisibility & setText
My code below is working fine but I know it can be done more efficiently using a loop.
I'm checking the VAL (such as description, ingredient2, etc.) which are Strings from my SQL lite Db to see if ...
4
votes
2answers
130 views
Sqlite3 handler for python 3x
this is my first time learning sqlite and I'm still wondering how to do it. I ended up with this sort of library code:
...
2
votes
1answer
303 views
Load data in sqlite
I have written small application for inserting data into sqlite. can you please review.
create data from specified path
create Table into sqlite database
Path format /user/proj/file
...
3
votes
2answers
2k views
Python WebSocket Server + SQLite + Multiprocessing
I have been wanting to learn more about developing web applications using WebSockets so, with the help of various online tutorials, I built a little Python WebSocket server using Tornado and SQLite.
...
