Re: [sqlite] ":memory:" path does not seem to work on Windows anymore

2016-05-29 Thread Kirill Müller
I can't reproduce the issue on Windows with the current command-line client, but it is real in our environment. How can I help you replicate it? Thanks. -Kirill On 26.05.2016 14:57, Kirill Müller wrote: Hi In the R interface to SQLite [1], we observe that opening a database with ":memory:

Re: [sqlite] Write-Ahead Logging -- documentation error

2016-05-29 Thread David Empson
After some head scratching, I’ll retract my previous message. The documentation (as revised last week) is correct. The previous version of wal.html mentioning “read mark” had led me down the wrong path in understanding which bit of the WAL was protected while a read lock was active. There is o

Re: [sqlite] Postgres vs MySQL (was Re: Messages posted on Nabble not getting to list)

2016-05-29 Thread dandl
Good summary, agree 100%. >From experience, Postgres is amazingly configurable, if you ever want to do something weird. Sqlite is too, but only if you access it directly in C and don't really need a server. And the guys working on the internals (both) are the smartest bunch you're likely to run a

Re: [sqlite] Sweet 16

2016-05-29 Thread Darren Duncan
On 2016-05-29 10:28 AM, Richard Hipp wrote: The first check-in of SQLite code occurred 16 years ago today. https://www.sqlite.org/src/timeline?c=2000-05-29 Congratulations on that! Thank you for all of that work. Stay strong and keep moving on. Coincidentally, that first commit date is wit

[sqlite] Postgres vs MySQL (was Re: Messages posted on Nabble not getting to list)

2016-05-29 Thread Darren Duncan
On 2016-05-28 12:49 PM, r.a.n...@gmail.com wrote: @Daren Any reasons for the thumbs down on MySQL? Their workbench is better that Toad ... On May 27, 2016, at 10:00 PM, Darren Duncan wrote: On 2016-05-27 2:28 PM, Balaji Ramanathan wrote: But when I was debating between MySQL and SQLite for

Re: [sqlite] Messages posted on Nabble not getting to list

2016-05-29 Thread Balaji Ramanathan
It was too much database for my purposes as far as this project was concerned. Same with PostgreSQL. Also, I wanted something that would be easily accessible from my android phone/tablet as well as my PC. I have been using MS Access all along, and I really like the nice front end and reporting c

Re: [sqlite] constraint failed message and no clue what went wrong

2016-05-29 Thread Dominique Devienne
On Monday, May 23, 2016, Bernd Lehmkuhl wrote: > > > Dominique Devienne > hat am 23. Mai > 2016 um 13:42 > Could it be your you "knoten" and "punkte" tables have values with the > same IDs? > > Gotcha! Thanks. Even though I claimed having checked that auto_id is > unique in that query, you just

Re: [sqlite] Sweet 16

2016-05-29 Thread Niall O'Reilly
On 29 May 2016, at 18:28, Richard Hipp wrote: > The first check-in of SQLite code occurred 16 years ago today. > https://www.sqlite.org/src/timeline?c=2000-05-29 Congratulations! Keep up the great work. Niall O'Reilly ___ sqlite-users mailing li

Re: [sqlite] Sweet 16

2016-05-29 Thread Philip Bennefall
Incredible. Congratulations to Richard, Dan, Joe and the rest of the team on this incredible achievement. I'm not very active on this list, but I've been a casual sqLite user for years and it just keeps getting better. Keep up the great work! Kind regards, Philip Bennefall On 5/29/2016 7:28

[sqlite] Sweet 16

2016-05-29 Thread Richard Hipp
The first check-in of SQLite code occurred 16 years ago today. https://www.sqlite.org/src/timeline?c=2000-05-29 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/

[sqlite] Preventing certain query keywords from getting stemmed

2016-05-29 Thread Abhinav Upadhyay
Hi, While running queries, sometimes there are technical keywords which shouldn't be stemmed by the tokenizer. For example, if I query for "lfs" (which is a file system), the porter stemmer, converts it to "lf", which matches many other unrelated keywords in the corpus (such as ascii lf or some ot