Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.sys.mac.system > #117799

Re: SQLite tools on OS-X

Show all headers | View raw

In message <HlofD.7802$Ac3.5580@fx45.iad> JF Mezei <jfmezei.spamnot@vaxination.ca> wrote:
> On 2018-08-22 19:54, Lewis wrote:

>>> The field was created as :
>> 
>> You should not be creating a table in an existing database.
>> 
>>> ZDATE TIMESTAMP,

> .schema lists how a table was created. I didn't create the database or
> try to modify it. Apple created it for the iPhone defining a field as
> "TIMESTAMP" which the SQLITE3 utility didn't process correctly. (and
> which the sqlite documentation doesn't know about).

Your knowledge of SQL, and SQLite in specific, is very shallow. You can
set pretty much anything you want as the "Type" of a table.

> At the time I asked the question, i was unaware that Apple provided the
> sqlite3 utility on OS-X, thought it used sqlite on OS-X and IOS as
> run-time only libraries.

It's been in macOS (nee OS X) for a long time. Possible since the Public
Beta. Most of the databases Apple uses are SQLite. A mere instant of
research (like, for example, 

which sqlite3

would have revealed this.

And in fact, since you have posted in the past about vacuuming the mail
database, you DID know about SQLite being in macOS. I couldn't swear to
it in court, but I am at least 95% sure.


-- 
'I don't like to ask them questions.' 'Why not?' 'They might give me
answers. And then what would I do?'

Back to comp.sys.mac.system | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

SQLite tools on OS-X JF Mezei <jfmezei.spamnot@vaxination.ca> - 2018-08-20 13:15 -0400
  Re: SQLite tools on OS-X nospam <nospam@nospam.invalid> - 2018-08-20 13:33 -0400
    Re: SQLite tools on OS-X Tim Streater <timstreater@greenbee.net> - 2018-08-20 18:42 +0100
      Re: SQLite tools on OS-X nospam <nospam@nospam.invalid> - 2018-08-20 13:46 -0400
        Re: SQLite tools on OS-X Tim Streater <timstreater@greenbee.net> - 2018-08-20 22:15 +0100
      Re: SQLite tools on OS-X Jolly Roger <jollyroger@pobox.com> - 2018-08-20 22:44 +0000
      Re: SQLite tools on OS-X Lewis <g.kreme@gmail.com.dontsendmecopies> - 2018-08-22 23:56 +0000
  Re: SQLite tools on OS-X Jolly Roger <jollyroger@pobox.com> - 2018-08-20 19:12 +0000
  Re: SQLite tools on OS-X dempson@actrix.gen.nz (David Empson) - 2018-08-21 13:57 +1200
    Re: SQLite tools on OS-X JF Mezei <jfmezei.spamnot@vaxination.ca> - 2018-08-20 23:26 -0400
      Re: SQLite tools on OS-X Tim Streater <timstreater@greenbee.net> - 2018-08-21 09:02 +0100
      Re: SQLite tools on OS-X dempson@actrix.gen.nz (David Empson) - 2018-08-21 22:10 +1200
  Re: SQLite tools on OS-X Lewis <g.kreme@gmail.com.dontsendmecopies> - 2018-08-22 23:54 +0000
    Re: SQLite tools on OS-X JF Mezei <jfmezei.spamnot@vaxination.ca> - 2018-08-22 21:46 -0400
      Re: SQLite tools on OS-X Lewis <g.kreme@gmail.com.dontsendmecopies> - 2018-08-24 05:15 +0000

csiph-web