Questions tagged [sqlite]

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

23 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
0answers
3k views

Real-time bitcoin data feed and storage using websocket framework

I'm trying to create data feed script for real time bitcoin data for OkCoin exchange using their websocket API (documentation) and a database manager for storing. There are two channels I am ...
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 ...
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 ...
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
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,...
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 ...
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 ...
3
votes
0answers
2k 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. <...
3
votes
0answers
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 ...
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 ...
2
votes
0answers
61 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? ...
2
votes
0answers
275 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 ...
2
votes
0answers
813 views

Structured use of Android SQLite transactions

I got tired of following Android-SQLite's transaction idiom, briefly documented here. It requires too much boilerplate code, IMHO, especially when you add the obligatory null checks. So I came up ...
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 ...
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 ...
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 ...
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 ...
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: ...
1
vote
0answers
154 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 ...
1
vote
0answers
614 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 ...
1
vote
0answers
282 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
0answers
415 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
0answers
529 views

C++ generic SqLite 3 table to vector

I just coded method for loading data from SqLite 3 database, it is working and in test run it was successfully checked for no memory leaks: ...