Questions tagged [sqlite]

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

Filter by
Sorted by
Tagged with
4
votes
1answer
416 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
323 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
556 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
117 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
6k views

Python class to manage a table in SQLite

Module name: database.py Code: ...
1
vote
0answers
34 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: ...
5
votes
1answer
87 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
1k 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
134 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
301 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
2k 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
175 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
372 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
38 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
139 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
102 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 ...
4
votes
2answers
5k views

Using SQLite in WPF Project

I am new to WPF and SQLite. I want to use a SQLite database in my project for managing accounts. I create a helper class for the SQLite connection and CRUD operations, which I initialize in my ...
1
vote
2answers
142 views

Code for writing and reading from the database

I created code for inserting and retrieving data from a specific table. I tried to optimize it and make it as beautiful and easy to read as I can, but maybe (almost certainly) I'm missing something. ...
3
votes
0answers
3k views

Python SQLite class that returns resuls as dict

I'm using the below function for a small project. This works but I know this is not the best way. Any help in improving performance (or any native ways supported by Sqlite) is highly appreciated. <...
7
votes
2answers
2k views

Fetch live data from SQLite

I'm writing a small Python script which needs to fetch live data from a database (I'm using SQLite 3 for now). I may reuse this function for a lot of scripts. Can this code be made better? ...
4
votes
1answer
1k views

Express routing with a login action using SQLite

I'm new to Express and SQL, so I don't know the conventional ways of combining the two. Right now I have done it the following way: ...
2
votes
1answer
786 views

Reading multiple CSV files and asynchronously update SQLite

My console app needs to read several big CSV files to update its data, which are stored in a SQLite database. I am new to C# and would like to know if there are ways to improve this sample code I ...
1
vote
0answers
170 views

Sync SQLite databases using threads and a Service

I have an Android app that collects data in n number of SQLite databases. The user decides the value of n in runtime. A Service is in charge of sending that data to our server. We used to do this with ...
4
votes
1answer
684 views

Backup a SQLite database

I want to backup a single SQLite database daily up to 30 days back, but I also want to keep at least 2 backups at all times (i.e. if there have been no backups in the last 30 days because the database ...
2
votes
1answer
2k views

Loop to streamline pandas dataframe to_sql

This code gives me what I am looking for. But I'm just thinking how I can streamline the if statements because I would be repeating myself a couple of times, and ...
2
votes
0answers
763 views

Inserting large datasets into SQLite db becomes very slow over time

I'm using the program below to insert values from very large .csv files (~2.5 million lines) into an SQLite DB. It starts very fast, but begins to slow over time, before eventually hanging ...
7
votes
1answer
2k views

Efficiently adding huge amounts of data from CSV files into an SQLite DB in Java

I'm trying to parse values from a CSV file to a SQLite DB, however the file is quite large (~2,500,000 lines). I ran my program for a few hours, printing where it was up to, but by my calculation, the ...
1
vote
0answers
315 views

Simple websocket loop that outputs on an interval

This is a simple app, made with koa, that grabs a question from a database of questions and sends them over websocket. It feels really messy to me. ...
1
vote
1answer
6k views

Sqlite.swift — Selecting all rows and returning them in an array of tuples

Link to SQLite wrapper ...
2
votes
1answer
2k views

List<List<string>> vs DataTable

I have an application which uses SQLite. In that database I have several tables that I need to be able to read and update in my application. Often I need to 'cross-reference' these tables to get the ...
14
votes
3answers
2k views

Find my colleagues

I recently finished the Using Databases with Python course. To figure out whether I really understood what was being taught, I build an application which does roughly the same but uses a different ...
5
votes
1answer
860 views

Extracting a conversation from a Skype sqlite database

I've made this code to extract a conversation from a Skype database file with a certain user ID, all this being specified as a command line argument. Since Skype uses SQLite to store the messages I ...
6
votes
1answer
225 views

Car leasing system - add lease to database

I just came back to programming and decided to create a car leasing system (GitHub page here.) to teach myself about databases, gui programming and web development. And I would like some input on what ...
1
vote
1answer
4k views

Restoring data from database to list with SQLite

I have a Winforms project in which I have a screen which loads a questionnaire. It restores answers the user has previously entered by restoring the saved results from the database to a single list (...
2
votes
3answers
704 views

Storing quiz questions in SQLite

I am creating my first android app. It is going to be a quiz. There are 40 different question categories and each category has its own database table. I am writing all questions into a sqlite database ...
1
vote
1answer
706 views

DatabaseHelper with multiple tables

I am programming my first android app. It is going to be a quiz. It will have 40 different categories of questions and for each category I am going to have a SQLite Table, which holds the questions ...
3
votes
1answer
170 views

Activity time & duration tracker

This is my first attempt at creating a simple Python tool that tracks the time of certain activities retrieved from a database. After stopping the timer, this tool writes the duration of the activity ...
2
votes
1answer
166 views

Chat Application

I've written a backend for a chat app but I'm not sure, if I'm following all the SOLID principles and if my code is clean enough. IModel interface for my db ...
1
vote
0answers
543 views

Web Scrape, Save to file, Search file and store to Sqlite3 in Python

I have been working on this mini project that I stumbled upon on a freelancing site. This is my first attempt on web scraping. This basically grabs the text file from the target URL and save it to a ...
1
vote
1answer
125 views

Comparing strings with contents of columns

I wrote the following lines of code to compare some strings with contents of columns (string) in SQLite database: ...
3
votes
1answer
1k views

Android generic SQL database handler

Starting with the fact that creating the classic database handler in Android is really annoying and it usually takes a lot of time since you have to create one handler for each object, I thought at ...
0
votes
1answer
130 views

5 input based search form for Android

I've been trying to look for a better way in which a user has up to 5 inputs in which they can search for results in a database. I have 2 EditTexts in which the ...
3
votes
1answer
227 views

SQLite database for books

First, my Book object: ...
2
votes
4answers
11k views

Managing a SQLite Database Connection

When the application connects to the database it keeps the connection open until the user closes the file using File->Close. Is this bad practice? Should I be opening and closing the connection ...
4
votes
1answer
33 views

Places and their PlaceCategories

I'm going to start small here because I actually have several questions but I'll go one at a time. In the app I am making to better learn Java/Android/SQL/OOP, I have a page where a user can define ...
3
votes
1answer
199 views

SQLite database for a micro/tumble blog application

I'm creating a personal website where, among other things, there is a blog, or a "microblog" (I'm still not sure how to define the two), where I will be writing articles and having users, who will ...