MySQL vs Database Desktop

[fatmbk]

I have always traditionally used database desktop to create tables for database applications within delphi. I was talking to someone yesterday who mentioned that the newer version of delphi are trying to get users to use something called MySQL. I have heard of this but have never used it.

Does anybody use MySQl and what are its advantages over database desktop (or have i got the wrong end of the stick completly!?!?!)

Fatmbk

 

[svanels]

I think that Borland is promoting the use of Interbase, that is their own product, but Delphi can connect to other RDBMS systems and MySQL is just one of them. In other words Delphi supports connection to MySQL, just like Oracle, M$ SQL-Server, Interbase, DB2, Sybase and many others.

Steven van Els
SAvanEls@cq-link.sr

 

[delphiman]

What version of Delphi are you using?
Do you have Interbase installed?
Interbase generally comes with Delphi Professional and Delphi Enterprise.

I use an SQL DataBase which I create with Notepad and save the files with a .GDB suffix. I then use IBServer and IBConsole to create the DataBase. (Even populate it.)

And I won't change.

If you want a model of how to create MyDataBase.GDB contact me via seperate e-mail at delphiman@bigpond.com

 

[jrahma]

Hi,

why seperate email?!!

i want to know how and someone else in future may visit the web site to get more information from experts like you.

can you please post the procedures here?


many thanks
jassim rahma


Jassim Rahma

 

[svanels]

Which procedures? There are many ways to create a database and tables in interbase. You can do it from delphi with the interbase components, the SQL-explorer from borland, the IbConsole, make a script in something like notepad, use a command line utility etc..

Be specific in your questions

Steven van Els
SAvanEls@cq-link.sr

 

[jrahma]

I mean the (steps) because you ask him to contact you on email but I think it will be useful if you post any answer here, that's in general...

any way, thanks...


Jassim Rahma

 

[earlrainer]

MYSQL is an open source database, that means you can use it for free for personal use ,but you might have to pay for commercial use.
It is quite stable and very popular (in fact more then interbase\firebird)

Usage of MYSQL is same like other databases from Delphi using the BDE.Just make a ODBC dsn and connect it.

however delphi 7 (maybe 6 ?) has dbexpress also for connecting to MYSQL.However my personal experience with dbexpress and MYSQL has been terrible.Some buggy dll files which borland replaced etc.

setting up of MYSQl is an issue though, though i think it is become easier now.

 

[jrahma]

now let me ask a question:

if Iam developing a simple delphi applicatioin like a phone book or calender or post-it notes and IU don't want to use MS Access as a database for my application, what are other options you recommend for a personal desktop application, but should be secure so that user can't open it using some DBMS and read all data.


Jassim Rahma

 

[earlrainer]

if its a small application , dont go for databases like MYSQL, Oracle etc, that would be completely illogical.

If not access, then I think text files are the best options. of course you need encryption to protect them

 

[svanels]

A personal desktop application, small records, no access with normal tools etc.., create your own database with File of record.

Look for a good Turbo Pascal book.

Steven van Els
SAvanEls@cq-link.sr