Re: [sqlite] More sqlite header questions

On 16 Feb 2018, at 1:39am, Jens Alfke wrote: > On Feb 15, 2018, at 4:53 PM, Simon Slavin wrote: > >> Given the way the documentation is arranged, and the lack of any mention to >> the contrary, I will assume sqlite3_shutdown() is paired with >>

Re: [sqlite] sqlite3 related crash (SIGSEGV) in GNOME tracker-store

Dan Kennedy wrote: > To: SQLite mailing list , I didn't get your mail because I am not subscribed and was not CCed. > In frame 0 of thread 1, what do the following gdb commands say? > >print *pCache >print *pPage I can't provide that easily

Re: [sqlite] More sqlite header questions

> On Feb 15, 2018, at 4:53 PM, Simon Slavin wrote: > > Given the way the documentation is arranged, and the lack of any mention to > the contrary, I will assume sqlite3_shutdown() is paired with > sqlite_initialize(). There’s a sqlite_initialize function?? O_o —Jens

Re: [sqlite] More sqlite header questions

On 15 Feb 2018, at 11:10pm, Jens Alfke wrote: >> On Feb 15, 2018, at 10:09 AM, Simon Slavin wrote: >> >>> 1) I can't be the only programmer who learned to make paired calls ("If you >>> initialise something, it needs deinitializing, if you allocate

Re: [sqlite] More sqlite header questions

> On Feb 15, 2018, at 10:09 AM, Simon Slavin wrote: > > 1) I can't be the only programmer who learned to make paired calls ("If you > initialise something, it needs deinitializing, if you allocate something, > deallocate it."). When a process exits, its resources are

Re: [sqlite] Advice for a "how-to" situation.

On 2/15/18 2:55 PM, Simon Slavin wrote: By the way, your use of backticks to identify column names That's a quirk of the "schema" command that I used to export the sample that I'm playing with. However, thanks for the reminder. And thanks to everyone for the advice on how to do this. I'm

Re: [sqlite] Advice for a "how-to" situation.

On 15 Feb 2018, at 7:19pm, Michael Tiernan wrote: > This might be a general RDBMS question but since I'm using sqlite > specifically, I hope it passes basic relevancy tests. I don't think we have any problem answering SQL questions here, as long as they're good

Re: [sqlite] Advice for a "how-to" situation.

Seems like you'd want to create a rowid primary key (internal_id integer primary key) that's the foreign key for the other table. On 2/15/18, 1:19 PM, "sqlite-users on behalf of Michael Tiernan" wrote:

[sqlite] Advice for a "how-to" situation.

This might be a general RDBMS question but since I'm using sqlite specifically, I hope it passes basic relevancy tests. I have a table defined as: CREATE TABLE "CPUModelDictionary" ( `vendor_id` TEXT, `cpu_family`INTEGER, `cpu_model` INTEGER,

Re: [sqlite] More sqlite header questions

On 15 Feb 2018, at 5:30pm, Dan Kennedy wrote: > (B) is an understandably common misconception. sqlite3_shutdown() frees > resources that were allocated by sqlite3_initialize() or > sqlite3_auto_extension() and must be called after all SQLite connections have > been

Re: [sqlite] [Legacy Email] Re: Static sqlite3 library for Linux

https://www.sqlite.org/download.html download sqlite-autoconf-322.tar.gz untar cd into source dir ./configure make static lib is made by default along with shared libs $ ls -rlt .libs/ total 9076 -rw-r--r-- 1 rthompso staff 7473704 Feb 15 11:42 sqlite3.o -rwxr-xr-x 1 rthompso staff

Re: [sqlite] More sqlite header questions

On 02/14/2018 04:03 AM, Simon Slavin wrote: On 13 Feb 2018, at 8:22pm, Chris Brody wrote: Thanks Simon for the quick response. You're welcome. Can you clarify the following: - Does this imply that a SQLite database may be left in some kind of unrecoverable,

Re: [sqlite] Static sqlite3 library for Linux

Greetings Peter and thank you for your answer! Ok, I’ll give these switches a go and will get back with my findings. Concerning the side question, of course I can answer, no problem! It is fully developed in-house. Best Regards, Petros On 14 Feb 2018, 20:48 +0200, petern