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

[Christian Schmitz]

> 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 3.27.

Sincerely
Christian

-- 
Read our blog about news on our plugins:

http://www.mbsplugins.de/


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

Re: [sqlite] Suitability for Macintosh OS 9.2?

[Christian Schmitz]

> 
> 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 most stuff.
File path text encoding may be tricky, but for just English letters, it may be 
fine.

Sincerely
Christian

-- 
Read our blog about news on our plugins:

http://www.mbsplugins.de/


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

Re: [sqlite] Size of the SQLite library

[Christian Schmitz]

> 
> 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:

http://www.mbsplugins.de/


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

[sqlite] Congratulations on 18 years

[Christian Schmitz]

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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Emulate right-join

[Christian Schmitz]

>> 
>>> 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 union thing?

Sincerely
Christian

-- 
Read our blog about news on our plugins:

http://www.mbsplugins.de/


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

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

[Christian Schmitz]

> 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 same issue with VS 2008.
Not a big problem and easy to fix.

I still wonder why it reports an error about an extra semicolon.

Sincerely
Christian

-- 
Read our blog about news on our plugins:

http://www.mbsplugins.de/


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

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

[Christian Schmitz]

> 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 over 1.5 years.
With GCC on Linux for Raspberry Pi.

> In both cases, I got this error:
> 
> "crtdefs.h(338) : fatal error C1189: #error :  Compiling Desktop applications 
> for the ARM platform is not supported."
> 

Is that a Visual Studio thing?

Maybe you check those .h files for what they are about.
Is that maybe a Visual Studio header and you do something Microsoft doesn’t 
support?

Sincerely
Christian

-- 
Read our blog about news on our plugins:

http://www.mbsplugins.de/


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

[sqlite] gethostuuid warning on iOS?

[Christian Schmitz]

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)) \
   && (!defined(TARGET_IPHONE_SIMULATOR) || (TARGET_IPHONE_SIMULATOR==0))
#define HAVE_GETHOSTUUID 1
#  else
#warning "gethostuuid() is disabled."
#  endif
#endif




I don't think the warning is useful and should maybe go?
Or add some kind of replacement for iOS?

Sincerely
Christian

-- 
Read our blog about news on our plugins:

http://www.mbsplugins.de/

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

Re: [sqlite] 64-bit SQLite3.exe

[Christian Schmitz]

> 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 case) is well 
> documented and can be done in minutes.


I'd also like to have prebuild console app and dlls for various platforms, so 
you don't need to build yourself just to try something.
Or when using official binaries, we could link to them and tell clients to 
update them independent of our software later.

Sincerely
Christian

-- 
Read our blog about news on our plugins:

http://www.mbsplugins.de/

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

[sqlite] Precompiled Libraries?

[Christian Schmitz]

Hi,

could I make the feature request to have a prebuilt libraries on the website 
for Mac, Windows and Linux in 32/64bit with most extensions?
including ICU and FTS5 and a few other useful extensions.

Would be convenient if you could auto built them and provide them on the 
website for us to use.
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++

[Christian Schmitz]

> 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:
https://www.sqlite.org/c3ref/create_function.html


A few open source extensions can also help as example.

Sincerely
Christian

-- 
Read our blog about news on our plugins:

http://www.mbsplugins.de/

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

[Christian Schmitz]

>> 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 existing rows. Than I do the UPDATE Statement myself.

> It is actually possible to do this, if you force all rows to be
> rewritten first, and then change the table definition:
> http://stackoverflow.com/questions/25911191/altering-a-sqlite-table-to-add-a-timestamp-column-with-default-value

You really want us to modify the Table Definitions?


Sincerely
Christian

-- 
Read our blog about news on our plugins:

http://www.mbsplugins.de/

[sqlite] whish list for 2016

[Christian Schmitz]

> 
> 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 tricky.  The problem is more acute for dropping a column - what
> do you do then, change each reference to NULL?

it may be okay to say:

If it is referenced, we may live with an error.

"Can't drop column xxx as it is used in trigger yyy."


Most columns for us are not referenced in any way. Just data columns.

Sincerely
Christian

-- 
Read our blog about news on our plugins:

http://www.mbsplugins.de/

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

[Christian Schmitz]

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 testTable SET DEFAULT FOR testField TO 0

or

ALTER TABLE testTable SET UNIQUE FOR testField TO 1


Sincerely
Christian

-- 
Read our blog about news on our plugins:

http://www.mbsplugins.de/

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

[Christian Schmitz]

> 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 the 
> object itself.  My guess is that somewhere in the code these one of these is 
> being used where it should be the other.

Without seeing his code, it doesn't make sense guess what might be wrong.

Sincerely
Christian

-- 
Read our blog about news on our plugins:

http://www.mbsplugins.de/

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

[Christian Schmitz]

> * 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

[Christian Schmitz]

> 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 useful.

Sincerely
Christian

-- 
Read our blog about news on our plugins:

http://www.mbsplugins.de/

[sqlite] whish list for 2016

[Christian Schmitz]

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

[Christian Schmitz]

> 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 64bit Ubuntu here.

How did you get a libc without math functions?

Sincerely
Christian

-- 
Read our blog about news on our plugins:

http://www.mbsplugins.de/