Re: [sqlite] UPPER function depends on Locale?

09.04.2018 23:18 tarihinde sandu yazdı: The example you found is not applicable in your case, because it is describing an way to develop your own functions in PHP, which is not the case for you. Dear Buraga SANDU, Thanks alot for your kind interest. I my opinion, there should be well document

[sqlite] SQLite performance graph not updated + 3 typos

Hi The SQLite performance graph at https://www.sqlite.org/cpu.html has not been updated since SQLite-3.21 (currently release being SQLite-3.23). Was it forgotten, or is the graph updated only once in a while? Also here are 3 typos found at https://www.sqlite.org/cpu.html in the same sentence: R

Re: [sqlite] UPPER function depends on Locale?

The example you found is not applicable in your case, because it is describing an way to develop your own functions in PHP, which is not the case for you. -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users mailing list sqlite-users@ma

Re: [sqlite] UPPER function depends on Locale?

Simon Slavin-3 wrote > See section 1.1 of > > ; > > Simon. It looks good, basically 2 letter ISO 639 language code and ISO 3166 country code. -- Sent from: http://sqlite.1065341.n5.nabble.com/ _

Re: [sqlite] UPPER function depends on Locale?

On 9 Apr 2018, at 8:49pm, sandu wrote: > I am also curious about how can someone define the locale parameter for the > LOWER/UPPER functions? See section 1.1 of Simon. ___ s

Re: [sqlite] UPPER function depends on Locale?

Simon Slavin-3 wrote > Unfortunately, bare SQLite understands only ASCII characters. It does not > understand Unicode. To build in full understanding of Unicode would make > SQLite almost twice as long. > > However, you can add Unicode support to SQLite using ICU: > >

Re: [sqlite] UPPER function depends on Locale?

According to SQLite documentation, it does not depend on locale, because it is a pure ASCII implementation: "The upper(X) function returns a copy of input string X in which all lower-case ASCII characters are converted to their upper-case equivalent." ASCII character was designed for English US, s

Re: [sqlite] To use or not to use single quotes with integers

Insert the usual "Bobby Tables" reply here https://xkcd.com/327/ You really want to just bind the values to the insert statement, both to prevent issues and make things simpler. It'll look slightly different in each language, but it's basically 1 SQL statement text which contains placeholders.

Re: [sqlite] Creating UDF?

Dr. Mucibirahman İLBUĞA wrote: > Is there a very simple example how to create UDF in SQLite?! From the Python documentation: import sqlite3 import md5 def md5sum(t): return md5.md5(t).hexdigest() con = sqlite3.connect(":memory:") con.create_function("md5", 1, md5sum) cur = con

Re: [sqlite] In memory only WAL file

On 9 Apr 2018, at 8:41am, Pavel Cernohorsky wrote: > if you use bigger pro-level SSD, you get on a bit less that 1 year.. still > not good enough. Of course, big unknown in this is the constant representing > the ability of the SSD controller to merge requests and minimize block > re-writes.

Re: [sqlite] Documentation update

On 9 Apr 2018, at 11:02am, R Smith wrote: > If you prefer "different from" to "different to", it is simply likely that > you are American rather than English, in which language the preference (I > should say "habit" really) is "different to" rather than "different from", > but I gather from

Re: [sqlite] UPPER function depends on Locale?

> Le 9 avr. 2018 à 11:39, Dr. Mucibirahman İLBUĞA a > écrit : > > 09.04.2018 11:08 tarihinde Olivier Mascia yazdı: >> Is it better / simpler to write your own UPPER/LOWER specialised or to >> simply rebuild SQLite with ICU, I have too few details on your needs / goals >> to tell. > > Hi, > >

Re: [sqlite] Documentation update

I'm adding to my bucket list meeting some of you in person. On Mon, Apr 9, 2018 at 5:58 AM, Niall O'Reilly wrote: > On 9 Apr 2018, at 11:02, R Smith wrote: > > > Gentlemen - shall we call pistols at dawn to settle this? > > Or my favourite duel: Face-pulling at midnight. :) > > 8-) > > /Niall

Re: [sqlite] Documentation update

On 9 Apr 2018, at 11:02, R Smith wrote: > Gentlemen - shall we call pistols at dawn to settle this? > Or my favourite duel:  Face-pulling at midnight.  :) 8-) /Niall signature.asc Description: OpenPGP digital signature ___ sqlite-users mailing list s

Re: [sqlite] Documentation update

On 2018/04/09 10:51 AM, Niall O'Reilly wrote: On 9 Apr 2018, at 2:08, Simon Slavin wrote: "In unique indices, each NULL value is considered different to every other NULL value. Thus each NULL value is unique." For the sake of my late English teacher, I hope the revised document will read ".

[sqlite] Critical error in version 3.23.0

Fatal termination of the program after the sql-script: CREATE VIRTUAL TABLE ind_test USING fts5(message); create table test_table(message text); insert into ind_test(message) values ('not_bla_bla'); insert into test_table values ('bla_bla'); select * from test_table as t1 left outer join ind_test

Re: [sqlite] UPPER function depends on Locale?

09.04.2018 11:08 tarihinde Olivier Mascia yazdı: Is it better / simpler to write your own UPPER/LOWER specialised or to simply rebuild SQLite with ICU, I have too few details on your needs / goals to tell. Hi, Is there any document explains step by step recompiling SQLite with ICU support bo

Re: [sqlite] UPPER function depends on Locale?

09.04.2018 11:08 tarihinde Olivier Mascia yazdı: Is it better / simpler to write your own UPPER/LOWER specialised or to simply rebuild SQLite with ICU, I have too few details on your needs / goals to tell. Dear Olivier, Thanks a lot for your valuable informations. You may be right about reco

Re: [sqlite] Documentation update

On 9 Apr 2018, at 2:08, Simon Slavin wrote: > "In unique indices, each NULL value is considered different to every other > NULL value. Thus each NULL value is unique." For the sake of my late English teacher, I hope the revised document will read "... different __from__ ...". Best regards, Ni

Re: [sqlite] UPPER function depends on Locale?

> Le 9 avr. 2018 à 08:42, Dr. Mucibirahman İLBUĞA a > écrit : > > 09.04.2018 00:56 tarihinde Simon Slavin yazdı: >> There is another solution which does not involve full ICU support. You >> could instead make your own external functions for UPPER_TR() and LOWER_TR() >> which do just the conve

[sqlite] Creating UDF?

Hi, Is there a very simple example how to create UDF in SQLite?! I found some example with C and PHP but not enaugh to understand and apply for me unfortunatelly... :( -- Regards, Mucip:) ___ sqlite-users mailing list sqlite-users@mailinglists.sqli

Re: [sqlite] In memory only WAL file

Hi, what prompts me? Well, I mentioned that in the original post - it is the number of IOPS going to the disk (write IOPS I am concerned about). Not that SQLite would be slow, the performance is OK (for now), but having IO in the range of thousands per second constant load just doesn't feel ri