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 databases and the combination works great. In less than one morning I successfully ported the Northwind sample application to MyOBC+MySQL. I had to fix a couple of queries that wouldn't translate, but other than that it worked like a charm. And one of the best reasons to go with such a combination is that Access can save named queries, which can then be combined. For example: qryProductsList: SELECT products.ProductID, products.ProductName, products.UnitPrice, products.SupplierID FROM products ORDER BY products.ProductName; qrySuppliersList: SELECT suppliers.SupplierID, suppliers.CompanyName FROM suppliers ORDER BY suppliers.CompanyName; qryCombinedProductsAndSuppliersList: SELECT qryProductsList.ProductName, qryProductsList.UnitPrice, qrySuppliersList.CompanyName FROM qrySuppliersList INNER JOIN qryProductsList ON qrySuppliersList.SupplierID = qryProductsList.SupplierID; MySQL by itself doesn't provide this kind of capability. I find it enormously valuable. Just my $.02. Arthur - 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 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 Access Like front end that is actually useful and featureful (Access is crap, but it's a better database frontend than currently exists). (mysql, query) DSL -- I reniad lin ne mor, nuithannen In gwidh ristennin, i fae narchannen I lach Anor ed ardhon gwannen (Soundtrack LOTR - and it's not LATIN) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL as a desktop DB
Hi Arthur, Which version of MySQL / MyODBC are you using? I tried building an app with an Acc2000 frontend and a MySQL backend using MyODBC and kept running into a problem where the record being edited would become 'locked' and wouldn't allow me to update (from memory it was something along the lines of the table reporting it was busy performing another action or similar). This frustrated me enough that I finally gave it away and now use SQL Server as my 'big backend.' Regards, M. -Original Message- From: Arthur Fuller [mailto:[EMAIL PROTECTED]] Sent: Monday, 30 September 2002 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 databases and the combination works great. In less than one morning I successfully ported the Northwind sample application to MyOBC+MySQL. I had to fix a couple of queries that wouldn't translate, but other than that it worked like a charm. And one of the best reasons to go with such a combination is that Access can save named queries, which can then be combined. For example: qryProductsList: SELECT products.ProductID, products.ProductName, products.UnitPrice, products.SupplierID FROM products ORDER BY products.ProductName; qrySuppliersList: SELECT suppliers.SupplierID, suppliers.CompanyName FROM suppliers ORDER BY suppliers.CompanyName; qryCombinedProductsAndSuppliersList: SELECT qryProductsList.ProductName, qryProductsList.UnitPrice, qrySuppliersList.CompanyName FROM qrySuppliersList INNER JOIN qryProductsList ON qrySuppliersList.SupplierID = qryProductsList.SupplierID; MySQL by itself doesn't provide this kind of capability. I find it enormously valuable. Just my $.02. Arthur - 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 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 Access Like front end that is actually useful and featureful (Access is crap, but it's a better database frontend than currently exists). (mysql, query) DSL -- I reniad lin ne mor, nuithannen In gwidh ristennin, i fae narchannen I lach Anor ed ardhon gwannen (Soundtrack LOTR - and it's not LATIN) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 the behaviour of your front end (You probably will). The front end will run great until the next major update of MSOffice. It will again make a lot of changes without backward compatibility. This needn't be a problem If you are in control of the migration. But, if your IT department decides to migrate to a new version of MS Office catching you unprepared, your database will be without functional or with a misbehaving front end until you fix the code. I quit using Access and migrated my front end to Apache/PHP running on the same (linux) server as the database (an old pc found in the trashbin because it wasn't fast enough to run windows 95). -Original Message- From: Michael T. Babcock [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 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 to MySQL through MyODBC? PS, SQL ... Query ... -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL as a desktop DB
I have tried this but some queries that run on Access failed to run on MySQL. I had this problem with INNER JOIN Thanks Emery - Original Message - From: Gerben Gieling [EMAIL PROTECTED] To: Michael T. Babcock [EMAIL PROTECTED]; David Lloyd [EMAIL PROTECTED] Cc: Adam Parker [EMAIL 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 the behaviour of your front end (You probably will). The front end will run great until the next major update of MSOffice. It will again make a lot of changes without backward compatibility. This needn't be a problem If you are in control of the migration. But, if your IT department decides to migrate to a new version of MS Office catching you unprepared, your database will be without functional or with a misbehaving front end until you fix the code. I quit using Access and migrated my front end to Apache/PHP running on the same (linux) server as the database (an old pc found in the trashbin because it wasn't fast enough to run windows 95). -Original Message- From: Michael T. Babcock [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 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 to MySQL through MyODBC? PS, SQL ... Query ... -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL as a desktop DB
In also belive that MySQL is very good in a single environ ment. You can try out some very good GUI front end clients like MySQL-Front and SQLyog. Since MySQL-Front has been discontinued, SQLyog is a very good option. Insane - Original Message - From: Gerben Gieling [EMAIL PROTECTED] 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 there is a disadvantage in using Microsoft Office applications. If you use Visual Basic code to program the behaviour of your front end (You probably will). The front end will run great until the next major update of MSOffice. It will again make a lot of changes without backward compatibility. This needn't be a problem If you are in control of the migration. But, if your IT department decides to migrate to a new version of MS Office catching you unprepared, your database will be without functional or with a misbehaving front end until you fix the code. I quit using Access and migrated my front end to Apache/PHP running on the same (linux) server as the database (an old pc found in the trashbin because it wasn't fast enough to run windows 95). -Original Message- From: Michael T. Babcock [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 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 to MySQL through MyODBC? PS, SQL ... Query ... -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 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 http://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. 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? 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? Thanks for any help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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. 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 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 http://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. 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? 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? Thanks for any help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 http://www.webyog.com/sqlyog Have you ever tried OpenOffice as a Frontend for our mySQL? Would be a powerfull Opensource-Team! -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL as a desktop DB
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | I currently use MS Access as a single-user desktop database. The database is | getting quite large. The largest table has 300,000 rows. Definately a case when an upgrade would help, but maybe it's not essential. We used to use a system here that maintained all its data in a shared access database on a winnt server box. It needed constant maintenance but i think we pushed to mdb up to about 700mb before it finally exploded ;-) | 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? 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 to a MySQL database and then used the old front end by linking the tables into a dummy access db through MyODBC! | 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? Depends on your hardware, but in the MySQL world 300,000 records is considered small. Either way, i think you'll get a lot more performance out of MySQL on a single user system than access. HTH danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2 System Administrator Gas~Elec Safety Systems Tel : 01895 422 997 Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9kWo3UKf+497XC3QRAhYyAJ4zv1bJiPXHA7G2uheSoJ61ANW7zQCgi+Fu /X8BthNnRHBASz/RgTHPg0Q= =SuSt -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 http://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. 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? 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? Thanks for any help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL as a desktop DB
Oh fiddle sticks! I just noticed mySQL-Front has been discontinued. I love that program :( Oh well, I'll check out this SQLyog. Thanks for the tip. Mike -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 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 http://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. 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? 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? Thanks for any help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 considerably slow Access, but probably wouldn't slow MySQL much. I haven't used Access in a long time, but I do remember helping people speed up their Access databases. Usually they created a relational database using the Access wizards, which resulted in a poor design and poor index placement. So the database, while fast at first, would slow as it grew. With any database, you really need to focus on good database design to get good speed. I once created a database in FoxBase that had a table with 1.5 million records. Query times were in the 1-2 second response time. And that was with 10 users running on a 66Mhz server computer. The only way I got that speed was through indexes. On Tuesday, September 24, 2002, at 05:41 PM, Adam Parker 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? -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 to MySQL through MyODBC? PS, SQL ... Query ... -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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? 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? Thanks for any help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 database? How does it compare to Access when it is used like this? I regularly use MySQL on my desktop. Under UNIX, at least, there are all sort of useful utilities that like to hook in. But is it faster than Access in the single-user environment, when dealing with large databases? I have no input, I'm sorry. I don't use M$ on my desktop. Thanks for any help. -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 Access Like front end that is actually useful and featureful (Access is crap, but it's a better database frontend than currently exists). (mysql, query) DSL -- I reniad lin ne mor, nuithannen In gwidh ristennin, i fae narchannen I lach Anor ed ardhon gwannen (Soundtrack LOTR - and it's not LATIN) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 and my Access database. I also use it frequently to export data in a variety of formats (HTML, Excel, Text, etc.). Of course not everyone wants to manually query or export the data. But urSQL is only one front-end, there are now several others available with varying feature sets. Note that none of them are Access, although if you like it that much, you can actually link MS Access to MySQL. Anyway, have a look at the MySQL documentation for several available clients. Several of the available clients meet the needs of many users, so I wouldn't necessarily discredit the usefulness of MySQL in a desktop environment for this reason alone... On Wed, 25 Sep 2002, 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). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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. Different design. Of course it will depend on your table layout and query phrasing. 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). You can use MS Access as a front-end for MySQL, via MyODBC. This is particularly useful when migrating data from Access to MySQL, or when existing users are used to the MS Access interface. On a related note, have you looked at MyCC (MySQL Control Center), downloadable from www.mysql.com. A graphical client for both Linux and Windows. It can't do everything yet, but users say it has a very nice intuitive interface and it's already got quite a following! Regards, Arjen. -- MySQL Training in Auckland and Sydney, http://www.mysql.com/training/ Purchase Training, Support, Licenses @ https://order.mysql.com/?marl __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 need more than queries, it won't work. the nice part, in addition to the point and click queries, is that it'll work with any of your data sources, including access. 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. Different design. Of course it will depend on your table layout and query phrasing. 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). You can use MS Access as a front-end for MySQL, via MyODBC. This is particularly useful when migrating data from Access to MySQL, or when existing users are used to the MS Access interface. On a related note, have you looked at MyCC (MySQL Control Center), downloadable from www.mysql.com. A graphical client for both Linux and Windows. It can't do everything yet, but users say it has a very nice intuitive interface and it's already got quite a following! Regards, Arjen. -- MySQL Training in Auckland and Sydney, http://www.mysql.com/training/ Purchase Training, Support, Licenses @ https://order.mysql.com/?marl __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ www.mysql.com -- John Ragan [EMAIL PROTECTED] 501-228-0317 http://www.CoreReader.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php