SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
-5
votes
0answers
17 views
Exception in thread “AWT-EventQueue-0” java.lang.NullPointerException [on hold]
I am developing a software for my academic purpose. For that I am using Netbeans IDE,sqlite. When I run the code it gives me following error,
...
0
votes
0answers
18 views
A basic flask Backend for a weather monitor using RasPi
This is the main script. The app when done would have a daemon running on a Raspberry Pi which will use the
...
1
vote
0answers
73 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 ...
3
votes
1answer
34 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
55 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
23 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
95 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
43 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.
...
0
votes
1answer
74 views
Sqlite.swift — Selecting all rows and returning them in an array of tuples
Link to SQLite wrapper
...
2
votes
1answer
112 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 ...
13
votes
3answers
1k 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
77 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
125 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
62 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
106 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 ...
0
votes
1answer
53 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
64 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 ...
3
votes
1answer
110 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 ...
0
votes
0answers
38 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
97 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:
...
2
votes
0answers
238 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
55 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
99 views
0
votes
4answers
246 views
This code manages 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
31 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
71 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
170 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....
4
votes
1answer
524 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.
...
10
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 ...
3
votes
0answers
185 views
SQLite Databse 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
163 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
74 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 ...
4
votes
1answer
98 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?
...
4
votes
2answers
143 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
149 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
482 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
539 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
1k 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
161 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
113 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 ...
7
votes
1answer
376 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
68 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.
...
1
vote
0answers
94 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:
...
1
vote
1answer
42 views
Queries using multiple tables and ANDs: should that be avoided?
This is a part of a project I am working on. I need advice and criticism regarding the data base design and general approach to querying the data. I am not at all experienced with relational data ...
1
vote
1answer
351 views
Key Value Store for Android on top of Sqlite3
I wrote this simple key-value interface on top of Sqlite3 to use in my Android app. I am using this to persist Java objects as strings converted using Gson.
The public API has 3 methods.
get(...
2
votes
1answer
332 views
Basic CRUD application for Product, Category & Location with SQLite
I improved the code from my previous question.
At this moment, the 3 entities have not yet a connection with each other. They should only be available for CRUD actions in a SQLite database.
I would ...
4
votes
2answers
126 views
ProductManager: a basic CRUD for products with SQLite
I would like to have a review of this basic CRUD application so I can improve and learn from your experience. The code can be found here.
Design pattern/coding principles improvement that could be ...
3
votes
2answers
98 views
Advanced CSV-to-SQLite converter
I just wrote an advanced CSV parser that translates CSV to SQL(SQLite Compatible) statements, which are then inserted into the database. It translates variable names in the CSV to values defined in ...
0
votes
1answer
3k views
WPF filling a DataGrid
I'm creating a WPF application with a DataGrid. I'd like some advice on the code I've written:
...
6
votes
2answers
232 views
Terrain height map generator
I wrote a Perl script that implements the algorithm described in this
article to generate terrain height maps. The idea is to raise a random hill \$i\$ of size \$r_i\$ centered at point \$(x_i, y_i)\$...
