Nov 21, 2009

Sqlite And Mysql - anyone tell me their difference

 		free web hosting
Open Discussion > MODERATED AREA > Computers > Database

Sqlite And Mysql - anyone tell me their difference

kerco
Apr 28 2009, 09:46 PM
Hello all!

Would like to know the difference between SQLite and mySQL. Which is better to use?

Honestly would like to know if server load will be lower with SQLite..

Thanks a lot!

cool.gif cool.gif cool.gif

Comment/Reply (w/o sign-up)

kittycatlover763
Nov 9 2009, 12:24 AM
i'm not exactly sure which one would be better to use.
but with sqlite writing querys is a lot more faster and easier.
also they say "noobs" are better left with sqlite. As long as you don't intend to share the database with any other server or of the sorts >.>

all i advise to you is don't use mysql if you seem to have a basic understanding of sqlite.
i use Postgresql , but i think either Postgresql or sqlite are good choices.

to answer your other question , i would say NO. server load will be faster on sqlite.
actually now i think it's best to use sqlite ;D *hits self in head for being so confusing* xD

Comment/Reply (w/o sign-up)

mahesh2k
Nov 9 2009, 05:48 AM
Both databases are different yet accepts same standard sql syntax. Only thing that is different about sqlite is that it is lightweight,flat file based database. Read more about SQLite here. MySQL is more of server and it is more suitable for scalable applications. Performance of mySQL in enterprise & scalable application is more and reliable than SQLite. SQLite is more suitable for desktop applications. SQLite is most of time used for graphical programs, desktop apps, app that wants to store and ship embedded database.

If you're looking for SQLite as embedded database or portable database then you should check out HSQLdb, H2, Apache derby. If you like SQLite then you'll find these databases useful as well.

Comment/Reply (w/o sign-up)


Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.
Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

This textarea will convert to Rich-Text automatically (IE, Firefox, Chrome)

Similar Topics

Keywords :

  1. Os X Mysql Problem
    help needed (0)
  2. How To Connect Mysql With Jsp ?
    (4)
    after many i tried to connect to mysql with jsp, its was now successful. but i can connect at
    localhost. i wonder why that. can anybody help me ? it was so good if can post complete system. e.g
    (login).....
  3. Php Myadmin
    can't access mysql database (8)
    I have installed XAMPP on my computer. Everything works fine, but when I enter PHPMyAdmin I get this
    warning: "Your configuration file contains settings (root with no password) that correspond to the
    default MySQL privileged account. Your MySQL server is running with this default, is open to
    intrusion, and you really should fix this security hole." So I've changed the password to the
    root account, but then I couldn't access the mysql databases anymore with PHPMyAdmin (I received
    an error that the access was denied). I could change the structures only in php with ....
  4. Mysql Hacks
    (10)
    There are MySQL hacks out there, They can travel from your website to your computers. One of these
    are the MySQL injectors. The injection drops your tables and shuts down the program permanently. Be
    careful of these hacks, as they can destroy your MySQL related websites, programs, etc.....
  5. Creating A Php Login System Using Mysql
    I need help in creating a login system, what I want is a login system (10)
    Hey everyone! I am helping someone make a login system using MySQL databases and a PHP login form.
    I have a fair bit of experiance in HTML and some javascript too. I have virtually no experiance in
    MySQL or PHP. Anybody know of any good PHP login systems that allow you to creat a personalised
    page for each user and when they login the system transfers the user to their page. Another thing
    that the system MUST have is a way of stopping unwanted users entering someones page. CODE For
    example lets say I register and my UN is jesse123 and my personalised pages addre....
  6. The Only Reason I Choose Ms Sql Server Rather Than Mysql
    (2)
    The only reason i choose ms sql server rather than mysql is, MS SQL has more security features!!
    MySQL is lacking a lot in my opinions - Lack in wide char, like nvarchar, I developed some
    application to support chinese letter, and dont know how to build one in mysql - Lack in t-sql
    syntax, like query in query is not fully supported - Does not have today SQL features like BI
    support (today really required) And compare MS SQL to MySQL, the only reason why mysql is
    favourable is - it is free! Dont u guys agree?....
  7. Need Advice On Setting Up Mysql Database.
    I have a huge amount of daily data updates to be inserted. (4)
    First of all, to get the idea of what I am trying to achieve here, please have a look at my
    idea thread, entitled Idea For Using A Cron Job To Grab Daily Travian Map.sql Updates . This gives
    a prelude to the project, what it is for, what it is supposed to do, etc. Now, what I need is
    specific advice on setting up the mySQL database(s) to implement this idea. There is a useful FAQ
    file for how to make use of the map.sql data located on the help.travian.com website, which also
    gives an example of the CREATE TABLE instruction that matches the data in the map.sql fi....
  8. The Best Free Php Mysql Blog
    any idea (5)
    Hi everyone Recently i tried to upload a personal blog. as I know a bit of PHP programming I was
    looking for a free open source PHP blog. first I tried Wordpress out but there was few problems
    that i needed to change php.ini or .htaccess file and also some other PHP settings. as i was trying
    it out on a free web host i didn't have access to php.ini. so i have changed it from Wordpress
    to bblog , i have installed it successfully and i followed it's safety instruction (deleting
    install folder and install.php and CHmod config.php )then i got another problem i ....
  9. Mysql-essential-5.0.51 Installion Problem
    please help me.(urgent) (2)
    Dear friend, please help me. Iam working on php project (matchmaking site). I have downloaded mysql
    essensial 5.0.51. When i was installing mysql 5.0.51, i got following error - Error 1901: Error
    attempting to read from the source installation database: c:\windows\installer\527ec6.msi What
    is solution of this problem ? Iam using windows xp professional version 2002 (service pack 2).
    Please post your reply. Iam waiting for your answer. ....
  10. Mysql Query Problems
    I need some help or a tutorial? (6)
    I seem to be having trouble with getting my Query to post my user's ID numbers. CODE //
    Make a MySQL Connection mysql_connect("localhost", "user", "password") or die(mysql_error());
    mysql_select_db("databasename") or die(mysql_error()); // Retrieve all the data from the members
    table $result = mysql_query("SELECT * FROM members WHERE id='$id'") or die(mysql_error());  
    // store the record of the id table into $row $row = mysql_fetch_array( $result ); // Print out the
    contents of the entry echo $row ."; A little information about my table in my da....
  11. Database With Mysql++
    getting mySQL++ to work with trap17 (7)
    Hi, I'm trying to build an online game and figured the easiest way to do the server list would
    be to make a mySQL database for it; however, I use the con() command on the IP i get from pinging my
    website and I always get an abnormal program termination; however, it will work with the mySQL on my
    own machine. The code is below: CODE #include #include #include #include "pass.h"//holds
    my password (i program at school) int main(void) {     Connection
    con("t3jem3_test","64.69.46.210","t3jem3_t3jem",pass);     Query query = con.query();     query
        Re....
  12. Mysql Datatype Int() Question
    Not sure what value to use inside int() (1)
    Can anyone clarify what the value in int() actually does? CREATE TABLE job_class ( jc_id int(1)
    NOT NULL AUTO_INCREMENT PRIMARY KEY, jc_index int(2) NOT NULL, jc_name varchar(20) NOT NULL, jc_type
    varchar(20) NOT NULL ); I was under the impression that any integer value used inside a () was
    the limit that data-type would have. In the PRIMARY KEY column I was able to add integer values
    1-18. I'm kinda confused now If I can add 2 digit integers there then what is the point of
    assigning values inside brackets() For the varchar() any number put in there does limit....
  13. Mysql
    (7)
    Hi... One of my hosts hasn´t MySQL but i need to develop a login system so I need to know if it´s
    possible to use a MySQL database intalled in another host... If it´s possible can you explain me how
    to do it? Thanks in advance....
  14. Loading File Into Blob Fields To Mysql
    (1)
    Hi all! does any know how to load file into blob filed by sql script?....
  15. Mysql And Sql
    difference??? (7)
    I was wondering what is the difference between MySQL and SQL. I was really confused when i planned
    to do a project recently. This question has haunted me for a long time. Is it both same?....
  16. Mysql Database Copying
    (4)
    Is there anyway to merge 2 databases? I have an XOOPS and SMF both installed with Fantastico, and
    the bridge is not working like the Joomla! one does. (with the seperate db capability) i know how
    to transfer all the tables by hand but depending on how much data you have stored in mysql could
    take a long time. Take short time!? Help me!....
  17. Installing Mysql On Unix, Linux
    (2)
    Download the latest version of MySQL.Choose the latest stable release and, from the stable release
    page, choose the option under "Source Downloads" marked "tarball (.tar.gz)". Download the file into
    a directory where files can be created and there is sufficient disk space. A good location is /tmp.
    Change directory to this location using: 1. % cd /tmp Note that the % character
    should not be typed in; this represents the Linux shell prompt and indicates that the command should
    be entered at the shell prompt. 2. Uncompress the package in the new ....
  18. Mysql Tools Database
    Opensource sql tools... (1)
    You can download mysql query web browser on http://www.mysql.com you also can download plugin
    there...like conector mysql from visual basic ,java,etc with my sql query tool browser you can make
    and maintance youre database sql easily because use gUI interface..!!....


      19. Looking for Sqlite, And, Mysql

Searching Video's for Sqlite, And, Mysql
See Also,
advertisement


Sqlite And Mysql - anyone tell me their difference

Affordable Web Hosting, Low cost Web Hosting - ComputingHost.com