|
Home > Archive > Linux Debian support > May 2007 > Data base for Linux
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Data base for Linux
|
|
| jamiil 2007-05-02, 7:13 pm |
| 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?
Thanks folks!
| |
|
|
| John Hasler 2007-05-02, 7:13 pm |
| jamiil writes:
> What would be the most common database used in Linux Debian?
Probably Mysql.
> The reason I chose Access was because it is the most common Database in
> the MSWin World.
A very poor reason.
> I would like to know if the is one in Linux Debian's Data Base?
I don't understand the question. What problem are you trying to solve?
--
John Hasler
| |
|
| On Wed, 02 May 2007 16:29:23 -0700, 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?
>
> Thanks folks!
mysql is by far the most frequently used.
| |
| gOLdenHaWK3D 2007-05-03, 1:14 am |
| On May 3, 5:41 am, ray <r...@zianet.com> wrote:
> On Wed, 02 May 2007 16:29:23 -0700, jamiil wrote:
>
>
> mysql is by far the most frequently used.
Yes, and you will like it much better than Access. mysql can provide
you with possibilities far more than Access.
And it is efficient and fast too! Try it.
| |
| John Hasler 2007-05-03, 7:13 am |
| ray writes:
> mysql is by far the most frequently used.
Berkeley DB is almost certainly more frequently used than Mysql.
gOLdenHaWK3D writes:
> Yes, and you will like it much better than Access.
Yes, but you may like PostgreSQL or Firebird better yet, or Berkeley DB may
be more suitable for your purpose (which is what?). Don't fall into the
popularity trap.
--
John Hasler
| |
|
| 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.
| |
| Michael Fierro 2007-05-03, 7:14 pm |
| On 2007-05-02, jamiil <jalqadir@gmail.com> rambled on thusly:
> 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?
MySQL is probably the most popular, but it is a full-blown DBMS. If you're
looking for a stand-alone database a la Access, you probably want to look
into using sqlite.
--
Michael Fierro (aka Biffster) biffster@NOSPAM-REALLYgmail.com
http://apt-get.biffster.org Y!: miguelito_fierro AIM: mfierro1
--
"And they're all rated X. M O O N, that spells X." - Tom Cullen, The
Stand
| |
| Phil Stovell 2007-05-04, 7:14 am |
| On Thu, 03 May 2007 18:05:22 +0100, Joe wrote:
> I don't believe there is any Linux application which works with the
> proprietary MDB database format of Access.
OO Base:
http://www.openoffice.org/product/base.html
--
Phil Stovell, Hampshire, UK
| |
| gOLdenHaWK3D 2007-05-04, 1:13 pm |
| On May 4, 12:11 pm, Phil Stovell <p...@stovell.org.uk> wrote:
> On Thu, 03 May 2007 18:05:22 +0100, Joe wrote:
>
> OO Base:http://www.openoffice.org/product/base.html
>
> --
> Phil Stovell, Hampshire, UK
Yup. you are right. I saw OO Base. It was asking for an MDB file to
work on. Maybe it can be the thing required here,
| |
| jamiil 2007-05-04, 7:13 pm |
| On May 2, 8:41 pm, ray <r...@zianet.com> wrote:
> On Wed, 02 May 2007 16:29:23 -0700, jamiil wrote:
>
>
> mysql is by far the most frequently used.
Well, the program I am handling dumps all the data into a database, at
the time of development Access was the best choice, 1995 I think, now
we want to change that. Please note that one of the features of this
application is that when the computers are not being used the
applications sends the database repository to a data-pool. Later when
the conditions are right the data is sent for analysis. So far it
works very nicely so we want to keep it as is. The only thing I want
to change is the RDBS.
John is right, it was a poor choice, but that is what happens when you
get a skimpy budget and a bunch of archaic-ready-to-retired
executives, hihihi.
Sorry man, I had to get it out of my chest.
| |
|
| On Fri, 04 May 2007 14:48:21 -0700, jamiil wrote:
> On May 2, 8:41 pm, ray <r...@zianet.com> wrote:
>
> Well, the program I am handling dumps all the data into a database, at
> the time of development Access was the best choice, 1995 I think, now
> we want to change that. Please note that one of the features of this
> application is that when the computers are not being used the
> applications sends the database repository to a data-pool. Later when
> the conditions are right the data is sent for analysis. So far it
> works very nicely so we want to keep it as is. The only thing I want
> to change is the RDBS.
>
> John is right, it was a poor choice, but that is what happens when you
> get a skimpy budget and a bunch of archaic-ready-to-retired
> executives, hihihi.
>
> Sorry man, I had to get it out of my chest.
Being recently retired (three years ago) but NOT an executive; I know what
you mean, and I feel your pain!
| |
| Linonut 2007-05-05, 7:13 am |
| After takin' a swig o' grog, sk8-365 belched out this bit o' wisdom:
>
> Have no real experience with it, but Dia is reportly good. See here
> for more: http://www.gnome.org/projects/dia/
Dia is a diagrammer (similar to Visio), not a database.
--
Press "Any" key to continue.
| |
| Linonut 2007-05-05, 7:13 am |
| After takin' a swig o' grog, John Hasler belched out this bit o' wisdom:
> ray writes:
>
> Berkeley DB is almost certainly more frequently used than Mysql.
>
> gOLdenHaWK3D writes:
>
> Yes, but you may like PostgreSQL or Firebird better yet, or Berkeley DB may
> be more suitable for your purpose (which is what?). Don't fall into the
> popularity trap.
Use PostgreSQL over mysql if you need it to scale well and have
bullet-proof data integrity.
--
Reinvent yourself! -- Bill Gates
| |
|
|
| jamiil 2007-05-05, 7:13 pm |
| On May 5, 8:12 am, Linonut <lino...@bellsouth.net> wrote:
> After takin' a swig o' grog, John Hasler belched out this bit o' wisdom:
>
>
>
>
>
> Use PostgreSQL over mysql if you need it to scale well and have
> bullet-proof data integrity.
>
> --
> Reinvent yourself! -- Bill Gates
Yes, I think that PostgreSQL is a bit more on the side of what I am
looking for, however, I would like this database to be also MS-WIN
compatible. Any body?
Thanks!
| |
|
| 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?
>
> Thanks folks!
>
Filemaker Pro is very easy and powerful. Very common too.
| |
| John Hasler 2007-05-06, 1:13 am |
| 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 there is one in Linux Debian's Data Base?
Pete writes:
> Filemaker Pro is very easy and powerful. Very common too.
Where is the Debian package to be found?
--
John Hasler
| |
|
| jamiil wrote:
> On May 5, 8:12 am, Linonut <lino...@bellsouth.net> wrote:
>
> Yes, I think that PostgreSQL is a bit more on the side of what I am
> looking for, however, I would like this database to be also MS-WIN
> compatible. Any body?
>
http://sourceforge.net/projects/pgsql/
| |
|
|
"John Hasler" <jhasler@debian.org> wrote in message
news:873b2absz3.fsf@toncho.dhh.gt.org...
> jamiil wrote:
>
> Pete writes:
>
> Where is the Debian package to be found?
> --
> John Hasler
Just wasn't sure Access was most commonly used. We use FM Pro throughout the
corporation. I suggest that they have a LINUX version. Sorry for misleading
you.
| |
| Gerhard Gonter 2007-05-29, 7:12 pm |
| On Sat, May 05, 2007 at 03:23:58PM -0700, jamiil wrote:
> Yes, I think that PostgreSQL is a bit more on the side of what I am
> looking for, however, I would like this database to be also MS-WIN
> compatible. Any body?
PostgreSQL runs just fine on Windows, either as standalone
version or within Cygwin. So, what else would you expect
for MS compatibility?
Cheers!
GG
|
|
|
|
|
