Re: [sqlite] How to check if a record exists

2014-11-04 Thread Darren Duncan
itself, as that practice generally leads to huge security problems / SQL injection (although if your language is strongly typed an int wouldn't do it, but a string would). -- Darren Duncan On 2014-11-04 1:47 PM, Drago, William @ CSG - NARDAEAST wrote: All, I've been pulling my hair out trying

Re: [sqlite] Autoincrement with rollback

2014-11-11 Thread Darren Duncan
nce generator first in its own transaction and remember the value, then use that remembered value in your main transaction that you explicitly do afterwards. Do you understand what's going on now? -- Darren Duncan ___ sqlite-users mailing list sqlite-u

Re: [sqlite] equivalent for JOIN LATERAL

2015-02-08 Thread Darren Duncan
I recall that http://blog.heapanalytics.com/postgresqls-powerful-new-join-type-lateral/ shows how Pg 9.3's LATERAL join is useful in practice, as it lets you do in declarational SQL what you may have needed procedural code for before, in which case it is an improvement. -- Darren Duncan

Re: [sqlite] Searching this mailing lsit

2016-05-24 Thread Darren Duncan
zation. -- Darren Duncan ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

2016-05-27 Thread Darren Duncan
, rather that's an argument for not using your work email to subscribe to non-work discussion lists; use a non-work email for the discussion lists instead. You can also configure your email client to only check email when you tell it to rather than constantly. -- Darren Duncan

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

2016-05-27 Thread Darren Duncan
for anything. If you want something bigger than SQLite, look at Postgres instead of MySQL. As a bonus, the Postgres documentation is much better. -- Darren Duncan ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

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

2016-05-27 Thread Darren Duncan
On 2016-05-27 2:34 AM, Tim Streater wrote: On 27 May 2016 at 08:56, Darren Duncan <dar...@darrenduncan.net> wrote: On 2016-05-26 9:00 PM, Balaji Ramanathan wrote: The main advantage of forums, and I follow a bunch of them, is that I choose when I want to stop my regular d

[sqlite] Enhance the SELECT statement?

2015-08-17 Thread Darren Duncan
dern days even when supported, unless its the only option. AFAIK, INSERT...INTO was only ever for use within a SQL stored procedure for assigning to a lexical variable. At least I've never seen it used the way you introduced. -- Darren Duncan

[sqlite] Aquameta Layer 0: meta - Writable System Catalog for PostgreSQL

2015-08-29 Thread Darren Duncan
ble to do all catalog/code manipulation as data, or homoiconicity. In fact this is a central pillar of my own Muldis D project, an industrial strength programming language with fully integrated database functionality. -- Darren Duncan

[sqlite] Aquameta Layer 0: meta - Writable System Catalog for PostgreSQL

2015-08-29 Thread Darren Duncan
the C style like most popular application languages and functional language style. I will make an announcement when you can run it, hopefully within about 2 months. -- Darren Duncan On 2015-08-29 2:55 PM, Domingo Alvarez Duarte wrote: > I like the overall idea but of Muldis D (like the aquam

[sqlite] Aquameta Layer 0: meta - Writable System Catalog for PostgreSQL

2015-08-29 Thread Darren Duncan
e. If a DBMS' standard database dump includes details that can't be gleaned from the DBMS' INFORMATION_SCHEMA, then the latter isn't sufficiently exhaustive, and would need to be extended in order for an updateable version to fully replace distinct DDL. (Case in point, MySQL is deficient in this way, I know from experience.) -- Darren Duncan

[sqlite] Problem with accumulating decimal values

2015-12-12 Thread Darren Duncan
t to store, but just an approximation. Per another suggestion, the best workaround is to use an INTEGER type instead, and store an even multiple of whatever your smallest currency unit size is, eg cents rather than dollars. -- Darren Duncan On 2015-12-11 6:21 AM, Frank Millman wrote: >

[sqlite] Putting an index on a boolean

2015-12-12 Thread Darren Duncan
key fields where every record has a different value from every other record. UUIDs have this quality in spades. It is even more important to index such fields if you will either be searching/filtering on them or if they are the parent in a foreign key constraint. This has always been the case, its not a new thing. -- Darren Duncan

[sqlite] Putting an index on a boolean

2015-12-12 Thread Darren Duncan
comment re binary. -- Darren Duncan On 2015-12-12 1:12 PM, Mark Hamburg wrote: > Though to the extent that speed is proportional to data size, it would be > good to use something other than hexadecimal to store UUIDs. Binary blobs > would be the most compact, but ASCII85 encoding would

[sqlite] I have no idea what to install!

2015-12-12 Thread Darren Duncan
o find answers with less effort on everyone's part if you do that. -- Darren Duncan

[sqlite] whish list for 2016

2015-12-20 Thread Darren Duncan
FUPDATE_.28.22UPSERT.22.29 Example: INSERT INTO user_logins (username, logins) VALUES ('Naomi',1),('James',1) ON CONFLICT (username) DO UPDATE SET logins = user_logins.logins + EXCLUDED.logins; -- Darren Duncan

[sqlite] whish list for 2016

2015-12-21 Thread Darren Duncan
On 2015-12-21 8:25 AM, Petite Abeille wrote: >> On Dec 21, 2015, at 4:08 AM, Darren Duncan >> wrote: >> >> If you want that feature, instead do it the better way that Postgres 9.5 >> did, which is as an extension to the INSERT statement in the form "ON >&g

[sqlite] whish list for 2016

2015-12-21 Thread Darren Duncan
nerate 1,2,3=,3=,5 type sequences from > self-joins but it seems a lot easier to do it in Delphi! I agree with adding RANK, it is very useful. -- Darren Duncan

[sqlite] whish list for 2016

2015-12-28 Thread Darren Duncan
arately for the users' sake, while the actual columns have no significant order in the database. Display order is also just one of many kinds of useful meta-data, and storing that separately allows you to have whatever kinds of meta you want without complicating the core system. -- Darren Duncan

[sqlite] Magic number in sqlite source code

2015-12-30 Thread Darren Duncan
e constant then you would also rename this particular constant to match the new value, but the key thing is you have something easily look-upable that shows all the 4 are connected. -- Darren Duncan

[sqlite] List duplication

2015-02-27 Thread Darren Duncan
qlite.org . But both of those are aliases for the same list. Whoever is doing this, sending your messages to both, please stop, just send to one, and then people would get one copy. -- Darren Duncan On 2015-02-27 12:09 PM, Peter Aronson wrote: > I've seen it too. All of the duplicate messages ap

[sqlite] List duplication

2015-02-28 Thread Darren Duncan
On 2015-02-28 3:15 AM, R.Smith wrote: > On 2015-02-28 05:02 AM, Darren Duncan wrote: >> I'm seeing a lot of message duplication too, but the ones I see are due to >> someone putting the list address twice as a recipient. >> >> For example a bunch of the "PhD stud

[sqlite] Schema-less JSON SQLite DB?

2015-07-14 Thread Darren Duncan
Have a look at PostgreSQL 9.4 as well and its new JSONB data type. Gives you the goods of relational and hierarchical databases in one place, including the querying and indexing. -- Darren Duncan On 2015-07-13 5:43 PM, Hayden Livingston wrote: > Is there a concept of a schema-less J

[sqlite] This mailing list seems to be public

2015-06-15 Thread Darren Duncan
Like most mailing lists about open source software, list archives are visible to the general public, which is what I think should be the norm. Generally restrictions to members just concern posting, its a simple way to keep spam out, one has to confirm an email address to post. -- Darren

[sqlite] relational algebra vs calculus (was Re: Mozilla wiki 'avoid SQLite')

2015-06-15 Thread Darren Duncan
above example should make more clear what's going on. -- Darren Duncan On 2015-06-15 5:46 PM, Christopher Vance wrote: > With a relational model you have a choice between relational calculus or > relational algebra. SQL does one of them. > > I have used a language which did the oth

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-16 Thread Darren Duncan
s for both routines and relations (tables) etc are arbitrary/variable depth like you propose, like either the Unix file system or like programming languages such as Perl or C# or others. Note that Muldis D and Andl have some influences in common, but David beat me to market as it were with an executable. -- Darren Duncan

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-17 Thread Darren Duncan
alternative. I also believe the world is ripe to have SQL alternatives, its just a matter of ones appearing that are compelling to users for real work and not just an academic exercise. The fact we're still generally with SQL means this hasn't happened yet, but that doesn't mean it won't. -- Darren Duncan

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-18 Thread Darren Duncan
circumlocution. That is how you would simplify the transition and re-utilization of existing code. The good alternative would actually be easier for a DBMS to implement also without losing any power. -- Darren Duncan On 2015-06-17 11:52 PM, ajm at zator.com wrote: > Indeed, I'm ag

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-18 Thread Darren Duncan
anging whatever it wants to do to implement the over-all expression efficiently, in fact a DBMS may even have an easier time of it. Don't get me wrong, a new language can have these qualities and still look familiar to SQL users, its not like it means using APL etc. -- Darren Duncan

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-18 Thread Darren Duncan
than just SQLite specifically. That also means that the SQL alternative would in practice be a language family itself, assuming multiple implementations, though hopefully they would be a lot more consistent with each other than the SQL family languages have ended up being. -- Darren Duncan On 201

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-18 Thread Darren Duncan
programming language, but subsequent implementations will cross-compile as possible to existing SQL DBMSs so the work in those engines can be leveraged as possible. The reference is standalone so I am not limited by what current DBMSs support to make it work. -- Darren Duncan On 2015-06-18 2

[sqlite] Tables and Columns of Database of Whatsapp

2015-06-29 Thread Darren Duncan
just the program. At the very least, since WhatsApp databases store user data, it should be reasonable to understand their structure in order that users can extract their own data from them reliably. -- Darren Duncan On 2015-06-29 6:42 AM, John McKown wrote: > On Sun, Jun 28, 2015 at 7:24

[sqlite] Tables and Columns of Database of Whatsapp

2015-06-29 Thread Darren Duncan
a clean-room scenario, you're just looking at your data file. -- Darren Duncan On 2015-06-29 3:19 PM, Darren Duncan wrote: > I think a WhatsApp database is analogous to a data file and falls outside the > concept of reverse engineering here. > > If say Microsoft Word had legalize aga

[sqlite] List duplication

2015-03-02 Thread Darren Duncan
I think that what needs to be done is for each foo at sqlite.org to return an error/undeliverable message if someone sends a message to it, citing that all messages must be explicitly sent to the corresponding foo at mailinglists.sqlite.org. That should handily solve the problem. -- Darren

[sqlite] List duplication

2015-03-02 Thread Darren Duncan
On 2015-03-02 3:04 PM, R.Smith wrote: > On 2015-03-03 12:42 AM, Darren Duncan wrote: >> I think that what needs to be done is for each foo at sqlite.org to return an >> error/undeliverable message if someone sends a message to it, citing that all >> messages mu

[sqlite] List duplication

2015-03-02 Thread Darren Duncan
On 2015-03-02 6:08 PM, Mike Owens wrote: > On Mon, Mar 2, 2015 at 5:24 PM, Darren Duncan > wrote: >> As near as I can tell, the Reply-To header from this list only contains >> sqlite-users at mailinglists.sqlite.org and does not also contain >> sqlite-users at sqlite.org

[sqlite] List duplication

2015-03-02 Thread Darren Duncan
iling lists. We'll try to stay as agnostic as possible, but our >> biases may still peak through. >> > > That's as much as I'll say about that. Well it doesn't have to be complete munging, rather just enough munging to remove references to the old mailing list name. -- Darren Duncan

[sqlite] List duplication

2015-03-02 Thread Darren Duncan
is reminding people to pay attention until the issue as a consequence goes away. Thus any explicit Reply-To headers can be left unmunged by the list server. -- Darren Duncan On 2015-03-02 7:10 PM, Mike Owens wrote: > The problem is that this is the very bone of contention in the re

[sqlite] List duplication

2015-03-02 Thread Darren Duncan
So far so good. I only got one copy of your test message. I also sent my own message to just sqlite-users at sqlite.org and it was bounced as expected. -- Darren Duncan On 2015-03-02 8:14 PM, Mike Owens wrote: > Okay, I blocked the sqlite-users at sqlite.org address in the to address &

[sqlite] restructuring databases (was Re: Can I copy one column of data to another table?)

2015-03-07 Thread Darren Duncan
with duplicate data in the source, find or handle with SELECT GROUP BY etc rather than trying conditional INSERT logic or what have you. -- Darren Duncan

[sqlite] C++ ORM

2015-03-09 Thread Darren Duncan
plications, and the same arbitrary user-defined types you can use in applications can be used directly in databases, no "mapping" required. I hope to have a first version executing in about 2 months. -- Darren Duncan

[sqlite] When to disambiguate column names in queries?

2015-03-16 Thread Darren Duncan
If you design your database schemas such that, where possible, corresponding columns have the same names in all tables, and you do natural joins, the problem will basically go away. -- Darren Duncan On 2015-03-16 9:16 AM, Drago, William @ CSG - NARDA-MITEQ wrote: > All, > > Some of

[sqlite] Two different Order By in one statement

2015-03-31 Thread Darren Duncan
nner query in the FROM clause to generate the fields you want to sort on, and then ORDER BY on them in the outer query. -- Darren Duncan On 2015-03-31 5:31 PM, R.Smith wrote: > On 2015-04-01 01:50 AM, Bart Smissaert wrote: >> Say I have a table with 3 fields. Depending on a value in fie

[sqlite] Please confirm what I THINK I know about blobs

2015-05-09 Thread Darren Duncan
for example. This can't be counted on for all BLOBs, but can work for some. Meta-data is good to have. -- Darren Duncan On 2015-05-09 3:20 AM, Richard Hipp wrote: > On 5/9/15, William Drago wrote: >> All, >> >> Say you encounter a blob in a database. There's no way to >>

[sqlite] AUTOINC vs. UUIDs

2015-05-21 Thread Darren Duncan
o grasp that each entire tuple/row in a relation/table is by definition its own identity. If no subset of attributes/columns is a key, the entire tuple/row can be used to identify which tuple/row you're talking about. -- Darren Duncan

[sqlite] AUTOINC vs. UUIDs

2015-05-21 Thread Darren Duncan
o also can be rolled back and repeat. That's all that standard SQL/etc sequence generators are, regular user data, and one shouldn't be fooled into thinking they are something else. -- Darren Duncan On 2015-05-20 4:21 PM, Keith Medcalf wrote: > All relational database engines store configuratio

[sqlite] AUTOINC vs. UUIDs

2015-05-21 Thread Darren Duncan
sertion has no impact on their final values (in the absense of triggers). In that respect uuids can be better than auto-inc because you lose those coupling problems. On the other hand uuids themselves should be used very sparingly, and I haven't really seen a reason to use them yet. -- Darren Duncan

Re: [sqlite] Nested transactions

2013-11-23 Thread Darren Duncan
at don't lock the whole database they may be useful with. -- Darren Duncan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Nested transactions

2013-11-23 Thread Darren Duncan
today don't have the precondition of a "transaction" being active to use them, so on their own "savepoint" is like a generalization of a "transaction". -- Darren Duncan ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] A read right after a write does not read changes

2013-12-11 Thread Darren Duncan
be taking up with the makers or a users group of the wrapper for help. You should be asking in some support forum specific to Entity Framework about this problem. -- Darren Duncan ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] Recursive query?

2014-01-10 Thread Darren Duncan
e sponsor is now indicating that they want to go with WITH RECURSIVE. So the CONNECT BY branch has been closed and we are starting to work on a WITH RECURSIVE implementation. That's great news! This will be a serious step up in feature set for SQLite, both in ease of use and power, I look forward

Re: [sqlite] Recursive query?

2014-01-12 Thread Darren Duncan
t have WITH RECURSIVE without WITH. -- Darren Duncan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] "Common Table Expression"

2014-01-17 Thread Darren Duncan
require creation of separate schema objects, while someone with read-only access to a db can use WITH, especially beneficial for ad-hoc reports. -- Darren Duncan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] How should I use parenthesis?

2014-01-28 Thread Darren Duncan
ith a join condition saying which fields you want to be used for matching in the join, and also replace the "select *" with a specific list of fields you want to match up for the union. -- Darren Duncan ___ sqlite-users mailing list sqlite-u

Re: [sqlite] Why SQLITE_FLOAT instead of SQLITE_REAL?

2014-03-01 Thread Darren Duncan
ot;. Whereas, "float" is best suited for the name of a concrete type, like with "integer" and "ratio". (Well strictly speaking all of these could be abstract types, but the latter set are more specific in meaning, and in particular "ratio" and &qu

Re: [sqlite] SQLite destroys civilization.

2014-03-02 Thread Darren Duncan
on is like that too. I have seen several others that are on the realistic side. But a counter-example is a show I saw where they had "programming code" but it was actually HTML source, which really shows those ones didn't do thei

Re: [sqlite] basic "Window function"

2014-03-13 Thread Darren Duncan
there is yet another significant way in which SQLite is more powerful than MySQL (but not PostgreSQL), the WITH support being another, and subjecting data definition to transactions is another. -- Darren Duncan ___ sqlite-users mailing list sqlite-u

Re: [sqlite] if possible point another table

2014-04-03 Thread Darren Duncan
. There's no reason that table names can't be values in principle. -- Darren Duncan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite-users list failed to block large attachment

2014-05-13 Thread Darren Duncan
Is something wrong with the configuration of this sqlite-users list? A message of subject "Porting SQLite to plain C RTOS" was allowed and distributed through it this morning with attachments. Not only attachments, but about 5MB of attachments. -- Dar

Re: [sqlite] Variable number of parameters in a prepared statement's IN clause

2014-07-20 Thread Darren Duncan
parameters in a temporary table and then use that for the join in a subsequent select. -- Darren Duncan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] FW: how best to determine # of rows in a table

2014-08-27 Thread Darren Duncan
ather than hard. -- Darren Duncan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] FW: how best to determine # of rows in a table

2014-08-27 Thread Darren Duncan
Sorry, the count thing was actually Mark Halegua's question. -- Darren Duncan On 2014-08-27, 8:58 PM, Darren Duncan wrote: On 2014-08-27, 8:41 PM, Keith Medcalf wrote: this may seem like a small issue, but I'm not sure if the solutions I've found on the web will do what I want in a low memory

Re: [sqlite] Sorting by month with two dates input

2014-08-31 Thread Darren Duncan
), t FROM ( SELECT cust, ProjFund, Xtra8, coalesce(billdate,bdate) as t FROM LSOpenProjects WHERE billdate BETWEEN '2013-01-01' AND '2013-12-31' OR bdate BETWEEN '2013-01-01' AND '2013-12-31' ) x GROUP BY substr(t,1,7), cust; -- Darren Duncan ___ sqlite

Re: [sqlite] Sorting by month with two dates input

2014-08-31 Thread Darren Duncan
On 2014-08-31, 9:35 PM, Darren Duncan wrote: On 2014-08-31, 9:10 PM, jose isaias cabrera wrote: SELECT cust, sum(ProjFund), sum(Xtra8), coalesce(billdate,bdate) as t FROM LSOpenProjects WHERE billdate BETWEEN '2013-01-01' AND '2013-12-31' OR bdate BETWEEN '2013-01-01' AND '2013-12-31' GROUP

Re: [sqlite] Sorting by month with two dates input

2014-09-01 Thread Darren Duncan
A common logical error that may be affecting you is, do your dates include a time portion or are they just year-month-day? If they include a time portion, then records from Dec 31 likely won't be counted as your 'between' arguments may be equivalent to '2013-12-31 00:00:00'. -- Darren Duncan

Re: [sqlite] Sorting by month with two dates input

2014-09-01 Thread Darren Duncan
other value, which is how it is supposed to be. -- Darren Duncan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Transactions for read operations

2014-09-06 Thread Darren Duncan
changed by accident. -- Darren Duncan On 2014-09-06, 7:22 PM, Richard Warburton wrote: Hi, Brief: Should transactions be used for ensuring consistency between multiple queries? And if so, after I've finished is there a reason why I should not call commit? Background: I'm using SQLite for a web

Re: [sqlite] The IN (... ) clause

2014-09-14 Thread Darren Duncan
-05') where the content of the IN would have the first item and the last item of the list, but that's it? Thanks. You're talking about a range/interval. In SQL it is spelled like this: BETWEEN '2014-01-01' AND '2014-01-05' -- Darren Duncan

Re: [sqlite] Lack of "decimal" support

2011-03-26 Thread Darren Duncan
rs like they were one number. You would then know at the end how to move the radix point since that was kept track of along with the number. -- Darren Duncan > On Sat, Mar 26, 2011 at 8:15 PM, BareFeetWare <list@barefeetware.com> > wrote: >> On 27/03/2011, at 12:39 PM, Patrick

Re: [sqlite] Lack of "decimal" support

2011-03-26 Thread Darren Duncan
Patrick Earl wrote: > On Sat, Mar 26, 2011 at 10:03 PM, Darren Duncan <dar...@darrenduncan.net> > wrote: >> You could store your exact precision numbers as a pair of integers >> representing >> a numerator/denominator ratio and then have math operators that work on

Re: [sqlite] Lack of "decimal" support

2011-03-27 Thread Darren Duncan
function you speak of and how does it differ from "sum"? Also, it's better to call a function "mean" than "avg" if that's what is intended, since there are other kinds of averages like "median" and "mode". -- Darren Duncan _

Re: [sqlite] Lack of "decimal" support

2011-03-27 Thread Darren Duncan
thing, which is a string of bits. Maybe you're just wanting more operators so it is easier to introspect or manipulate them? -- Darren Duncan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Usefulness of FKs to multiple tables

2011-05-19 Thread Darren Duncan
're just saying that you can only have a z record when you have both corresponding x and y records. I'm sure there are various business rules that this would effectively model. -- Darren Duncan ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Making data and tables persistent

2011-06-02 Thread Darren Duncan
e you using a regular file-based database or a MEMORY one? -- Darren Duncan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Do I need to migrate to MySQL?

2011-06-03 Thread Darren Duncan
MySQL should be avoided like the plague. Use Postgres instead if you have to switch to a larger SQL DBMS. But hopefully the help you've gotten so far will extend your mileage with SQLite and you won't have to switch to anything yet. -- Darren Duncan Ian Hardingham wrote: > Guys, the ser

Re: [sqlite] Do I need to migrate to MySQL?

2011-06-03 Thread Darren Duncan
Mr. Puneet Kishor wrote: > On Jun 3, 2011, at 1:19 PM, Darren Duncan wrote: >> MySQL should be avoided like the plague. > > why? > > This is a long standing (un)conventional wisdom to which I too have hewed. > Now, it so happens, I will be starting work on a project that

Re: [sqlite] Do I need to migrate to MySQL?

2011-06-04 Thread Darren Duncan
Mr. Puneet Kishor wrote: > On Jun 3, 2011, at 6:16 PM, Darren Duncan wrote: >> a. MySQL silently ignores all CHECK constraints in all engines, so for >> example you can't even tell it you want a column to only hold values >> between 1 and 10. Its in the MySQL docs: "

Re: [sqlite] Do I need to migrate to MySQL?

2011-06-05 Thread Darren Duncan
Darren Duncan wrote: > MySQL should be avoided like the plague. I hereby retract my above-quoted statement as I realize that it is too severe a statement to be making. Instead I will say the following in its place: MySQL should not be considered as the default choice of a non-lite SQL D

Re: [sqlite] Do I need to migrate to MySQL?

2011-06-05 Thread Darren Duncan
Dagdamor wrote: > Darren Duncan <dar...@darrenduncan.net> писал(а) в своём письме Mon, 06 Jun > 2011 05:08:45 +0600: >> MySQL should not be considered as the default choice of a non-lite SQL >> DBMS, for projects not currently using it, when you have a choice between >&g

Re: [sqlite] Ensure that query acts on PRE-SORTED tables

2011-07-01 Thread Darren Duncan
urn some extra column that contains an order number, such as using the RANK() SQL window function would give you. -- Darren Duncan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is it okay to use SQLite + PHP for Library Software?

2011-08-15 Thread Darren Duncan
open-ils.org/ which is an open source project developed by and for libraries, and that has been used in production for a few years now in many libraries. You should adapt this or modify it to meet your needs rather than start a new one, unless you can

Re: [sqlite] forcing X'' literals in sqlite3's .dump?

2011-08-17 Thread Darren Duncan
prevents anyone from using the SQLite source by itself under the public domain, no matter how anyone gets their copy of SQLite, whether linked with readline or not. -- Darren Duncan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

Re: [sqlite] No error on selecting non-grouped column

2011-09-14 Thread Darren Duncan
As I said, this is *good*. Now if there is any reason to be more restrictive, it would be that one can't reference a field directly in the select list that isn't in the group by unless we are grouping by a key of the table that the fields in the select list are from, so we

Re: [sqlite] MC/DC coverage explained wrong in the home page?

2011-09-23 Thread Darren Duncan
erators is essential. The non-short-circuiting boolean operators would be for all other uses, where the validity of one argument doesn't depend on the values of any of the other arguments, and so the compiler can be free to reorder it. -- Darren Duncan __

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

2011-10-19 Thread Darren Duncan
those, same as a mailing list would, and people can reply by email and then their replies end up on the forum as if someone had used the web to do it. It is important to have email copies of everything, which I can archive locally. -- Darren Duncan

Re: [sqlite] JOIN vs IN

2011-11-11 Thread Darren Duncan
oo = 3" is also a trivial case of a semijoin where the table you are filtering on has exactly 1 row whose field value is 3, and ostensibly such WHERE clauses should also be optimizable. -- Darren Duncan ___ sqlite-users mailing list sqlite-u

Re: [sqlite] Referencing subquery several times

2011-11-12 Thread Darren Duncan
syntax may be wrong): WITH (SELECT * FROM a) AS sfa, (SELECT * FROM b) AS sfb : SELECT * FROM m WHERE c IN sfa OR c IN sfb AND (NOT c IN sfa OR c IN sfb)); -- Darren Duncan ___ sqlite-users mailing list sqlite-users@sqlite.org ht

Re: [sqlite] Inserting Multiple Rows in a single statement

2011-11-29 Thread Darren Duncan
Sreekumar TP wrote: Is it possible to insert multiple rows using a single statement ? Yes. INSERT INTO foo (x, y) VALUES (1,2), (3,4), (5,6),...; INSERT INTO foo (x,y) SELECT x, y FROM bar; That's at least 2 ways. -- Darren Duncan ___ sqlite

[sqlite] How mature/stable is SQLite 4 now? ETA?

2015-05-23 Thread Darren Duncan
More like It'll be out in time for Christmas, where the specific year isn't mentioned. -- Darren Duncan On 2015-05-23 11:09 AM, Mikael wrote: > This sounds like it means we'll have it 2.5-5 years then.. so 2018 maybe, > > Sounds about correct? :) > > > 2015-05-23 23:06

[sqlite] How hard is it to add the constraint name to the 'FOREIGN KEY constraint failed' message?

2015-11-17 Thread Darren Duncan
on a failure we already know happened. This add-on could also be a compile-time option to exclude if desired. -- Darren Duncan On 2015-11-17 2:32 PM, Richard Hipp wrote: > On 11/17/15, Yuri wrote: >> This message always leaves the user wondering: "Which constraint?" >>

[sqlite] How hard is it to add the constraint name to the 'FOREIGN KEY constraint failed' message?

2015-11-18 Thread Darren Duncan
t for enforcing constraints. SQL immediate constraints break this ease of use. -- Darren Duncan

[sqlite] How hard is it to add the constraint name to the 'FOREIGN KEY constraint failed' message?

2015-11-18 Thread Darren Duncan
On 2015-11-18 1:27 AM, Yuri wrote: > On 11/18/2015 01:17, Darren Duncan wrote: >> >> Deferred constraints are definitely a benefit. >> >> They allow you to express constraints otherwise not possible, for example >> that >> a record may exist in table X if an

[sqlite] How hard is it to add the constraint name to the 'FOREIGN KEY constraint failed' message?

2015-11-18 Thread Darren Duncan
On 2015-11-18 1:58 AM, Dominique Devienne wrote: > On Wed, Nov 18, 2015 at 10:17 AM, Darren Duncan > wrote: > >> Deferred constraints are definitely a benefit. > >> They allow you to express constraints otherwise not possible, for example >> that a record ma

[sqlite] How hard is it to add the constraint name to the 'FOREIGN KEY constraint failed' message?

2015-11-18 Thread Darren Duncan
operation, which is my point. -- Darren Duncan On 2015-11-18 2:06 AM, Darren Duncan wrote: > On 2015-11-18 1:58 AM, Dominique Devienne wrote: >> On Wed, Nov 18, 2015 at 10:17 AM, Darren Duncan >> wrote: >> >>> Deferred constraints are definitely a benefit. &g

[sqlite] How hard is it to add the constraint name to the 'FOREIGN KEY constraint failed' message?

2015-11-18 Thread Darren Duncan
On 2015-11-18 2:05 AM, Dominique Devienne wrote: > On Wed, Nov 18, 2015 at 10:58 AM, Darren Duncan > wrote: > >> On 2015-11-18 1:27 AM, Yuri wrote: >>> I agree they can be beneficial, but not in all cases. Depends on what you >>> do. It >>> wou

[sqlite] Dont Repeat Yourself (DRY) and SQLite

2015-11-24 Thread Darren Duncan
sql.org/docs/9.4/static/datatype-enum.html . Do what Simon says. I don't see a problem here. -- Darren Duncan On 2015-11-24 3:24 PM, Domingo Alvarez Duarte wrote: > If we do that we'll be repeating the same string on every column and need a > string comparison, with postgres enum type

[sqlite] Dont Repeat Yourself (DRY) and SQLite

2015-11-25 Thread Darren Duncan
'/'tuple' there are various places in the application that specifically dispatch different logic depending on those values, whereas with data, such as an enumeration of country names, it would not be the case. -- Darren Duncan On 2015-11-25 7:14 AM, Simon Slavin wrote: > On 25 Nov 2015, at 2:2

[sqlite] Warnings for non-deterministic queries?

2015-11-27 Thread Darren Duncan
ble change is significant; if the user can get a different answer to any question about the database, including 'hidden' parts, then the database is different, whereas if all questions they can ask return the same answer, then the "arbitrary row" should be the same row. -- Darren Duncan

[sqlite] SQLite version 3.8.12 enters testing

2015-10-07 Thread Darren Duncan
the change to not break anything / be fully backwards-compatible, whether due to being a new feature or a bug fix. -- Darren Duncan On 2015-10-07 1:13 PM, Scott Robison wrote: > Really, the SQLite3 versioning isn't that far off from Semantic Versioning. > Instead of MAJOR.MINOR.PATCH w

[sqlite] Proposed new version numbering scheme for SQLite - Feedback requested

2015-10-08 Thread Darren Duncan
, or such as for marketing reasons. Richard, does that still seem to describe your intentions? -- Darren Duncan On 2015-10-08 6:38 AM, Richard Hipp wrote: > Several users have proposed that SQLite adopt a new version numbering > scheme. The proposed change is currently uploaded on the "draft

  1   2   3   4   5   6   >