Re: [sqlite] Opposite of SQLite

SQLdark is free to use for any purpose except those which benefit Anish Kapoor or an affiliate of Anish Kapoor. -Rowan On Fri, 11 Oct 2019 at 03:37, wrote: > etiLQS or SQLead or SQLdark > Haha > > On Thu, Oct 10, 2019, 3:07 PM David Raymond > wrote: > > > SQLephantine > > > > > > -Original

Re: [sqlite] Opposite of SQLite

IMS/DB Jim "Jed" Dodgen j...@dodgen.us On Thu, Oct 10, 2019 at 3:03 PM test user wrote: > CAHeavy > > Chaotic Answer Heavy > > On Thu, 10 Oct 2019 at 20:42, Simon Slavin wrote: > > > On 10 Oct 2019, at 7:55pm, Ned Fleming wrote: > > > > > SQLessLite > > > > SQDietStartsMonday > >

Re: [sqlite] Opposite of SQLite

CAHeavy Chaotic Answer Heavy On Thu, 10 Oct 2019 at 20:42, Simon Slavin wrote: > On 10 Oct 2019, at 7:55pm, Ned Fleming wrote: > > > SQLessLite > > SQDietStartsMonday > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org >

Re: [sqlite] SQLite plus the works (was Re: Opposite of SQLite)

Roman Fleysher, on Thursday, October 10, 2019 04:31 PM, wrote... > Imagine a vehicle which has wheels to drive on a road. And wings to fly and > a hull to float. How nice and happy world would be !? True? Of course true. > > But, this vehicle would be bad as a car, bad as an airplane and bad a

Re: [sqlite] SQLite plus the works (was Re: Opposite of SQLite)

On Oct 10, 2019, at 2:03 PM, Jose Isaias Cabrera wrote: > > 2. The normal SQlite snapshots plus a series of libraries and functions that > can easily be compiled with the original light SQLite. This is basically the model for FOSS OS distros: a bunch of people get together and work on a

Re: [sqlite] SQLite plus the works (was Re: Opposite of SQLite)

It's ok that you don't believe in it, but the last statement, you know is not true. I have been in this list since 2003 or so, and constantly there is one or two request to Dr. Hipp and the owners, per month, to add "stuff" to it. Or, things like, "I would love to have SQLite do...", etc.

Re: [sqlite] SQLite plus the works (was Re: Opposite of SQLite)

Roman Fleysher, on Thursday, October 10, 2019 04:17 PM, wrote... > > With your brain excluded, who is "we"? > > The beauty of SQLite is that SQL was distilled to the smallest and most > reproducible > on many platforms set. Over time, I see how developers expand functionality > to make it >

Re: [sqlite] SQLite plus the works (was Re: Opposite of SQLite)

> It has LEFT JOIN and does not have RIGHT JOIN. Why? Because RIGHT can be made > out of LEFT by swapping order of tables. The paradigma of SQL is to let the user describe what he wants to do, not to think about how to describe the problem so that the database system does understand. The lack

Re: [sqlite] SQLite plus the works (was Re: Opposite of SQLite)

Simon Slavin, on Thursday, October 10, 2019 04:12 PM, wrote... > > On 10 Oct 2019, at 9:03pm, Jose Isaias Cabrera, on > > > 2. The normal SQlite snapshots plus a series of libraries and functions that > can easily be compiled with the original light SQLite. > > Here's the simple way to start the

Re: [sqlite] SQLite plus the works (was Re: Opposite of SQLite)

With your brain excluded, who is "we"? The beauty of SQLite is that SQL was distilled to the smallest and most reproducible on many platforms set. Over time, I see how developers expand functionality to make it more convenient while maintaining reproducibility across platforms. Time, date,

Re: [sqlite] SQLite plus the works (was Re: Opposite of SQLite)

On 10 Oct 2019, at 9:03pm, Jose Isaias Cabrera wrote: > 2. The normal SQlite snapshots plus a series of libraries and functions that > can easily be compiled with the original light SQLite. Here's the simple way to start the project without breaking anything. Believers in SQLHeavy (or

Re: [sqlite] SQLite plus the works (was Re: Opposite of SQLite)

It would be very useful (for me anyway :-) if SQLite followed the Postgres way of being able to install extensions - so for things like Spatialite it would be more embedded than stuck on the side... Retain the core "lite" DBMS but better facilitate being able to expand the functionality.

[sqlite] SQLite plus the works (was Re: Opposite of SQLite)

Simon Slavin, on Thursday, October 10, 2019 03:42 PM, wrote... > > On 10 Oct 2019, at 7:55pm, Ned Fleming, on > > > SQLessLite > > SQDietStartsMonday All kidding aside, and naming continuing, :-), I believe the world will be a happier place with: 1. The normal SQLite snapshots (just like it's

Re: [sqlite] Opposite of SQLite

On 10 Oct 2019, at 7:55pm, Ned Fleming wrote: > SQLessLite SQDietStartsMonday ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Opposite of SQLite

etiLQS or SQLead or SQLdark Haha On Thu, Oct 10, 2019, 3:07 PM David Raymond wrote: > SQLephantine > > > -Original Message- > From: sqlite-users On > Behalf Of Ned Fleming > Sent: Thursday, October 10, 2019 2:55 PM > To: sqlite-users@mailinglists.sqlite.org > Subject: Re: [sqlite]

Re: [sqlite] Opposite of SQLite

SQLephantine -Original Message- From: sqlite-users On Behalf Of Ned Fleming Sent: Thursday, October 10, 2019 2:55 PM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Opposite of SQLite > Someone asked: > >>> What the opposite of "Lite”? > SQLessLite -- Ned

Re: [sqlite] Opposite of SQLite

On Thu, Oct 10, 2019 at 1:55 PM Ned Fleming wrote: > > > Someone asked: > > > >>> What the opposite of "Lite”? > > > > SQLessLite > NoSQLHeavy? > > -- > Ned > > -- I find television very educational. The minute somebody turns it on, I go into the library and read a good book -- Groucho

Re: [sqlite] Opposite of SQLite

Someone asked: What the opposite of "Lite”? SQLessLite -- Ned ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Segfault when using FILTER (WHERE) referencing aliases from a subquery

Thank you for the succinct bug report! A ticket for this problem can be seen here: https://www.sqlite.org/src/info/1079ad19993d13fa The problem is in the query flattener optimization (https://www.sqlite.org/optoverview.html#subquery_flattening) when applied to queries that use the new FILTER

[sqlite] Opposite of SQLite

Someone asked: >> What the opposite of "Lite”? As in SQLite my suggestion ’SQDark’ Klaas ‘Z4us’ van B. V ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Segfault when using FILTER (WHERE) referencing aliases from a subquery

Op do 10 okt. 2019 om 15:15 schreef Jan Nijtmans: > > Op do 10 okt. 2019 om 15:06 schreef Jose Isaias Cabrera: > > > Simon Charette, on Tuesday, October 8, 2019 08:00 PM, wrote... > > > > > > > > While trying to enable support for FILTER (WHERE) on SQLite 3.30 for > > > > the Django ORM we

Re: [sqlite] Date time input

> I hope you will experience such joy as well. Well, I don't ;-) The lack of full ALTER TABLE support frustrates me every time, even though I greatly appreciate most other parts of SQLite and the developers' work. But a more complete SQL statement support would be very, very helpful.

Re: [sqlite] Segfault when using FILTER (WHERE) referencing aliases from a subquery

Op do 10 okt. 2019 om 15:06 schreef Jose Isaias Cabrera: > > Simon Charette, on Tuesday, October 8, 2019 08:00 PM, wrote... > > > > > > While trying to enable support for FILTER (WHERE) on SQLite 3.30 for > > > the Django ORM we discovered a crash that can be reduced to the > > > following > I am

Re: [sqlite] Segfault when using FILTER (WHERE) referencing aliases from a subquery

Jose Isaias Cabrera, on Thursday, October 10, 2019 08:55 AM, wrote... > Simon Charette, on Tuesday, October 8, 2019 08:00 PM, wrote... > > > > While trying to enable support for FILTER (WHERE) on SQLite 3.30 for > > the Django ORM we discovered a crash that can be reduced to the > > following > >

Re: [sqlite] Segfault when using FILTER (WHERE) referencing aliases from a subquery

> > Simon Charette, on Tuesday, October 8, 2019 08:00 PM, wrote... > > While trying to enable support for FILTER (WHERE) on SQLite 3.30 for > the Django ORM we discovered a crash that can be reduced to the > following > > sqlite> CREATE TABLE item (id int, price int); > sqlite> INSERT INTO item

[sqlite] Segfault when using FILTER (WHERE) referencing aliases from a subquery

While trying to enable support for FILTER (WHERE) on SQLite 3.30 for the Django ORM we discovered a crash that can be reduced to the following sqlite> CREATE TABLE item (id int, price int); sqlite> INSERT INTO item (id, price) VALUES (1, 1); sqlite> SELECT COUNT(id) FILTER (WHERE double_price >

Re: [sqlite] Date time input

On 10/10/2019 07:50, J Decker wrote: It's 'ite' as in 'stalagmite' or 'meteorite' as in rock solid... https://changelog.com/podcast/201 " RICHARD HIPP How do I pronounce the name of the product? I say S-Q-L-ite, like a mineral. So probably