Re: [sqlite] Was there an announcement of 3.27?

> Am 08.02.2019 um 18:43 schrieb Jens Alfke : > > I see 3.27 was released yesterday (and quickly followed up with 3.27.1.) I The announcement was on the sqlite-annou...@mailinglists.sqlite.org list. 3.27 was ready to go, a bug was found, so 3.27.1 was announced today, so everyone could skip

Re: [sqlite] Suitability for Macintosh OS 9.2?

> > The problem you are likely to run into though, with the modern SQLite > source code, is that there's probably no VFS [1] for Mac OS. If you use some old compiler like Metroworks C compiler, you would get the C runtime coming with it. And I would expect that unix-dotfile should work for

Re: [sqlite] Size of the SQLite library

> > See https://sqlite.org/tmp/size-20180531.jpg for the library size > trend over 5 years. Maybe your graph should have three lines. 1. Minimum SQLite with all off 2. Default SQLite 3. Maximum SQLite with all on Sincerely Christian -- Read our blog about news on our plugins:

[sqlite] Congratulations on 18 years

Hello, Congratulations to the SQLite team. As far as I see, the first checkin was 2000-05-29, which was over 18 years ago. Sincerely Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/ ___ sqlite-users mailing list

Re: [sqlite] Emulate right-join

>> >>> Actually, the left outer join is sufficient to execute all the outer >> join operators: >>> >>> - right outer join: just swap the "from" arguments >>> >>> - full outer joins: union of left and right outer joins >> Couldn’t SQLite implement that and do the swap for us? As well as the

Re: [sqlite] Minor issue: compile error with 3.19 and MSVC 2005

> Am 22.05.2017 um 23:52 schrieb Wolfgang Enzinger : > > Hallo, > > I don't think this is a big deal, but probably helpful for one or another: > > I tried to compile SQLite 3.19 with MSVC 2005 and got a compile error C2143 > at line 143542 of sqlite3.c. I run into the

Re: [sqlite] SQLite does not support ARM platform?

> Am 20.03.2017 um 22:24 schrieb Jaime Stuardo : > > Hello, > > I have finally given up. After almost all day trying to compile SQLite > amalgamated source code files for ARM platform I got the conclusion that > SQLite is not for ARM platform,… Really? I do that now for

[sqlite] gethostuuid warning on iOS?

Hi, there is warning coming on iOS due to gethostuuid: #if defined(__APPLE__) && ((__MAC_OS_X_VERSION_MIN_REQUIRED > 1050) || \ (__IPHONE_OS_VERSION_MIN_REQUIRED > 2000)) # if (!defined(TARGET_OS_EMBEDDED) || (TARGET_OS_EMBEDDED==0)) \ &&

Re: [sqlite] 64-bit SQLite3.exe

> I agree, but now you're talking getting the amalgamation/repo and stuff (also > not exceedingly difficult, but granted will take a lot longer), he was > however not claiming having difficulty with that, the difficulty was only the > "learning how to make a build script" and that (in SQLite's

[sqlite] Precompiled Libraries?

. So I can tell people to just swap out the DLL if needed and not statically link it. Sincerely Christian Schmitz ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite custom function for regular expression using c/c++

> Am 04.05.2016 um 14:25 schrieb Bhagwat Balshetwar gmail.com>: > > I want to write the custom function for regular expression using C/C++. > How to write it. Is there the document/sample code available on this. > Of course. Google is your friend. Maybe start reading here:

[sqlite] Wish list: better ALTER TABLE for setting default

>> ALTER TABLE testTable SET DEFAULT FOR testField TO 0 > > Not all values in this column might actually be stored on disk. > Changing the default value could change those rows. it would be perfectly okay if you document this to either * apply the new default to all NULL values * not change

[sqlite] whish list for 2016

> > DROP COLUMN and RENAME COLUMN are relatively easy for tables that lack > indexes, triggers, views, foreign key references, CHECK constraints, > and other constructs that might reference the dropped or renamed > column. Reliably finding every use of a column name and changing it > can be

[sqlite] Wish list: better ALTER TABLE for setting default

Hi, Sometimes I add columns to tables. But when I forget an option, I can't do much, but going back to backup copy or creating a copy of whole database with little change. e.g. a column misses default value. So I would like to see more alter table things. Maybe like this: ALTER TABLE

[sqlite] Retrieved Blob Data has 16 Byte Header or ?

> NSData doesn't involve encryption, but it does involve tagging the data with > metadata, e.g. the fact that it's a string, and how long the string is. > There is an NSData accessor function which returns the length of the > /content/ of the object. Or, of course, you can obtain the length of

[sqlite] Retrieved Blob Data has 16 Byte Header or ?

> * Retrieve Blob to NSData object - 3245 bytes > > * The retrieved data will not display. Do you pass it though encryption? 16 bytes sounds like an IV for AES stored before the data. Sincerely Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/

[sqlite] whish list for 2016

> Am 20.12.2015 um 19:12 schrieb Big Stone : > > Hi All, > > To prepare for 2016 greetings moment, here is my personnal whish list Unless I missed something, I may suggest * moveprev * movefirst * movelast * move to record in cursor with given index Looping over a recordset twice is often

[sqlite] whish list for 2016

Hi, better ALTER command would be very welcome. e.g. RENAME/DELETE column or field. Instead of us writing code to do it, it could be a command where SQLite does things right. Sincerely Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/

[sqlite] Compilation fails under Linux (Ubuntu) when FTS5 is enabled

> Am 17.10.2015 um 13:47 schrieb tonyp at acm.org: > > What the subject says and I get this error: > > /tmp/cco8QBGJ.o: In function `fts5Bm25GetData': > sqlite3.c:(.text+0xb521b): undefined reference to `log' > > (using the latest 3.9.1 release) > > Any ideas? For me it worked on a 32bit and