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 + M
ust 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,
>
>
A short summary about what the Webpage from www.openoffice.org says:
You definitly can use OpenOffice as MySQL-Frontend.
They are connected via ODBC or JDBC.
Openoffice prefers MySQL 4 because of the advanced features
When MySQL gets out of alpha-state, there might be a more native connection
the
AIL 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
Th
quot;
<[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 i
chael 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 o
> 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
> h
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 d
: 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
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 l
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
con
bject: 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 discontinue
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.w
-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 ma
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 n
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.
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 a
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 a
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 data
19 matches
Mail list logo
