free database for Mac OS X?

Le
justaguy
Hi,

I have just one more question about Mac and database other than
FileMaker (Pro) is there any other database that I could freely bundle
with my software package? It appears mySQL (now under Oracle) is no
longer open source

Thanks.
Vidéos High-Tech et Jeu Vidéo
Téléchargements
Vos réponses Page 1 / 4
Gagnez chaque mois un abonnement Premium avec GNT : Inscrivez-vous !
Trier par : date / pertinence
Matt
Le #24003501
On Ven 25 novembre 2011, 22:47,
justaguy
Hi,



Hello,

I have just one more question about Mac and database... other than
FileMaker (Pro) is there any other database that I could freely bundle
with my software package? It appears mySQL (now under Oracle) is no
longer open source...



Il y a d'autres solutions comme PostgreSQL par exemple, que sa licence
permet entre autres œuf Corse, sa redistribution.

Regarde par là l'Anglois :

Thanks.



Je t'en prie mais il serait bien que tu blablates en français car ce
groupe est _francophone_ my dear.

--
echo '' |
tr '[a-z]' '[n-za-m]'
justaguy
Le #24003771
On Nov 25, 4:59 pm, Matt
On Ven 25 novembre 2011, 22:47,

justaguy > Hi,

Hello,

> I have just one more question about Mac and database... other than
> FileMaker (Pro) is there any other database that I could freely bundle
> with my software package?  It appears mySQL (now under Oracle) is no
> longer open source...

Il y a d'autres solutions comme PostgreSQL par exemple, que sa licence
permet entre autres œuf Corse, sa redistribution.

Regarde par là l'Anglois :

> Thanks.

Je t'en prie mais il serait bien que tu blablates en français car ce
groupe est _francophone_ my dear.

--
echo '' |
tr '[a-z]' '[n-za-m]'



Thanks Matt, yes, it appears that PostgreSQL is a desirable option
now, not sure about how easy or difficult it is to install and
configure and run on various Mac OS X computers...

Btw, is it able to import / migrate an Access db?

Best,

Don
Matt
Le #24003921
On Sam 26 novembre 2011, 00:42,
justaguy
Thanks Matt, yes, it appears that PostgreSQL is a desirable option
now, not sure about how easy or difficult it is to install and
configure and run on various Mac OS X computers...



I can't tell you such a thing (i'm using a postgresql packaged by an
accounting software) but after a quick look on the postgresql website
there's a Mac OS X installer there[1] which would be simpler than
compiling the sources if you're not familiar with the Xcode/devtools
thingies.

Btw, is it able to import / migrate an Access db?



According to Postgresql's wiki there are some solutions[2].

Best,



[1] [2]
PS. i'm crossposting to comp.databases.postgresql and
comp.sys.mac.system and set the followup to comp.databases.postgresql
as those are english spoken newsgroups and your question is more
postgresql related.

PPS. grab a *real* newsreader for Usenet; Google's interface really
s*cks

--
echo '' |
tr '[a-z]' '[n-za-m]'
Only Nixon could go to China Blue
Le #24003931
Sqlite is preinstalled on MacOSX. It's also available through CoreData.

--
White folks think they're at the top, | Ha, ha, that is very logical.
ask any proud white male. | I'm whoever you want me to be.
A million years of evolution, | Annoying Usenet one post at a time.
and we get Danny Quayle. | At least I can stay in character.
justaguy
Le #24004031
On Nov 25, 8:10 pm, Only Nixon could go to China Blue
Sqlite is preinstalled on MacOSX. It's also available through CoreData.

--
White folks think they're at the top,  |        Ha, ha, that is very logical.
ask any proud white male.              |       I'm wh oever you want me to be.
A million years of evolution,          |  Annoying Usenet one post at a time.
and we get Danny Quayle.               |    At least I can stay in character.



"Sqlite is preinstalled on MacOSX", does that mean 90% of all Mac
computers (be it laptop or notebook, sold 5 years ago something)?

Many thanks.
Michael Vilain
Le #24004021
In article
justaguy
On Nov 25, 8:10 pm, Only Nixon could go to China Blue
> Sqlite is preinstalled on MacOSX. It's also available through CoreData.
>
> --
> White folks think they're at the top,  |        Ha, ha, that is very
> logical.
> ask any proud white male.              |       I'm whoever you want me to
> be.
> A million years of evolution,          |  Annoying Usenet one post at a
> time.
> and we get Danny Quayle.               |    At least I can stay in
> character.

"Sqlite is preinstalled on MacOSX", does that mean 90% of all Mac
computers (be it laptop or notebook, sold 5 years ago something)?

Many thanks.



Yes.

--
DeeDee, don't press that button! DeeDee! NO! Dee...
[I filter all Goggle Groups posts, so any reply may be automatically ignored]
JF Mezei
Le #24004041
"Sqlite is preinstalled on MacOSX", does that mean 90% of all Mac
computers (be it laptop or notebook, sold 5 years ago something)?




MySQL is pre-installed on OS_X servers (at least up to Snow Leopard). It
was not installed in OS)X, but you can download and install it easily.


SQLlite may be part of OS-X, but I am not sure if there is easy access
to it.
justaguy
Le #24004071
On Nov 25, 10:42 pm, JF Mezei
> "Sqlite is preinstalled on MacOSX", does that mean 90% of all Mac
> computers (be it laptop or notebook, sold 5 years ago something)?

MySQL is pre-installed on OS_X servers (at least up to Snow Leopard). It
was not installed in OS)X, but you can download and install it easily.

SQLlite may be part of OS-X, but I am not sure if there is easy access
to it.



"SQLlite may be part of OS-X, but I am not sure if there is easy
access
to it. ", interesting point, and that's what I was researching an hour
ago, and I seem to draw same conclusion. funny tho how come such an
impressive corporation like Apple wouldn't think of providing an easy
access tool for a useful "platform" if we may call it so?

Thanks.
justaguy
Le #24004061
On Nov 25, 10:14 pm, Michael Vilain
In article









 justaguy > On Nov 25, 8:10 pm, Only Nixon could go to China Blue
> > > Sqlite is preinstalled on MacOSX. It's also available through CoreDat a.

> > --
> > White folks think they're at the top,  |        Ha, ha, tha t is very
> > logical.
> > ask any proud white male.              |       I' m whoever you want me to
> > be.
> > A million years of evolution,          |  Annoying Usenet one post at a
> > time.
> > and we get Danny Quayle.               |    At leas t I can stay in
> > character.

> "Sqlite is preinstalled on MacOSX", does that mean 90% of all Mac
> computers (be it laptop or notebook, sold 5 years ago something)?

> Many thanks.

Yes.

--
DeeDee, don't press that button!  DeeDee!  NO!  Dee...
[I filter all Goggle Groups posts, so any reply may be automatically igno red]



Thanks. And per JF Mezei, now a question is how to get my Access
database into it and be able to use it (data update and retrieval)...
dempson
Le #24004081
justaguy
On Nov 25, 8:10 pm, Only Nixon could go to China Blue
> Sqlite is preinstalled on MacOSX. It's also available through CoreData.

"Sqlite is preinstalled on MacOSX", does that mean 90% of all Mac
computers (be it laptop or notebook, sold 5 years ago something)?



sqlite3 comes preinstalled (as a library and command line tool) at least
on Mac OS X 10.5 and 10.6, so it is on all Macs sold since about October
2007, and older ones (dating back at least to 2004 and for some models
back to 2001) which have upgraded to 10.5.

Whether it is useful for you is a more difficult question to answer. I
haven't seen the thread far enough back to know what you need in a
database (apart from "free"), and that you want to convert data from
Access.

SQLite is basically a library which allows applications to incorporate a
single user SQL database without having to go to the trouble of
implementing it themselves. There is also a command line tool which can
be used to perform actions on database files created by SQLite.

If you are writing an application, you don't need SQLite to be included
with the operating system, because you can download the source code and
build it yourself, linking it directly into your application. (The OS
library just provides a convenient option, which is used by many parts
of Mac OS X, so it avoids the need for multiple copies of SQLite to be
included with the system.)

If you want to get data from Access to anything else, you would probably
need to export the data from Access into a standard file format like
CSV, then import it into the other database.

From a quick glance, the sqlite3 command line tool cannot directly
import CSV files, but it can import text files which have no value
quotations or character esacpes, e.g. a TAB-delimited text file might be
OK (as long as TAB doesn't appear anywhere in the data).

If sqlite3 can't import the data directly then you would need a third
party utility or write your own application or script to preprocess the
data and turn it into something like SQL INSERT statements or a suitably
formatted text file which can be imported.

--
David Empson

Publicité
Poster une réponse
Anonyme