On Nov 25, 8:10 pm, Only Nixon could go to China Blue
wrote:
> 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.
On Nov 25, 8:10 pm, Only Nixon could go to China Blue
<chine.b...@yahoo.com> wrote:
> 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.
On Nov 25, 8:10 pm, Only Nixon could go to China Blue
wrote:
> 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.
On Nov 25, 10:42 pm, JF Mezei wrote:
> > "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?
On Nov 25, 10:42 pm, JF Mezei <jfmezei.spam...@vaxination.ca> wrote:
> > "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?
On Nov 25, 10:42 pm, JF Mezei wrote:
> > "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?
justaguy wrote:
> On Nov 25, 8:10 pm, Only Nixon could go to China Blue
> wrote:
> > Sqlite is preinstalled on MacOSX. It's also available through CoreDat a.
> "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
justaguy <do...@yahoo.com> wrote:
> On Nov 25, 8:10 pm, Only Nixon could go to China Blue
> <chine.b...@yahoo.com> wrote:
> > Sqlite is preinstalled on MacOSX. It's also available through CoreDat a.
> "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
demp...@actrix.gen.nz
justaguy wrote:
> On Nov 25, 8:10 pm, Only Nixon could go to China Blue
> wrote:
> > Sqlite is preinstalled on MacOSX. It's also available through CoreDat a.
> "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
On Nov 25, 10:42 pm, JF Mezei wrote:
> > "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.
On Nov 25, 10:42 pm, JF Mezei <jfmezei.spam...@vaxination.ca> wrote:
> > "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.
On Nov 25, 10:42 pm, JF Mezei wrote:
> > "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.
SQLite is a 'backend' and would be of little use for customers.
/usr/lib/libsqlite3.0.dylib is part of MacOS X, so the API is available
for programs that call it. Most programs that need some sort of
smallish table-based database use it. For example, Unison uses it to
keep the newgroups on each server it stores. It's 'good enough' and
unencumbered by any licensing (http://en.wikipedia.org/wiki/Sqlite3).
There are lots of GUI front-ends for it. Find one you like, free or
shareware, to use.
SQLite is a 'backend' and would be of little use for customers.
/usr/lib/libsqlite3.0.dylib is part of MacOS X, so the API is available
for programs that call it. Most programs that need some sort of
smallish table-based database use it. For example, Unison uses it to
keep the newgroups on each server it stores. It's 'good enough' and
unencumbered by any licensing (http://en.wikipedia.org/wiki/Sqlite3).
There are lots of GUI front-ends for it. Find one you like, free or
shareware, to use.
SQLite is a 'backend' and would be of little use for customers.
/usr/lib/libsqlite3.0.dylib is part of MacOS X, so the API is available
for programs that call it. Most programs that need some sort of
smallish table-based database use it. For example, Unison uses it to
keep the newgroups on each server it stores. It's 'good enough' and
unencumbered by any licensing (http://en.wikipedia.org/wiki/Sqlite3).
There are lots of GUI front-ends for it. Find one you like, free or
shareware, to use.
In article ,
Michael Vilain wrote:
> SQLite is a 'backend' and would be of little use for customers.
> /usr/lib/libsqlite3.0.dylib is part of MacOS X, so the API is available
> for programs that call it. Most programs that need some sort of
> smallish table-based database use it. For example, Unison uses it to
> keep the newgroups on each server it stores. It's 'good enough' and
> unencumbered by any licensing (http://en.wikipedia.org/wiki/Sqlite3).
> There are lots of GUI front-ends for it. Find one you like, free or
> shareware, to use.
Indeed, searching MacUpdate for "SQLite" produces many tools designed to
work with in including tools to convert various database file formats to
something that works with SQLite.
--
Your time is limited. Don't waste it living someone else's life.
Steve Jobs 1955-2011
In article <vilain-405985.07180326112...@news.individual.net>,
Michael Vilain <vil...@NOspamcop.net> wrote:
> SQLite is a 'backend' and would be of little use for customers.
> /usr/lib/libsqlite3.0.dylib is part of MacOS X, so the API is available
> for programs that call it. Most programs that need some sort of
> smallish table-based database use it. For example, Unison uses it to
> keep the newgroups on each server it stores. It's 'good enough' and
> unencumbered by any licensing (http://en.wikipedia.org/wiki/Sqlite3).
> There are lots of GUI front-ends for it. Find one you like, free or
> shareware, to use.
Indeed, searching MacUpdate for "SQLite" produces many tools designed to
work with in including tools to convert various database file formats to
something that works with SQLite.
--
Your time is limited. Don't waste it living someone else's life.
Steve Jobs 1955-2011
In article ,
Michael Vilain wrote:
> SQLite is a 'backend' and would be of little use for customers.
> /usr/lib/libsqlite3.0.dylib is part of MacOS X, so the API is available
> for programs that call it. Most programs that need some sort of
> smallish table-based database use it. For example, Unison uses it to
> keep the newgroups on each server it stores. It's 'good enough' and
> unencumbered by any licensing (http://en.wikipedia.org/wiki/Sqlite3).
> There are lots of GUI front-ends for it. Find one you like, free or
> shareware, to use.
Indeed, searching MacUpdate for "SQLite" produces many tools designed to
work with in including tools to convert various database file formats to
something that works with SQLite.
--
Your time is limited. Don't waste it living someone else's life.
Steve Jobs 1955-2011
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)...
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)...
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)...
Sqlite is preinstalled on MacOSX. It's also available through CoreData.
Sqlite is preinstalled on MacOSX. It's also available through CoreData.
Sqlite is preinstalled on MacOSX. It's also available through CoreData.
Only Nixon could go to China Blue wrote:
> Sqlite is preinstalled on MacOSX. It's also available through CoreData.
Oh! nous sommes où. En pays inconnu?
--
René
Lascia la spina cogli la rosa
Only Nixon could go to China Blue <chine.b...@yahoo.com> wrote:
> Sqlite is preinstalled on MacOSX. It's also available through CoreData.
Oh! nous sommes où. En pays inconnu?
--
René
Lascia la spina cogli la rosa
Only Nixon could go to China Blue wrote:
> Sqlite is preinstalled on MacOSX. It's also available through CoreData.
Oh! nous sommes où. En pays inconnu?
--
René
Lascia la spina cogli la rosa
On Nov 26, 11:07 am, Tim McNamara wrote:
> In article ,
> Michael Vilain wrote:
>
> > SQLite is a 'backend' and would be of little use for customers.
> > /usr/lib/libsqlite3.0.dylib is part of MacOS X, so the API is available
> > for programs that call it. Most programs that need some sort of
> > smallish table-based database use it. For example, Unison uses it to
> > keep the newgroups on each server it stores. It's 'good enough' and
> > unencumbered by any licensing (http://en.wikipedia.org/wiki/Sqlite3).
> > There are lots of GUI front-ends for it. Find one you like, free or
> > shareware, to use.
>
> Indeed, searching MacUpdate for "SQLite" produces many tools designed to
> work with in including tools to convert various database file formats to
> something that works with SQLite.
>
> --
> Your time is limited. Don't waste it living someone else's life.
>
> Steve Jobs 1955-2011
" many tools designed to work with in including tools to convert
various database file formats to
something that works with SQLite. ",
Could you be more specific? Thanks.
On Nov 26, 11:07 am, Tim McNamara <tim...@bitstream.net> wrote:
> In article <vilain-405985.07180326112...@news.individual.net>,
> Michael Vilain <vil...@NOspamcop.net> wrote:
>
> > SQLite is a 'backend' and would be of little use for customers.
> > /usr/lib/libsqlite3.0.dylib is part of MacOS X, so the API is available
> > for programs that call it. Most programs that need some sort of
> > smallish table-based database use it. For example, Unison uses it to
> > keep the newgroups on each server it stores. It's 'good enough' and
> > unencumbered by any licensing (http://en.wikipedia.org/wiki/Sqlite3).
> > There are lots of GUI front-ends for it. Find one you like, free or
> > shareware, to use.
>
> Indeed, searching MacUpdate for "SQLite" produces many tools designed to
> work with in including tools to convert various database file formats to
> something that works with SQLite.
>
> --
> Your time is limited. Don't waste it living someone else's life.
>
> Steve Jobs 1955-2011
" many tools designed to work with in including tools to convert
various database file formats to
something that works with SQLite. ",
Could you be more specific? Thanks.
On Nov 26, 11:07 am, Tim McNamara wrote:
> In article ,
> Michael Vilain wrote:
>
> > SQLite is a 'backend' and would be of little use for customers.
> > /usr/lib/libsqlite3.0.dylib is part of MacOS X, so the API is available
> > for programs that call it. Most programs that need some sort of
> > smallish table-based database use it. For example, Unison uses it to
> > keep the newgroups on each server it stores. It's 'good enough' and
> > unencumbered by any licensing (http://en.wikipedia.org/wiki/Sqlite3).
> > There are lots of GUI front-ends for it. Find one you like, free or
> > shareware, to use.
>
> Indeed, searching MacUpdate for "SQLite" produces many tools designed to
> work with in including tools to convert various database file formats to
> something that works with SQLite.
>
> --
> Your time is limited. Don't waste it living someone else's life.
>
> Steve Jobs 1955-2011
" many tools designed to work with in including tools to convert
various database file formats to
something that works with SQLite. ",
Could you be more specific? Thanks.