Code Review

Questions tagged [sqlite]

Ask Question

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

173 questions
Info Newest Frequent Votes Active Unanswered
4
votes
0answers
48 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
36 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
42 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
421 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
73 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
445 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
80 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
56 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
68 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
388 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
108 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
261 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
88 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
226 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
477 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
450 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
141 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
469 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
148 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
114 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
876 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
238 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
206 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
381 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
99 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

Python class to manage a table in SQLite

Module name: database.py Code: ...
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
79 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
747 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
266 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
123 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
295 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. ...
0
votes
1answer
37 views

Implementation of callback in database request

I am a complete beginner in JavaScript / Node.js / Express, but have some experience with php. I am trying to pass data from a SQLite database to the console. In my previous attempts, ...

1 2 3 4