Sqlite or MySql? How to decide?
Any good rules of thumb on how to decide which of the two to use?
And, if you take over an Sqlite d/b, and the system is expected to "get much larger", how to decide whether to stick with it or move to MySql?
In MySQL I can get the checksum of the table like: CHECKSUM TABLE 'TableName' How can I calculate check sum of the table in SQLite? Are there any alternatives? EDIT: Do the SQLite checksum(calculated
Being new to elastic search I have few questions on it. 1) How nodes in cluster communicate with Cluster in Elastic-Search? 2) How we decide in which node we should store document or how can we distri
I'm new in the android developing. I need to write some simple application - and i need to decide what will be the target version. I don't know how to decide this - because i want to support the most
I'm developing my first app and using the following code i see what is my SQLite version: Cursor cursor = SQLiteDatabase.openOrCreateDatabase(:memory:, null).rawQuery(select sqlite_version() AS sql
If you take a look at the picture I provided, on the left hand side there is a table. This table loads SQLite data. The SQLite data has some data retrieved from a MYSQL database. The SQLite data is th
HI everybody, i have a question。 A sqlite have about 15 tables,and mysql same.i want sqlite to sync mysql every hour,what can i do? i have a idea ,use a (script / php) to export sqlite'tables value an
I'm wondering what guidelines you guys are using for determining the structure for your Namespaces. When do you decide something warrants it's own Namespace? I read in a forum discussion or article th
How do you guys decide that you should be wrapping the sql in a transaction? Please throw some light on this. Cheers !!
First of all, I'm swiss, so forgive me if I mistake; My english is not so rich. I was wondering if there is an easy(or less not so hard) way to use MySQL instead of SQLite. The only method that I can
Please help me to find the sqlite equivalent of the below query. Tried searching a lot. SET @rownum := 0; SELECT * FROM ( SELECT @rownum := @rownum+1 AS rank, id FROM tbl_flight ORDER BY id DESC ) A
how to decide the forecasting method from the ME, MAD, MSE, SDE? for example, there is 4 methods that will be decide. but, the value won't be always greater or smaller among the error of each other. s
The PHP SQLite3 class doesn't contain the filename information, or provides a method to get the main file opened by the SQLite engine. How to determine the filename? This could be interesting in unit
is it possible to connecct, or to copy the data from mysql to sqlite? I just need to store the data from mysql to sqlite. I used mysql because im working on an online app in android and for updating p
When I try this example - as explained in the DBD::SQLite documentation - with sqlite_see_if_its_a_number disabled I don't get any result. With sqlite_see_if_its_a_number enabled I get the expected re
I have a rails application which uses two different types of databases : sqlite3 and mysql2. I did some searching and managed to get this far, my database.yml file looks like this : development: adap
How can I create an encrypted SQLite database that actually stays encrypted or that I can open afterwards. I used SQLite2009 Pro Enterprise Manager that can create encrypted databases, but after typ
This table I created in a SQLite database: CREATE TABLE [tickets] ( [id] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [coupon_id] INTEGER NULL, [size] FLOAT NULL, [phone] VARCHAR(10) NULL, [date] DATE
Just for my curiosity (and future knowledge), how does Entity Framework 5 decide when to create a new object vs. referencing an existing one? I might have just been doing something wrong, but it seems
We are currently using SQLite3 as our database and want to switch it to MySQL before we send our Rails app live via Passenger and Nginx to our Linode Ubuntu 10.04 Lucid box. we set up the msql server
How can I convert my Access Database (.accdb) to a SQLite database(.sqlite)? Please, any help will be appreciated.
I am not sure whether this question fits in here but I'll go ahead and ask as I am really eager to know the answer. I want to decide whether to use the MSF Agile 5.0 template or the Scrum 1.0 template
I recently switched my rails database over from sqlite3 to mysql, and since doing it I've had a ConnectionNotEstablished error when trying to access my server. Here is the full stack trace of the erro
As defined here, the maximum number of compound select term is SQLITE_MAX_COMPOUND_SELECT How can we get this value when we query a sqlite database using a sql command? e.g. select SQLITE_MAX_COMPOUN
I am creating a cocoa base core data application. I would like to protect the sqlite database, prevent to read it out of the application. How?
I recently read this Question about SQLite vs MySQL and the answer pointed out that SQLite doesn't scale well and the official website sort-of confirms this, however. How scalable is SQLite and what a
I want to start using Core Date on iPhone with pre-existing MySQL databases. What's the easiest way to transfer a MySQL database to SQLite? I've tried using SQLite Migrator, but I don't know where to
I am creating a class in .java that gets data from mysql. How can I make sure that the data I got from mysql is based on the userID that logged in mobile? Here is my code that run to get all data from
sqlite> DELETE FROM mails WHERE (`id` = 71); SQL error: database is locked How do I unlock the database so this will work?
HI everybody, i have a question if i have a computer run sqlite , and i want to make sqlite sync Mysql server in the external network. If the data in the sqlite have been (changed/ modified), how can
I just got out of using SQlite3 and it had a great and easily understandable database browser. I have the MySQL 5.5 Server installed on my windows 7 machine right now and its up and running. I just ne
I am working on an Android project and have a problem with SQLite database management. I have downloaded a SQLite Management tool and dont know how to open the database and test. File -> open data
I understand the Ping is to help prevent proxies from closing idle connections. Is there any guidelines w.r.t. how often to ping? Once every second? 10 seconds? Minute? Does it even matter? A prelimin
This question already has an answer here: How to sync SQLite database on Android phone with MySQL database on server? 5 answers I am building an Android app which will take some data and images
Just out of curiosity, if I am creating a program installer, how should I decide in which Program Files directory to install to? On 32-bit systems, the environmental variable %programfiles% is god
I need to choose between SQLite and MYSql. I am a little confused on what to choose. I know that both database engines have no recursive query mechanisms and SQLite doesn't support stored procedures.
Will the LIKE keyword use the index in SQLite and/or MySQL? I would understand that a wildcard match might not use the index, but how about a starts with comparison?
Please help me rewrite this query from MySQL to SQLite format: SELECT MAX(pubdate) as pubdate, COUNT(DISTINCT post_id) AS count, DATE_FORMAT(pubdate,%b-%y) as month FROM posts WHERE pubdate >= DA
SQLite is a single-file based database and MySQL is a normal database. That's great, but I'm not sure which is faster where or better for what...what are the pros and cons of each option?
We have a website that uses SQL (currently SQLite3) to store entrants into a competition & the server side language is python & uses the module sqlite3. It turns out that the webhost runs pyth
I inherited a project from a colleague that left the company. While examining his code, I got confused by something. After he receives quite a big amount of data from the server, he saves this data to
I have a sqlite DB in a Document Folder application. I store data from NSDictionary in sqlite DB. I want how to understand how many rows there are in the sqlite database and put it in NSString variabl
I need to use SQLite in linux/ubuntu and I want to use sqlite like #include in my project in eclipse, how can i do that? thanks
Is there some standard way to get the last AUTOINCREMENT'd value which works in both MySQL and SQLite3? I'm using PHP, so if there's some PDO way to do it, that's fine. Please help me with an example
in my application, I have pdf files. I want to save those pdf files into my database. I am using SQLite as my Backend. How can I format those pdf file into bytes.
From how to store 6:00pm in sqlite database in android, I know that for SQLite, there is no data type TIME. So, if I want to store time(year,month,day,hour,min,sec), how can I create that column? I
I'm writing a desktop application to do vector drawing in C++, and considering using sqlite to back my undo/redo feature. Has anybody used sqlite for undo/redo features? How does it work out for you?
I am trying to understand structural patterns. Structural pattern definition: Structural patterns are concerned with how classes and objects are composed to form larger structures. Structural class
How do I get the (extended) result/error code from an SQLite query in Python? For example: con = sqlite3.connect(mydb.sqlite) cur = con.cursor() sql_query = INSERT INTO user VALUES(?, ?) sql_data
I'm struggling to find a good tool to help me migrate a MySQL database to SQLite. I've seen a couple of different Perl scripts (including one discovered here), but they do not appear to work correctly