Re: [sqlite] Poll: Include the recent sqlite3_column_name() fix in the upcoming 3.20.0 release?

IMHO the inconsistency is a bug of sorts and so would “vote” for a merge now. In a sense applications that risk breaking are due to hacking around what is documented. And if the change is going to happen it might as well be now along with the major versions change. -- L:

Re: [sqlite] "Responsive" website revamp at www.sqlite.org

That seems to be the way to do it these days. I think generally accepted trying to detect browsers doesn’t work. BTW have you looked at http://www.cascade-framework.com/ No affiliation and I thought it might tickle people as the strapline is “putting the c

[sqlite] Podcast with Dr Hipp: SQLite history, success and funding

Please take this to another thread! > On 16 May 2016, at 23:16, Objective C wrote: > > Thank you for your answer, > here is the code i used to backup my SQLite database : > > var source = new SQLiteConnection("Data Source = MyDB.db ; Version = 3;"); > var destination = new

[sqlite] Lawyers, encryption, and RC4

I think answer 27 of the FAQ https://www.sqlite.org/faq.html#q27 might help you. > On 11 Aug 2015, at 13:30, Eric Hill wrote: > > Sorry to bother folks with this. > > We're getting some pushback from our lawyers suggesting that SQLite's use of > RC4

[sqlite] How initialize a database file from unix shell without landing in SQLite command prompt?

Just pipe the text file to sqlite3 # sqlite3 DB.SQLITE : >I have a file DBDEFINITION.TXT that I want to use to initialize [execute >on] the database DB.SQLITE. >How do I do something like >$ sqlite3 -exec DBDEFINITION.TXT DB.SQLITE >$ >? >All methods I tried end me up in the SQLite prompt, and

Re: [sqlite] JSON indexing

Originally built for Appcelerator but now covers more than that https://github.com/dan-eyles/sculejs this library might be what you are looking for. Neville — Surgeons Net Education: http://www.surgeons.org.uk Clinical Software Solutions: http://www.clinsoftsolutions.com Find our free and paid

Re: [sqlite] Most efficient storage for arrays

On 22 Apr 2014, at 21:58, Roger Binns <rog...@rogerbinns.com> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 22/04/14 05:24, Neville Dastur wrote: >> I am looking for some advice on storing and searching data that comes >> from an external JSON

Re: [sqlite] BLOBs and NULLs

On 22 Apr 2014, at 17:33, Richard Hipp wrote: > The usual solution here is to have a table that maps GUIDs into small > locally-unique integers: > >CREATE TABLE guid_id(id INTEGER PRIMARY KEY, guid TEXT UNIQUE); > > Use the small integer "id" value for internal foreign

[sqlite] Most efficient storage for arrays

Hi all I am looking for some advice on storing and searching data that comes from an external JSON source and needs to be stored on device in a Sqlite3 database. The JSON records are formatted as (simplified): { "_id" : ObjectId(“xx"), "name" : “Description”, “array1" :

Re: [sqlite] INSERT OR REPLACE

On 21 Apr 2014, at 18:13, Andy Goth <andrew.m.g...@gmail.com> wrote: > On 4/21/2014 6:04 AM, Richard Hipp wrote: >> On Mon, Apr 21, 2014 at 6:18 AM, Neville Dastur wrote: >>> Google only showed up that UNIQUE needs to be added regardless of the >>> column b

Re: [sqlite] INSERT OR REPLACE

Neville On 21 Apr 2014, at 12:04, Richard Hipp <d...@sqlite.org> wrote: > On Mon, Apr 21, 2014 at 6:18 AM, Neville Dastur > <nevillebdas...@gmail.com>wrote: > >> I seem to have a strange problem. >> >> I am using the INSERT OR REPLACE INTO syntax on a Sq

[sqlite] INSERT OR REPLACE

I seem to have a strange problem. I am using the INSERT OR REPLACE INTO syntax on a Sqlite DB running in iOS simulator 7.1 (not exactly sure which sqlite version that is) I have a column defined as hospitals_id TEXT PRIMARY KEY UNIQUE which stores a GUID. Hence the text primary key. When I do

Re: [sqlite] Namespacing sqlite3

That's a very interesting concept. Are you using http://www.cython.org/ or something else to "create" the library wrapper Neville On 24 Sep 2013, at 22:39, Roger Binns <rog...@rogerbinns.com> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 24/09/13

Re: [sqlite] Namespacing sqlite3

Okay, so it's already namespaced with a prefix which I can replace. Thank you On 24 Sep 2013, at 21:27, Richard Hipp <d...@sqlite.org> wrote: > On Tue, Sep 24, 2013 at 3:56 PM, Neville Dastur > <nevillebdas...@gmail.com>wrote: > >> Hi >> >> I am hopi

[sqlite] Namespacing sqlite3

Hi I am hoping someone can help with this one. I am aware that some might consider it a C issue more than sqlite3, but C doesn't handle this well and so I am looking for specific sqlite3 info. I am looking to create my own sqlite3 Appcelerator module. Appcelerator at present already uses

Re: [sqlite] ?bug causing sigsegv

bt the code where Qt API > and SQLite API are used interchangeably will work properly. I guess > you can fix your SIGSEGV by calling sqlite3_initialize() somewhere at > the beginning of your application but I think inconsistency in static > variables of SQLite can surface in

[sqlite] ?bug causing sigsegv

|Hi I am using Qt to connect to a Sqlite3 database (3.6.23-1). Source is just included with my app, not a dll / lib. System: Mac OSX 10.6 and Ubuntu 9.10 (GCC 4.4) The method of getting a sqlite* is described in the Qt docs and I have checked the memory addresses in gdb and the returned sqlite3*