HomeHome  PortalPortal  FAQFAQ  SearchSearch  RegisterRegister  Log in  
openFate
openFATE - openSUSE feature tracking
Similar topics
Latest topics
» Difference between 42.2 and 42.1
by findoctr Thu Dec 15, 2016 7:53 pm

» openSUSE Leap 42.1 ?
by findoctr Fri Feb 05, 2016 8:09 pm

» Happy Turkey Day
by findoctr Thu Nov 26, 2015 1:45 pm

» Happy 4th of July!
by bozo Sat Jul 04, 2015 12:56 pm

» It's been a while ...
by bozo Mon Feb 23, 2015 8:34 pm

» Mondo chillers
by bozo Wed Feb 18, 2015 5:11 am

Navigation
 Portal
 Index
 Memberlist
 Profile
 FAQ
 Search
IRC Channel
You can also find us on IRC's freenode.net as #suseunbound.

Share | 
 

 SQLite vs. MySQL Embedded

View previous topic View next topic Go down 
AuthorMessage
bdquick
Admin
avatar

Posts : 583
Join date : 2010-02-22
Age : 38
Location : Central Iowa

PostSubject: SQLite vs. MySQL Embedded   Mon Mar 01, 2010 10:24 pm

Just wondering if anyone might have experience using MySQL embedded and how it is to work with? I have a project that I've started with SQLite, but thinking of switching to MySQL embedded. Just not sure if it would actually be any better.

_________________
I'm here where ever here is.
Back to top Go down
FeatherMonkey
Old Regular
avatar

Posts : 41
Join date : 2010-02-25

PostSubject: Re: SQLite vs. MySQL Embedded   Tue Mar 02, 2010 2:00 pm

Far from knowing but having seen similar questions to me it seems a bit like the old what filesystem should I use? The answer is the one that works for you.

As I hadn't ever seen mysql embedded I only have google but I'm seeing a mixed bag, why stop at those 2 for example, HSQLDB, H2 and Apache Derby (A few I saw mentioned). Then you have things like language api.

But from my crude understanding I really wouldn't expect it to be too different from each other i.e I would expect the pysqlite vs pymysql to be syntactically similar sql is sql. My only real knowledge of SQLite is from django and the cli interface though(vs standard MySQL with php and python), but I found it quite similar statement wise to mysql just have to remember the little syntax quirks.

So really I've not answered but said the one that has a better language api and performs best for your use case scenario.(I have seen mentions that for embedded mysql may not be the best choice, but I still think other things come into play, i.e scalability, language api, DB limits etc..). So to me it would sound like a bench testing or comparison of limits.
Back to top Go down
bdquick
Admin
avatar

Posts : 583
Join date : 2010-02-22
Age : 38
Location : Central Iowa

PostSubject: Re: SQLite vs. MySQL Embedded   Tue Mar 02, 2010 10:50 pm

Yeah I was hoping someone might have knowledge of personally working with MySQL embedded. I've used standard MySQL quite a bit and like it, but for the project I'm working on making sure that the MySQL Engine is running would be a PITA. Plus its another piece to install.

I like SQLite for the fact of the database being 1 file and no server. Just having some troubles with it properly handling foreign keys. The tools for designing and managing the database aren't real impressive, except for SQLite Maestro. Its the best I found, but its missing 1 feature I need. My googlefu is yet to turn up a program that can diff SQLite database structures.

Until last night I didn't realize that MySQL embedded didn't run a separate engine process. I'm going to switch my project to using it, and see how I get along. MySQL has always worked well for me, and the tools are readily available.

The finished program will be a standalone single user Windows app. The end user won't be highly computer literate, so that's why I'm going for simple.

_________________
I'm here where ever here is.
Back to top Go down
FeatherMonkey
Old Regular
avatar

Posts : 41
Join date : 2010-02-25

PostSubject: Re: SQLite vs. MySQL Embedded   Wed Mar 03, 2010 7:00 am

I should really step out you clearly know what you need and are after(I suspect c/c++ as well) but I did find 2 here http://www.filebuzz.com/files/Database_Diff_Tool/1.html that are windows based but prop and not freeware.

http://www.guiffy.com/ or http://www.sqlitecompare.com/

Then the other thing can't you do it in the code(for example http://python.org/doc/2.5/lib/module-difflib.html)? i.e.

SELECT name FROM sqlite_master
WHERE type='table'
ORDER BY name;

I realise that would only give tables then you would need to do the columns, but as only structure surely the overhead would be minimal.

Any way from the sound of things it seems it's choosing the DB you use for you.

In regards to using my googlefu seems to be finding it is just starting the server that is different from normal mysql, the rest looks syntactically the same regardless of language binding(Well php and python).
Back to top Go down
bdquick
Admin
avatar

Posts : 583
Join date : 2010-02-22
Age : 38
Location : Central Iowa

PostSubject: Re: SQLite vs. MySQL Embedded   Thu Mar 11, 2010 10:07 pm

Well as it turns out I've changed to standard MySQL. Hopefully the separate engine won't be a problem. SQLite3's single data file would have been nice, but the database kept corrupted on me. Wasn't handling foreign keys properly, and I don't have time to fight it. I at least know MySQL is stable and will easily handle what I'm doing.

_________________
I'm here where ever here is.
Back to top Go down
FeatherMonkey
Old Regular
avatar

Posts : 41
Join date : 2010-02-25

PostSubject: Re: SQLite vs. MySQL Embedded   Fri Mar 12, 2010 12:31 pm

Curious did you actually try mysql embedded? i.e was there a reason for choosing normal mysql over it?

You had me intrigued but as I only really play and lately I've been letting django do all the sql stuff didn't really feel motivated enough.
Back to top Go down
bdquick
Admin
avatar

Posts : 583
Join date : 2010-02-22
Age : 38
Location : Central Iowa

PostSubject: Re: SQLite vs. MySQL Embedded   Fri Mar 12, 2010 8:38 pm

There was no native C# connectors for mysql embedded. Another option is to package the mysql server with your program with a new name and start it from your program. Seemed like a PITA to me, and a lot of extra space to waste.

_________________
I'm here where ever here is.
Back to top Go down
FeatherMonkey
Old Regular
avatar

Posts : 41
Join date : 2010-02-25

PostSubject: Re: SQLite vs. MySQL Embedded   Sat Mar 13, 2010 5:31 am

It really did choose it for you.

Strange there isn't as unless I'm mistaken there is a c/c++ one(I would of thought a c# binding would be utilised a fair bit) but I have to admit I know little about them. So quickly went of looking to see how to achieve it with the languages I knew.
Back to top Go down
bdquick
Admin
avatar

Posts : 583
Join date : 2010-02-22
Age : 38
Location : Central Iowa

PostSubject: Re: SQLite vs. MySQL Embedded   Sat Mar 13, 2010 6:33 pm

There is definitely a C++. The C# is coming, but may not be here until MySQL 6.

_________________
I'm here where ever here is.
Back to top Go down
Sponsored content




PostSubject: Re: SQLite vs. MySQL Embedded   

Back to top Go down
 
SQLite vs. MySQL Embedded
View previous topic View next topic Back to top 
Page 1 of 1
 Similar topics
-
» [ANSWERED] Support for official ISO with embedded Update 1
» Need Selenium Webdriver + Excel sheet examples
» [ANSWERED] Support for Windows Embedded 8.1
» How to embed webdriver browser into java GUI/ attach to exsisting browser
» online examination system using php and mysql

Permissions in this forum:You cannot reply to topics in this forum
SUSEUnbound :: Help Section :: Software-
Jump to: