Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

  7. current community

    your communities

    more stack exchange communities

    company blog
The results are in! See what nearly 90,000 developers picked as their most loved, dreaded, and desired coding languages and more in the 2019 Developer Survey.
Code Review

Questions tagged [sqlite]

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

170 questions
info Newest Frequent Votes Active Unanswered
2
votes
1answer
39 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
217 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
50 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
69 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
427 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
66 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
42 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
54 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
316 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 ...
2
votes
2answers
106 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
183 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
58 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
79 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
178 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
54 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
410 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
441 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
120 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
415 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
48 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
128 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
110 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
153 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
76 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
629 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
207 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
176 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
332 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
95 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 ...
9
votes
3answers
2k views

Python class to manage a table in SQLite

Module name: database.py Code: ...
1
vote
0answers
31 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
77 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
680 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
86 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
250 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
904 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
117 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
276 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, ...
4
votes
2answers
129 views

Python Rock Paper Scissors sqlite

I posted some time ago an earlier version of this code and was told about some improvements that should be made. They were mostly about the sql-queries I was using and the DRY-principle. Even though ...
3
votes
1answer
89 views

Retrieve a number in a webpage and store in a SQLite3 db

I'm beggining Python. So I wrote a program which is supposed to get a number of connected people on a forum (like this one : http://www.jeuxvideo.com/forums/0-51-0-1-0-1-0-blabla-18-25-ans.htm) and ...
1
vote
2answers
1k views

Extensive use of exception for database wrapper

My favourite programming language is Java and I usually use JDBC for database operations. I'm using Swift for one of my projects and I should use a database. The problem is SQLite is only available ...

1 2 3 4