SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
1
vote
0answers
28 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
0answers
111 views
Review: 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
71 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
50 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 ...
3
votes
2answers
165 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:
Sub addAuthor(ByVal authorlnf ...
2
votes
1answer
914 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
218 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
91 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
136 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
72 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
516 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
156 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
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
411 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, ...
4
votes
1answer
355 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 ...
