SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
2
votes
2answers
49 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 ...
0
votes
0answers
37 views
Android sqlite approach opinion
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 ...
0
votes
0answers
59 views
New to sqlite, asking for guidance (vb.net)
As the title say, I'm new to sqlite but have programmed in basic (and other languages) for pushing 50 years.
Given the sample code extract, would those of you who know offer suggestions to improve ...
1
vote
1answer
442 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 ...
2
votes
1answer
185 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
72 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
120 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
65 views
SQL vs MongoDB (TCG collection managment)
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
457 views
Insert dynamic parameters to sqlite database statements
I want to insert parameters dynamically to statements at sqlite.
I now write as follows:
tx.executeSql('SELECT Data from Table Where something = "'+ anyvariable+ '"',[],successFn, ...
3
votes
2answers
151 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 ...
2
votes
2answers
1k 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
398 views
Android SQL in its simplest form
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, ...
3
votes
1answer
346 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 SQLite database contains a table called ...
