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

learn more… | top users | synonyms

3
votes
1answer
106 views

Seeding a file with fake records - doing concurrent updates

I need to seed a database with user data. When trying to write records to a file using sqlite3 with node, I tried writing the logic in a naive manner, without any error checks - but it was failing ...
5
votes
2answers
203 views

Using an AsyncTask to populate a ListView in a Fragment From a SQLite table

This is the first time that I have played around with AsyncTask in Android and I wanted to make sure I'm using it correctly. The idea is I'm grabbing all the rows from a table in the database using ...
10
votes
2answers
125 views

Another way to run reports on a SpiceWorks SQLite database using a linked server in SSMS?

I created a linked server in SSMS so that I could run reports on a SpiceWorks SQLite database. there are a few quirks in the whole system. These simple queries are becoming some of the most ...
3
votes
1answer
31 views

Finding users with the highest Following vs. Friends ratio

I am trying to find the users who have the highest "Following vs. Friends" ratio in my Twitter timeline. I have a SQLite database of the users in my Twitter timeline and each column contains data ...
7
votes
1answer
141 views

SQLite Helper Class in C#

Here is a SQLite Helper Class I created. Any input appreciated, including security and simplification. ...
5
votes
3answers
170 views

Code optimization for SQLite result set parsing

I am retrieving information from an SQLite database that gives me back around 20 million rows that I need to process. This information is then transformed into a dict of lists which I need to use. I ...
2
votes
1answer
157 views

Unit of Work with Generic Repository Pattern MVVM, vol. 3

Continuation of this question: https://codereview.stackexchange.com/questions/36561/unit-of-work-with-generic-repository-pattern-mvvm-vol-2 I have made some modifications: Implement lazy-loading ...
1
vote
1answer
288 views

Unit of Work with Generic Repository Pattern MVVM, vol. 2

Continuation of this question: Unit of Work with Generic Repository Pattern MVVM I have made some modifications: Interfaces aren't forced to implement IDisposable Removed the finalizers Rebuilt UoW ...
4
votes
1answer
644 views

Unit of Work with Generic Repository Pattern MVVM

I have been writing the application. I meant to implement a repository pattern with Unit of Work. Is it correctly done? Can you make a code review? I use SQLite ...
2
votes
2answers
198 views

I need code review on using singleton to access local database

As I get to some performance issues in my app and find that I use database access in a bad way. So I decided to move to singleton pattern. I need someone to review this code and confirm me that I made ...
4
votes
1answer
286 views

Converting latitude and longitude coordinates from CSV using web service

I am working on converting a mailing list that has longitude and latitude coordinates within the CSV file. This script I came up with does what I need, but this is my first real-world use of python. I ...
2
votes
2answers
157 views

Improving SQLITE3 Left Join Performance

I occasional write simple yet long Python scripts using SQLITE3 (I'm not proficient with functional or object oriented programming...yet) Usually my sqlite3 is blazing fast. I'm use to looping ...
5
votes
1answer
170 views

Android SQLite Database management

I'd like some opinions about my approach at using SQLite databases in android. Everything seems to work very well, but there may be something wrong that I hadn't noticed. I don't like working with ...
4
votes
2answers
403 views

New to SQLite and am asking for guidance

I'm new to SQLite but have programmed in BASIC (and other languages) for pushing 50 years. Given the sample code extract, please offer suggestions for improvement: ...
2
votes
1answer
3k views

Myth-busting SQLite3 performance w. pysqlite

I've read most of the posts I could find on optimizing SQLite3 performance, such as: How do I improve the performance of SQLite?, Is it possible to insert multiple rows at a time in an SQLite ...
4
votes
1answer
263 views

How do I design this code better?

ALL, I am developing a program that uses GUI and SQLITE. For the GUI I use wxWidgets and use SQLITE API directly. Right now I have a main frame class CFrame and database class CDb. The CDb class ...
2
votes
1answer
128 views

Working with sqlit and moving functions to class (new programmer)

Hello to anyone that wants to give suggestions, and thank you in advance. Here is the code I am using. Very specifically I am using code review for just that (critical opinions from better ...
3
votes
1answer
186 views

how secure is this way of writing and reading with PHP and SQLite?

This is a security question. I'm quite new to PHP and just a beginner in SQLite. For practical, and educational reasons, I'm writing a small PHP site that will serve as one-threaded discussion ...
1
vote
1answer
90 views

SQL vs MongoDB (TCG collection managment) [closed]

I'm designing a web application to help some friends and I manage our card collection. A relational database makes sense to me, so that was my first instinct. The basic schema would like something ...
1
vote
1answer
662 views

Insert dynamic parameters to sqlite database statements

I want to insert parameters dynamically to statements at sqlite. I now write as follows: ...
3
votes
2answers
168 views

How to optimize and shorten this SQL query?

I'm doing a sort of exercise where I'm given a question, and I have to answer it by writing a sql query using a database that I was given. This is the question: What is the cheapest fare for a ...
3
votes
2answers
2k views

Optimizing mass inserts into SQLite

I am trying to optimize inserts from a returned JSON which contains data from multiple tables on the remote server. My code is working, but I just want to figure out a way for it to work better. I ...
2
votes
1answer
465 views

Android SQL in its simplest form [closed]

I thought I would just post a really simple wrapper for those who don't want to implement the retarded SqliteOpenHelper, which is really, really stupid. Below is a class to open/create a database, ...
4
votes
1answer
388 views

Clumsy PHP5 code reading from an SQLite3 database

Some time ago I wrote myself a simple blog. The index page is generated with PHP5, using an SQLite3 database via the variable id handed to it via the URL. The ...
21
votes
6answers
2k views

Can you peer review my database design for a school system?

This system has to manage students, teachers, staff and grading. This is for production and is not a school assignment. As such, please let me know if I can improve on any aspect. :) My main concern ...