Re: [sqlite] How to download SQLite for Mac?

2018-06-07 Thread Lutz Horn
The download page (https://sqlite.org/download.html) provides 
precompiled binaries for Mac OS X (x86):


https://sqlite.org/2018/sqlite-tools-osx-x86-324.zip

This zip file contains a single binary you can put onto your path.

Lutz

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] help with EXPLAIN QUERY PLAN

2017-11-23 Thread Lutz Horn
Ho,

Am 23.11.17 um 17:33 schrieb x:
> Can anyone tell me why the detail column sometime states ‘USING INDEX
> ’ and other time ‘USING COVERING INDEX ...’?

See https://sqlite.org/queryplanner.html#_covering_indices

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] open database on Linux. Already db created on Mac.

2012-07-30 Thread Lutz Horn

Am 29.07.2012 14:14, schrieb Durga D:

 What is the procedure to open the sqlite3 database file in Linux
Terminal which is already created on Mac.


Since the database file is portable across operating systems, you can 
just use the sqlite3 tool:


$ sqlite3 your.db

Lutz

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] undefined reference to `readline'

2009-12-29 Thread Lutz Horn
Hi,

Am 29.12.09 19:28, schrieb Angelo:
> sqlite-3.6.16/conftest.c:37: undefined reference to `readline'
> collect2: ld returned 1 exit status.
> 
> So it's clear, the linker does not find the readline function , but I don't 
> understand why.

Do you have the readline library including headers installed?

Lutz

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users