Igor,
Two comments:
- Why Homebrew? Because it's an invaluable tool for keeping up with the latest
release of not just SQLite but every installed package of interest.
- I think you missed the point. Niall is referring to the SQLite3 executable,
not just the C source file. The excutable is need
Hi,
On Sat, Jan 13, 2018 at 6:32 AM, Niall O'Reilly wrote:
>
>
> On 11 Jan 2018, at 13:23, Richard Hipp wrote, in reply to John G
> :
>
>> You can
>> download and/or compile your own up-to-date SQLite that is twice as
>> fast and has all the latest features.
>
> It may be more convenient to use
On 11 Jan 2018, at 13:23, Richard Hipp wrote, in reply to John G
:
> You can
> download and/or compile your own up-to-date SQLite that is twice as
> fast and has all the latest features.
It may be more convenient to use the [Homebrew package
manager](https://brew.sh/), which tracks SQLite pre
Thanks Warren. Sorry about that, I had an old version in /opt/local/bin.
John Gillespie
On 11 January 2018 at 15:24, Warren Young wrote:
> On Jan 11, 2018, at 5:47 AM, John G wrote:
> >
> > Is this because I am stuck with version 3.8.8.3 which is what MacOS
> Sierra
> > provides?
>
> I have sq
On Jan 11, 2018, at 5:47 AM, John G wrote:
>
> Is this because I am stuck with version 3.8.8.3 which is what MacOS Sierra
> provides?
I have sqlite3 version 3.16.0 in /usr/bin on this 10.12.6 (Sierra) system.
___
sqlite-users mailing list
sqlite-users@
On 1/11/18, John G wrote:
>
> Is this because I am stuck with version 3.8.8.3 which is what MacOS Sierra
> provides?
>
You are not stuck with the software provided by Sierra. You can
download and/or compile your own up-to-date SQLite that is twice as
fast and has all the latest features.
--
D.
ence,
>cidas ColumnID,
>name as ColumnName,
>"desc" as IsDescendingOrder,
>coll as Collation,
>key as IsPartOfKey
> from SysIndexes
> join pragma_index_xinfo(Ind
Keith Medcalf wrote
> Full Schema Tables:
Thanks for this, I will have grat use for it too, soon! Actually it's so
nice I think it could go into the documentation.
--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite-users mailing list
sqlite
t anticipated traffic volume.
>
>
> >-Original Message-
> >From: sqlite-users [mailto:sqlite-users-
> >boun...@mailinglists.sqlite.org] On Behalf Of Bart Smissaert
> >Sent: Saturday, 6 January, 2018 15:54
> >To: SQLite mailing list
> >Subject: Re: [sql
te.org] On Behalf Of Bart Smissaert
>Sent: Saturday, 6 January, 2018 15:54
>To: SQLite mailing list
>Subject: Re: [sqlite] sqlite3_column_decltype and max and min
>
>OK, thanks will have a look at that.
>So, how about this one then:
>
>select max(integer_date) as [max_integer_
nticipated traffic volume.
>
>
> >-Original Message-
> >From: sqlite-users [mailto:sqlite-users-
> >boun...@mailinglists.sqlite.org] On Behalf Of Bart Smissaert
> >Sent: Saturday, 6 January, 2018 15:00
> >To: SQLite mailing list
> >Subject: Re: [s
ic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Bart Smissaert
>Sent: Saturday, 6 January, 2018 15:00
>To: SQLite mailing list
>Subject: Re: [sqlite] sqlite3_column_decltype and max and min
>
&
t about anticipated traffic volume.
>
>
> >-Original Message-
> >From: sqlite-users [mailto:sqlite-users-
> >boun...@mailinglists.sqlite.org] On Behalf Of Bart Smissaert
> >Sent: Saturday, 6 January, 2018 10:45
> >To: General Discussion of SQLite Databa
ic volume.
>-Original Message-
>From: Keith Medcalf [mailto:kmedc...@dessus.com]
>Sent: Saturday, 6 January, 2018 12:40
>To: 'SQLite mailing list'
>Subject: RE: [sqlite] sqlite3_column_decltype and max and min
>
>
>SQLite version 3.22.0 2018-01-02 18:11:11
>E
ite.org] On Behalf Of Bart Smissaert
>Sent: Saturday, 6 January, 2018 10:45
>To: General Discussion of SQLite Database
>Subject: [sqlite] sqlite3_column_decltype and max and min
>
>Is there any way with sqlite3_column_decltype (or otherwise) to get
>the
>declared data type (as in
olume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Bart Smissaert
>Sent: Saturday, 6 January, 2018 10:45
>To: General Discussion of SQLite Database
>Subject: [sqlite] sqlite3_column_decltype and max and min
&
> Which is bound to lead to problems at some point.
Not sure it is a problem if SQLite still recognizes the custom data types
as it's own data types.
Eg, int_date will be considered integer.
RBS
On Sat, Jan 6, 2018 at 5:59 PM, Simon Slavin wrote:
> On 6 Jan 2018, at 5:45pm, Bart Smissaert wro
On 6 Jan 2018, at 5:45pm, Bart Smissaert wrote:
> The custom datatype int_date is needed for formatting purpose to tell the
> app that receives
> the data that the column holds dates as integers.
You can only get that in a documented way by parsing the CREATE TABLE command
from sqlite_master.
Is there any way with sqlite3_column_decltype (or otherwise) to get the
declared data type (as in the table create sql in SQLite_master) when it is
a simple expression such as max and min?
for example we have a table created like this:
create table1([integer_date] int_date)
and we do:
select ma
19 matches
Mail list logo
