Re: MySQL as a desktop DB

- Original Message - From: David Lloyd [EMAIL PROTECTED] To: Adam Parker [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 8:37 PM Subject: Re: MySQL as a desktop DB Adam, Obviously MySQL would have advantages if I intended to use it as a server database

RE: MySQL as a desktop DB

12:12 AM To: David Lloyd; Adam Parker Cc: [EMAIL PROTECTED] Subject: Re: MySQL as a desktop DB I don't think Access is crap at all. In fact I think it's a) the best RAD front end going for SQL Server and perhaps for MySQL too. I use Access 2000 and 2002 + MyODBC to create front ends to MySQL

RE: MySQL as a desktop DB

[mailto:[EMAIL PROTECTED]] Sent: September 25, 2002 17:34 To: David Lloyd Cc: Adam Parker; [EMAIL PROTECTED] Subject: Re: MySQL as a desktop DB David Lloyd wrote: MySQL in a single user environment is a pain in the arse because of its lack of an Access Like front end that is actually

Re: MySQL as a desktop DB

PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 9:24 AM Subject: RE: MySQL as a desktop DB The combination of Access front end with MySQL or PostgreSQL works great. However there is a disadvantage in using Microsoft Office applications. If you use Visual Basic code to program

Re: MySQL as a desktop DB

] To: Michael T. Babcock [EMAIL PROTECTED]; David Lloyd [EMAIL PROTECTED] Cc: Adam Parker [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 12:54 PM Subject: RE: MySQL as a desktop DB The combination of Access front end with MySQL or PostgreSQL works great. However

RE: MySQL as a desktop DB

I use MySQL as a desktop db. It is alot faster than access, and much more efficient. A great front end I use is phpMyAdmin. www.phpMyAdmin.org -Steve. -Original Message- From: Insanely Great [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 1:58 AM To: MySQL List Subject

RE: MySQL as a desktop DB

also: - mysqlstudio - http://www.mysqlstudio.com mascon - http://www.scibit.com -j -Original Message- From: Steve Bradwell [mailto:[EMAIL PROTECTED]] Sent: September 25, 2002 1:09 PM To: Insanely Great; MySQL List Subject: RE: MySQL as a desktop DB I use MySQL as a desktop db

Re: MySQL as a desktop DB

I think MySQL will be more faster in Desktop environment and if you are adverse to using the text based interface to MySQL then you can try out some GUI avaiable in the market. The best I know are MySQL-Front and SQLyog but since MySQL-Front has been discontinued you can try SQLyog at

Re: MySQL as a desktop DB

it compare to Access when it is used | like this? Very suitable. Simmilar to Brian in his previous post I use MySQL as a desktop db under Linux. The MyODBC connector also provides a good way of accessing data through other applications. When the old system exploded, we initially moved all the data

Re: MySQL as a desktop DB

://www.webyog.com/sqlyog Insane - Original Message - From: Adam Parker [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 3:11 AM Subject: MySQL as a desktop DB I currently use MS Access as a single-user desktop database. The database is getting quite large

RE: MySQL as a desktop DB

: Re: MySQL as a desktop DB I think MySQL will be more faster in Desktop environment and if you are adverse to using the text based interface to MySQL then you can try out some GUI avaiable in the market. The best I know are MySQL-Front and SQLyog but since MySQL-Front has been discontinued you

Re: MySQL as a desktop DB

MySQL is much faster that Access when dealing with large databases. However, 300,000 records is actually quite small, so you may not see any speed difference. I wouldn't be surprised if Access would even be faster at that level. Putting 10 times that amount of records or adding users would

Re: MySQL as a desktop DB

David Lloyd wrote: MySQL in a single user environment is a pain in the arse because of its lack of an Access Like front end that is actually useful and featureful (Access is crap, but it's a better database frontend than currently exists). I've never done it, but have you tried Access linked

MySQL as a desktop DB

I currently use MS Access as a single-user desktop database. The database is getting quite large. The largest table has 300,000 rows. I am considering upgrading the database. How suitable is MySQL as a single-user desktop database? How does it compare to Access when it is used like this?

Re: MySQL as a desktop DB

On Tue, Sep 24, 2002 at 10:41:26PM +0100, Adam Parker wrote: I currently use MS Access as a single-user desktop database. The database is getting quite large. The largest table has 300,000 rows. I am considering upgrading the database. How suitable is MySQL as a single-user desktop

Re: MySQL as a desktop DB

Adam, Obviously MySQL would have advantages if I intended to use it as a server database with concurrent users. But is it faster than Access in the single-user environment, when dealing with large databases? MySQL in a single user environment is a pain in the arse because of its lack of an

Re: MySQL as a desktop DB

That really depends on what you're doing. I use a Windows front-end to MySQL (ursql from http://www.urbanresearch.com/ursql) every day all day to get at several databases. It's not MS Access, but urSQL allows me to use the same interface to query data on my MySQL database and my MSSQL database

Re: MySQL as a desktop DB

Hi David, Adam, On Wed, 2002-09-25 at 10:37, David Lloyd wrote: Obviously MySQL would have advantages if I intended to use it as a server database with concurrent users. But is it faster than Access in the single-user environment, when dealing with large databases? I'd think so, yes.

Re: MySQL as a desktop DB

if your users need queries only, you might check out corereader. it's a free download from http:/www.corereader.com/ . it's a point and click solution for any data source, so the only hard part is the initial data connection. it has built-in security to prevent updates, so if your people