05-03-07 06:14 PM
jamiil wrote:
> Hi folks! What would be the most common database used in Linux Debian?
> I have an app that uses MS-Access as its database. The reason I chose
> Access was because it is the most common Database in the MSWin World.
> I would like to know if the is one in Linux Debian's Data Base?
>
Access is two applications in one, a mediocre single file database
storage system and an excellent Rapid Application Development
system specialising, naturally, in database access.
I don't believe there is any Linux application which works with
the proprietary MDB database format of Access. There are SQL
databases, mysql and PostgreSQL have been mentioned, and an Access
front-end application can more or less talk to SQL databases.
There are one or two gotchas, but that is true of Access with an
MS SQL Server back-end as well.
I run a mysql server and have migrated several Access MDB files
into it, continuing to use the Access forms and reports using
ODBC. I haven't yet found a Linux GUI programming method which
comes close to Access-as-RAD-tool. Unfortunately. I have a
couple of Access applications which don't bear thinking about
in terms of porting to Python-Qt or similar.
[ Post a follow-up to this message ]
|