Re: [sqlite] Article: UUID or GUID as Primary Keys? Be Careful!

I drink to that! 2017-06-10 14:26 GMT-04:00 Jens Alfke <j...@mooseyard.com>: > > > On Jun 10, 2017, at 6:58 AM, Daniel Anderson <woni...@gmail.com> wrote: > > > > the article was integers (4 bytes) vs guid as a primary key, which as > > string ta

Re: [sqlite] Article: UUID or GUID as Primary Keys? Be Careful!

the article was integers (4 bytes) vs guid as a primary key, which as string takes 36 bytes. so he was right in saying that string guid/uuid take 9 time the space of simple integers. in general the article was quite good and allowed people to ponder about their choices/beliefs. he said be:

Re: [sqlite] Create database

m: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > > On Behalf Of Daniel Anderson > > Sent: Friday, 14 April, 2017 21:11 > > To: SQLite mailing list > > Subject: Re: [sqlite] Create database > > > > you would probably be better off using C++

Re: [sqlite] Create database

you would probably be better off using C++ to handle everything, less chances of forgetting to close something. do not build your own classes, use existing one! 2017-04-14 10:44 GMT-04:00 Igor Korot : > Keith, > > On Fri, Apr 14, 2017 at 10:37 AM, Keith Medcalf

Re: [sqlite] "struct Mem" conflicts with namespaces/classes having the same name

namespace 2017-04-10 10:43 GMT-04:00 Olivier Mascia <o...@integral.be>: > > Le 10 avr. 2017 à 16:21, Daniel Anderson <woni...@gmail.com> a écrit : > > > > as Sqlite is already within extern "C" > > > > I'm wondering how your namespace tri

Re: [sqlite] "struct Mem" conflicts with namespaces/classes having the same name

as Sqlite is already within extern "C" I'm wondering how your namespace trick can work ? 2017-04-10 9:41 GMT-04:00 Bob Friesenhahn : > On Mon, 10 Apr 2017, Olivier Mascia wrote: > >> >> This is where I do: >> >> #include "memory.h" >> namespace sqlite >> { >>

Re: [sqlite] "struct Mem" conflicts with namespaces/classes having the same name

Ah, understood. I thought you had a struct or a class named Mem. then short term solution is to rename Mem in sqlite.h using the #define directive + include file should do the trick. as they say solve it by using a level of indirection! It will be a bit ugly, but until a) sqlite change the

Re: [sqlite] "struct Mem" conflicts with namespaces/classes having the same name

I see no problems with C++. Mem is only foward declared, you can redefined it to whatever you want. as long as you do not redefined it for sqlite.c you should be good. in sqlite.h it's declared: struct Mem; so in your code if you do: struct Mem { int a;int b;} then your definition will be

Re: [sqlite] Drop view “automatically” when its associated table is dropped?

Yep Sybase preparse it. When you create a view/sproc/triggers/function the objects referenced must exist or your DDL will fail. this create some complexity when we want to recreate all the objects, order of creation is very important. 2017-03-23 21:15 GMT-04:00 Simon Slavin

Re: [sqlite] Drop view “automatically” when its associated table is dropped?

Sybase has one. there is even a way to get objects dependencies, I have been working on a project for the last 5 years using sybase (ASE). very huge project and whenever we must alter the schema we have tools to tell us which store proc, triggers, views will be impacted. it allow us to reach the

Re: [sqlite] Application is crashing while performing sqlite3_prepare_v2 with sqlite version 3.15.2 (intermittently)

Hi Roshak, Looks like your top function in that thread is sqlite3_prepare_v2 So I can assume 2 things: 1 - you started a thread directly on sqlite3_prepare_v2 2- you erase part of the stack trace. if you did 1, I can only say this is not good! if you did 2, then you are keeping information,

Re: [sqlite] Crash on Android

looks like a race condition! but it could also be uninitialized variable, but this is rarer these day as most compiler flag uninitialized var. unless your uninitialized var happen to be in a struct, this is why constructor are so important for struct/class 2017-02-27 11:28 GMT-05:00 Jeff

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

There is no \ at the end of the code which was pasted. did you removed them from the source ? the error look related to that problem. my .02 $ 2017-02-14 17:20 GMT-05:00 Simon Slavin : > > On 14 Feb 2017, at 10:15pm, Bart Smissaert > wrote: > >