SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
0
votes
1answer
78 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
43 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
81 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
54 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
341 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
145 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 ...
1
vote
0answers
659 views
i cannot retrieve image in sqlite [closed]
Getting error in Checkdata.java as icon cannot be resolved or is not a field
I don’t want to insert image through resource folder I want to pick the image from memorycard, (I have inserted code how ...
2
votes
1answer
369 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
314 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 ...
