SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
-1
votes
0answers
12 views
How to hide 2 incorrect answers and how to identify correct answer (Android Quiz) [on hold]
Just like who wants to be a millionaire game, i want to disable 2 incorrect answer if i click the button HELP and to get the Correct answer, I used button.setVisibility(View.VISIBLE); to show the two ...
0
votes
0answers
21 views
Sqlite.swift — Selecting all rows and returning them in an array of tuples
Link to SQLite wrapper
...
-1
votes
0answers
9 views
Ruby script using Google API [closed]
I am trying to learn some Ruby and started with some simple scripts, could you please provide your opinion ? Have in mind I am not a professional programmer. The idea of the script is to visualize the ...
2
votes
1answer
91 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 ...
11
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 ...
4
votes
1answer
43 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
109 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
49 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
92 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
46 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
54 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
100 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
30 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
94 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
125 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
47 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
86 views
0
votes
4answers
157 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
30 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
55 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
96 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
162 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
105 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
123 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
67 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
72 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
121 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
111 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
286 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....
4
votes
0answers
469 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
745 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
142 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
100 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
338 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
63 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
69 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
38 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
233 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
290 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
120 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
87 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
2k 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
177 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)\$...
1
vote
1answer
133 views
Inserting data into an SQLite database
I've execute this code in Android for inserting 100+ rows in SQLite database.
My current approach takes more time to initialize the database.
...
4
votes
2answers
63 views
SQLite UPDATEs for persons and a subclass
I am using Java with SQLite and I am wondering if I am in the right track onto writing good code i.e. more or less reusable:
SQL scheme:
...
5
votes
1answer
1k views
Nested SQLite transactions in jQuery
I'm using Cordova with jQuery and jQuery Mobile to develop a hybrid app. In this app I need to save data that I get from a server.
The data is a ...
6
votes
1answer
778 views
Multiple Choice Guessing Game
I've built an app for members of an organization I'm in--the app shows the picture of a member with four multiple choice buttons, and the user then tries to guess the member's name. Pretty simple, ...
4
votes
2answers
102 views
Program to provide CRUD operations for a Boxers(Fighter) table in a database
I have been through a few SQLite tutorials and wrote this code on my own to reinforce the principles. The tutorials I went through varied widely in a few areas so this is what I came up with as a ...
1
vote
1answer
29 views
Writing an SQL SELECT statement
I'd like to Select columns from Table 1 with a Row Filter, Select columns from Table 2 and join.
This works but it's a bit verbose. I was wondering if there is a cleaner way to write this.
...
