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
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
130 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
91 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 ...
3
votes
2answers
4k 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
141 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
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. <...
8
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
620 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
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 ...
4
votes
1answer
552 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 ...
1
vote
0answers
619 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
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
1answer
5k views

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

Link to SQLite wrapper ...
2
votes
1answer
1k 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
716 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
202 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
3k 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
557 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
522 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
134 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
163 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
418 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
121 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
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 ...
0
votes
1answer
129 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
213 views

SQLite database for books

First, my Book object: ...
2
votes
4answers
9k 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 ...
2
votes
1answer
161 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 ...
0
votes
1answer
618 views

Simple factory for CRUD operations on Sqlite using Javascript and Q

I have written this implementation and I would love to make it more efficient. While I am indeed requesting a code review/suggestion, I would also love to get feedback on readability and coding style....
5
votes
1answer
9k views

A class to create and modify SQLite3 databases with a terminal

I would like feedback on the class I've written. The purpose is to dynamically create and interact with SQLite3 databases, accepting lists of complete or incomplete statements. ...
12
votes
4answers
5k views

Inserting robot moves into an SQLite3 database

I'm just wondering if you would consider this to be safe from SQL injection. A peculiarity of my program is I need to dynamically access table names depending on my scenario. This is not for ...
5
votes
1answer
2k views

SQLite Database inserting + Unit tests in Java

Genereal Introduction This is my first project which involves a Database which involves testing (especially unit testing) where the quality is really important for me. The long term aim is to ...
1
vote
2answers
579 views

Properly structuring SQLite classes/operations in Android

I am new to Android development and I want to ensure I'm learning decent practices for doing things. Right now this is my database class, which currently allows me to make a new instance of the ...
5
votes
1answer
173 views

Merging trips to the same location with overlapping dates

I have a SQLite database that only contains the holidays for 1 user. I have a new Trip object (newTrip) that has a ...
3
votes
1answer
1k views

Pulling from data from SQLite DB on Android

Apart from merging the 2 get methods, what else can I do to optimise this? Both input and output cannot be changed. Is there a way to iterate a map while writing to it? ...
5
votes
2answers
8k views

Check existence of a row then update a column

not too experienced with SQL, wondering if I can make this better... I am trying to check if a row exists and then add one to the frequency column if it does, if it does not exist it should return ...
3
votes
1answer
367 views

Android SQLite architecture for a task list

I'm writing a simple Android app with a database and am trying to make the right architecture for accessing a database. MainActivity.java ...
6
votes
2answers
6k views

Saving and Loading data with SQLite

I'm in the process of learning SQLite in C# and I've come up with some generic methods for finding and updating data. I would appreciate any pointers with the design of my methods and/or my SQL syntax....
5
votes
1answer
1k views

Unit of Work and repositories in MVVM / Windows 10 app

I’m currently aiming to make my first app for the Universal Windows Platform (UWP) / windows 10. It’s a small app but should follow some best practices patterns (although I’m considering it as a first ...
7
votes
1answer
4k views

Optimizing SQLite SELECT Performance

I need to read Databases which contain 44-50 Tables, with around 5 Million entries in Total (~ 100k entries per Table). The Data consists of Positional Tracking Data in Sports (Players,Refs and the ...
1
vote
2answers
220 views

Reading databases of sports data

I need to read databases which contain 44-50 tables, with around 5 million entries in total (~ 100k entries per table). The data consists of positional tracking data in sports (players, refs and the ...
0
votes
1answer
288 views

Storing results of a game in a sqlite table

This is a section of code in a program I have created to store and review the results of a game based upon the "class_number" the user gives. This section is very bulky and I was wondering how I could ...
8
votes
1answer
812 views

Generic asynchronous SQLite search builder

I am writing a database manager that reads and writes to a local SQLite database on a mobile device. It works pretty well for the most part, but read access is somewhat slow - it takes about 2-5 ...
5
votes
1answer
87 views

SQLite search disregarding spaces and Pinyin tones

I have a column where, pretty much, each entry has numbers (specifically #1-4) and spaces (' '). I wanted to make a query that could avoid having to know these numbers and spaces. ...