[sqlite] Question on how to enter blobs in sqlite3

Hello, I am using sqlite3 on am embedded platform. I am using c++ to enter data. I have BLOB field, and I do not know how to enter hex values from a data string. I am trying to use update, but how do I enter col_name=' data ' format? How does ' escaping work? I could not find help on the

Re: [sqlite] Question on how to enter blobs in sqlite3

or error from sqlite3. Roman On Tuesday 04 April 2006 05:21 pm, Thomas Chust wrote: > On Tue, 4 Apr 2006, Roman wrote: > > [...] I am using sqlite3 on am embedded platform. I am using c++ to > > enter data. I have BLOB field, and I do not know how to enter hex values > > from

[sqlite] How can I rename a column without ALTER COLUMN Command

I know that ALTER TABLE -> ALTER COLUMN is not supported by sqlite3. I misspelled a column name, and I am curious if there is a command to change the name from sqlite3 interface. Thanks, RK

Re: [sqlite] How can I rename a column without ALTER COLUMN Command

http://sqlzoo.net/howto/source/z.dir/tip557646/i02create.xml says that such is not possible On Friday 07 April 2006 11:39 am, Roman wrote: > I know that ALTER TABLE -> ALTER COLUMN is not supported by sqlite3. > > I misspelled a column name, and I am curious if there is a command

Re: [sqlite] How can I rename a column without ALTER COLUMN Command

Hi Dennis, I followed your path and managed to rebuild my table. All is well in the land of Roman now. Thanks again, Roman On Friday 07 April 2006 11:57 am, Dennis Cote wrote: > Roman wrote: > >http://sqlzoo.net/howto/source/z.dir/tip557646/i02create.xml > > > >says that

[sqlite] database is locked

it now. The time stamp on the file is from yesterday, showing correct time. I need to update a table (I use shell) and I get "database is locked". Is there a way to figure out what is happening? Clear the lock? Thank you for your help, Roman

Re: [sqlite] database is locked

Subject: Re: [sqlite] database is locked On 1/14/15, Roman Fleysher <roman.fleys...@einstein.yu.edu> wrote: > Dear SQLiters, > > There has been a lot of discussion, I remember, on this subject by others. > Please forgive me for asking this for a millionth time. > > I somehow got

Re: [sqlite] database is locked

Thank you, Richard. You are correct, I made a typo: we have NFS not NTFS and I know they are buggy. I always use the same node on our compute cluster to minimize buffering issue. So, are you saying I can not clear the database lock and must rebuild the database? Roman

Re: [sqlite] database is locked

Thank you!! Roman From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Richard Hipp [d...@sqlite.org] Sent: Wednesday, January 14, 2015 1:31 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] database

Re: [sqlite] database is locked

Wow, thank you Hick! I will try it. Roman From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Hick Gunter [h...@scigames.at] Sent: Thursday, January 15, 2015 1:34 AM To: 'General Discussion of SQLite Database' Subject: Re

[sqlite] PhD student

I like that!!! Roman From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at mailinglists.sqlite.org] on behalf of Simon Slavin [slav...@bigfraud.org] Sent: Thursday, February 26, 2015 5:33 AM To: General Discussion of SQLite

[sqlite] how to cite SQLite

. Thank you, Roman

[sqlite] how to cite SQLite

grateful to all SQLiters for making SQLite available. Roman From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at mailinglists.sqlite.org] on behalf of Richard Hipp [d...@sqlite.org] Sent: Monday, July 13, 2015 11:54 AM To: General

[sqlite] how to cite SQLite

, if it exists. Obviously, software may also impement other algorithms developed by other people, not directly the software developers. I would expect the "main" SQLite publication to mention them. Roman From: sqlite-use

[sqlite] Thanks SQLite

data. I was elated when I implemented first equation. This is like stored procedure. Roman From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at mailinglists.sqlite.org] on behalf of R.Smith [rsm...@rsweb.co.za] Sent: Wednesday

[sqlite] select * where is/like ?

sqlite> select 'a'||examID||'a', typeof(examID) from mainDB.Exam where mainDB.Exam.examID like 30; 'a'||examID||'a' typeof(examID) -- a30a integer sqlite> select 'a'||examID||'a', typeof(examID) from mainDB.Exam where mainDB.Exam.examID=30; sqlite> Thank you, Roman

[sqlite] select * where is/like ?

CREATE TABLE Exam( examID TEXT PRIMARY KEY NOT NULL I will also add, as most inexperienced programmers do, "but it worked before". The database was created with older version of SQLITE and the code worked with the same older version. Could it matter? Thank y

[sqlite] select * where is/like ?

ral Discussion of SQLite Database Subject: Re: [sqlite] select * where is/like ? On 19 May 2015, at 4:07pm, Roman Fleysher wrote: > CREATE TABLE Exam( > examID TEXT PRIMARY KEY NOT NULL Works fine for me. I tested inserting as text, integer and real in case they did something weir

[sqlite] select * where is/like ?

RE solved the problem. However, manual says "=" and "IS" are identical except when treating "NULL". What is the difference? Roman From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at mailin

[sqlite] select * where is/like ?

On 19 May 2015, at 4:43pm, Roman Fleysher wrote: > Now I have two questions: > > 1. I created database from scratch using new version of SQLITE and PRAGMA > integrity_check; produces "missing index" as before. Are you telling us that you have a sequence of command

[sqlite] index broken by insert

check on demographics.sqlite is OK. Thank you for your help, Roman

[sqlite] index broken by insert

s updated (not on insert). I presume that trigger should not be triggered. Not knowing what sqlite_autoindex_Exam_1 means, and seeing "Exam" I conclude the relationship between my subject() and Exam() tables might be relevant for the problem. Roman ___

[sqlite] index broken by insert

Yes, I can provide full schema and data set. As far as I remember this mailing list does not accept attachments. Would that be OK to send in body of email? It is not that big. Roman From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users

[sqlite] index broken by insert

aphics" VALUES('0029','1988-08-04','26','18','Male'); INSERT INTO "demographics" VALUES('0030','1967-12-13','47','16','Male'); INSERT INTO "demographics" VALUES('0031','1983-11-05','31','16','Male'); -- Offending statement: PRAGMA foreign_keys=ON; INSERT OR IGNORE INTO subject(subjectID, dob, gender) SELECT subjectID, dob, gender FROM demographics; PRAGMA integrity_check; -- Roman

[sqlite] index broken by insert

using 5 year old version of sqlite that we have on our system. How will i know the patch/new version is available? By checking ticket link? Thank you, Roman Sent from my T-Mobile 4G LTE Device Original message From: Richard Hipp <d...@sqlite.org> Date: 05/19/2015 3:37 P

[sqlite] index broken by insert

if CAST() modification that you propose should actually be the correct SQL code that I should adopt permanetly. We like implicit conversions, but as C++ is more strict than C with regard to casting, should it be my better practice to always explicitly cast? Thank you, Roman

Re: [sqlite] General R*Tree query

Since coordinate system is spherical, how do you tell that RA=23:59 and RA=00:01 are next to each other using usual comparisons? Roman From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Dan Kennedy [danielk1

Re: [sqlite] General R*Tree query

coordinates the metric could use some other coordinates? Roman Original message From: "Brian T. Carcich" <briantcarc...@gmail.com> Date: 12/18/2013 1:24 AM (GMT-05:00) To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Subject: Re: [sqlite

Re: [sqlite] Keeping Track of Records of IDs in one table. Possible?

to ProjID in OpenProjects. Multi-table solution is a bad one, even of SQLite can handle it (I think it can). Roman From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of jose isaias cabrera [cabr...@wrc.xerox.com] Sent: Wednesday

Re: [sqlite] INSERT several rows

OK, thank you, Igor! I presume there is no way to get documentation for older versions -- no point in keeping. Roman From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Igor Tandetnik [i...@tandetnik.org] Sent: Thursday

Re: [sqlite] INSERT several rows

of Richard Hipp [d...@sqlite.org] Sent: Thursday, April 03, 2014 5:03 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] INSERT several rows On Thu, Apr 3, 2014 at 4:52 PM, Roman Fleysher < roman.fleys...@einstein.yu.edu> wrote: > OK, thank you, Igor! I presume there is no w

[sqlite] isBad table bad design?

with empty tables which is an empty table? Is this a bad design and I should add a quality column: badMetric(examID, metric, reason, quality) What could be other solutions? Thank you, Roman ___ sqlite-users mailing list sqlite-users@sqlit

Re: [sqlite] isBad table bad design?

of SQLite Database Subject: Re: [sqlite] isBad table bad design? On Thu, Apr 3, 2014 at 6:32 PM, Roman Fleysher < roman.fleys...@einstein.yu.edu> wrote: > Dear SQLiters, > > Could some help if this is bad design or my lack of knowledge of SQL: > > I have a table that keeps

[sqlite] SQLite and GPFS

on several nodes accessing the same database. What about GPFS? As I read its description, it promises to flush and report correctly. Thank you, Roman ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] Sequential numbers

that generates the insert commands) is the one that should be assigning the sequence numbers. It is this code only that knows which goes first, especially if we are talking about multithreaded computation. ROWID is "order as inserted by SQLite" not "order as inserted by dispenser&qu

[sqlite] PRAGMA integrity_check

Dear SQLiters, PRAGMA integrity_check is described to check UNIQUE and NOT NULL constraints. Does it check other CHECK constraints specified in the column definition? Thank you, Roman

[sqlite] PRAGMA integrity_check

. Is that expected? Thank you, Roman From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at mailinglists.sqlite.org] on behalf of Simon Slavin [slav...@bigfraud.org] Sent: Thursday, September 10, 2015 6:39 PM To: General Discussion of SQLite

[sqlite] PRAGMA integrity_check

Thank you, Simon. Meanwhile, I tested if PRAGMA integrity_check checks column constraints. You can bump up 90% of being sure it does not to 100%. It does not. Is there a way to do it, other than export the data out and try to re-insert it? Roman From

[sqlite] PRAGMA integrity_check

OK, Thank you. Meanwhile (again) I check that PRAGMA integrity_check='yes' did not disable TEXT NOT NULL. Is that a bug in 3.8.8.3? Roman From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at mailinglists.sqlite.org] on behalf

[sqlite] bug in PRAGMA ignore_check_constraints?

) SELECT rowid FROM input; Error: NOT NULL constraint failed: subject.gender I am using SQLite 3.8.11.1. Am I misusing the PRAGMA? Thank you, Roman

[sqlite] PRAGMA integrity_check

Thank you Richard! Roman From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at mailinglists.sqlite.org] on behalf of Richard Hipp [d...@sqlite.org] Sent: Thursday, September 10, 2015 7:50 PM To: General Discussion of SQLite

[sqlite] bug in PRAGMA ignore_check_constraints?

I just downloaded and tested using 3.8.11.1. It and 3.8.8.3 have the same behavior -- do not disable. Roman From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at mailinglists.sqlite.org] on behalf of Richard Hipp [d

[sqlite] datetime in CHECK

IS datetime(AcquisitionDateTime)) when I insert '2015-08-10T17:19:37.670' or '2015-08-10 17:19:37.670' fails. Why? How to do it properly? Thank you, Roman

[sqlite] datetime in CHECK

Thank you. I did not notice loss of fractional seconds. I now see in the manual that datetime() is equivalent to strftime('%Y-%m-%d %H:%M:%S', ...), with capital "S" rather than lower "f" at the end that I expected. Roman From:

[sqlite] Podcast with Dr Hipp: SQLite history, success and funding

nfolding disruptive innovation. SQLite was and is a disruptive innovation. SQLite is not a toy. Thank you for making it. Roman From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at mailinglists.sqlite.org] on behalf of Simo

[sqlite] Beginning database question

I am new to database and SQLite too. I found this in archive. What if I would like GUI, where I would go? Thank you, Roman I assume when you say "discrete" you actually mean "bracketed" as there are lots more than 10 heights and weights. I don't know what Excel has to

[sqlite] sqlite shell: arrow keys

Dear SQLiters, I am new to SQLite and learning it (and SQL) using shell. It would make life easier if arrow keys on keyboard could be used to scroll through command history and along command for editing. Is there a way to enable this? Thank you, Roman

[sqlite] table with check

ot;, "Left" or nothing "", i.e. fail otherwise. But: INSERT INTO subject (subjectID,"qqq"); actually inserts qqq. Am I doing something wrong? I read manual that newer versions of sqlite should enforce CHECKs. Thank you, Roman _

Re: [sqlite] table with check

Thank you, both typeof(handedness)='null' and handedness is null work. I see the problem and agree. Roman From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Peter Aronson [pbaron...@att.net] Sent: Friday, May 17

[sqlite] autoincrement and primary key

ion when passing threshold --- it did not. I could replace INTEGER primary key by TEXT primary key and auto increment will go away. How can I keep integer? Thank you, Roman ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/

Re: [sqlite] autoincrement and primary key

Thank you, INTEGER -> INT solved the problem. According to manual, this will make search slower, but I give data integrity more weight for now. Roman From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Igor Tandetnik

Re: [sqlite] Serialize an in-memory database

for less than a month.) Roman From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Petite Abeille [petite.abei...@gmail.com] Sent: Wednesday, June 05, 2013 3:15 PM To: General Discussion of SQLite Database Subject: Re: [sqlite

Re: [sqlite] Feature request: add support for COMMENT statement

statements and script names to be called even if security is not an issue? Can someone recommend an ORM? What are the pros and cons of using them? If this list is inappropriate for such discussion, please also let me know and I will refrain. Thank you, Roman ___

Re: [sqlite] Is there a way to return the row number? (NOTthe rowid)

Bravo Alex !! From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Alex Bowden [a...@designlifecycle.com] Sent: Monday, July 01, 2013 12:34 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Is there a way

[sqlite] can column name come from a table?

columnName; Or this is not doable within SQL and I must execute internal select separately and have application compose second (external) select? Thank you, Roman ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listi

Re: [sqlite] can column name come from a table?

displaying the table. Thank you, Roman From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Igor Tandetnik [i...@tandetnik.org] Sent: Monday, July 29, 2013 8:48 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] can column

Re: [sqlite] BETWEEN and explicit collation assignment

on column. Using this analogy, I would write: select * from t WHERE x = y USING NOCASE Roman From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Igor Tandetnik [i...@tandetnik.org] Sent: Thursday, August 22, 2013 3:53

Re: [sqlite] BETWEEN and explicit collation assignment

s produce different results is complex even though I know how to decipher. I do not mind typing an extra word -- a modifier for comparison -- to make clear what I want to happen. I do not think this increases complexity. Complexity is sometimes equated to the lack of clarity. In fact, it is the c

Re: [sqlite] BETWEEN and explicit collation assignment

ase) insert into t values ('A'); select count(*) from t where x = 'a' nocase; Roman From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Igor Tandetnik [i...@tandetnik.org] Sent: Thursday, August 22, 2013 8:14 PM To: sqlite-use

Re: [sqlite] BETWEEN and explicit collation assignment

22, 2013 9:37 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] BETWEEN and explicit collation assignment On 8/22/2013 9:01 PM, Roman Fleysher wrote: >> create table t(x text collate nocase); >> insert into t values ('A'); >> select count(*) from t where x = 'a'; > >>

Re: [sqlite] BETWEEN and explicit collation assignment

requires specification which of the attributes of those underlying objects are relevant. Collation rule is such a specification, an algorithm that tells comparator how to compare two strings -- objects of the same type. Type alone is not enough, if we want all types to fit human heads. Roman

Re: [sqlite] BETWEEN and explicit collation assignment

these are their attributes. Therefore, I agree with Simon: it is the comparison ( "=", BETWEEN, IN , etc) statements that must be modified with a collation, not their operands. Roman ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqli

Re: [sqlite] Hints for the query planner

In Bayesian statistics there is a term "prior", prior probability. From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Richard Hipp [d...@sqlite.org] Sent: Tuesday, September 10, 2013 3:26 PM To: General Discussion of

Re: [sqlite] Using an sqlite db as a mutex?

What about doing this via NFS? I presume no guarantee? From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Dan Kennedy [danielk1...@gmail.com] Sent: Thursday, September 26, 2013 11:31 AM To: sqlite-users@sqlite.org

Re: [sqlite] replace "\n" with nothing

Thank you! Worked! Roman From: sqlite-users-boun...@mailinglists.sqlite.org [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of R Smith [rsm...@rsweb.co.za] Sent: Tuesday, July 05, 2016 3:13 PM To: sqlite-users@mailinglists.sqlite.org Subject: Re

[sqlite] replace "\n" with nothing

Dear SQLiters, I made a mistake and inserted a new line char, "\n" in the middle of a text. I now would like to replace it with nothing. Something like: replace(columnName, '\n','') But this will interpret "\n" literally, as two symbols. How do I do it

Re: [sqlite] 3.17.0 does not read updated DB

My mistake: I do not update DB. I rename (unix mv) the DB. Roman From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of Roman Fleysher [roman.fleys...@einstein.yu.edu] Sent: Thursday, February 16, 2017 12:33 AM To: General

[sqlite] 3.17.0 does not read updated DB

using sqlite3 version 3.8.11 (also command shell). I seem to be able to replicate that. Roman ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite binary with Math Functions for OS-X?

Can't you count how many rows there are and then sort by the variable of interest, limiting output to half the count, all within SQL? Roman Sent from my T-Mobile 4G LTE Device Original message From: Ronald Gombach <ron...@gombach.com> Date: 11/21/16 7:12 AM (GMT

Re: [sqlite] extension to run bash

for analysis. Thank you, Roman From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of Richard Hipp [d...@sqlite.org] Sent: Wednesday, January 11, 2017 4:44 PM To: SQLite mailing list Subject: Re: [sqlite] extension to run bash

[sqlite] extension to run bash

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

Re: [sqlite] extension to run bash

Yes, Richard, this is exactly what I mean. Roman From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of Richard Hipp [d...@sqlite.org] Sent: Wednesday, January 11, 2017 4:34 PM To: SQLite mailing list Subject: Re: [sqlite

Re: [sqlite] extension to run bash

to sqlite. Or From sqlite, use extension to run commands for each row. Both have issues. Roman Original message From: Richard Hipp <d...@sqlite.org> Date: 1/11/17 7:23 PM (GMT-05:00) To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject:

Re: [sqlite] Developing a SQLite3 DB remotely

SQLite access is. GFS2 and GPFS supposedly solve file synchronization issue (by sharing disk inodes rather than files ). I never tested this (we have GPFS) and do not know about other file systems. Roman From: sqlite-users [sqlite-users-boun

Re: [sqlite] Developing a SQLite3 DB remotely

No. I was not aware of these tools. Are any of them good? Maintained? I am mostly using sqlite3 shell from bash scripts. Do you know if some of them are suitable replacements? Is this off the topic of the original question? Thank you, Roman From

[sqlite] command shell .timeout

et timeouts to avoid this. (By the way, PRAGMA busy_timeout = milliseconds; prints new timeout to screen. I would expect printing only if new value is not provided.) Thank you Roman ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mai

Re: [sqlite] command shell .timeout

Thank you, Richard. Roman From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of Richard Hipp [d...@sqlite.org] Sent: Thursday, August 03, 2017 3:38 PM To: SQLite mailing list Subject: Re: [sqlite] command shell .timeout On 8/3

[sqlite] transfer records with foreign key

to use INSTEAD OF trigger. Is that the right way? Or I have to create a temp table that maps old linkID to new linkID, somehow. Roman ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman

Re: [sqlite] Syntax Restrictions On UPDATE, DELETE, and INSERT Statements Within Triggers

. A TEMP trigger is allowed to query or modify any table in any ATTACH-ed database. I need to be able to specify db2.t in the body of the trigger. But this is not allowed, right? Then how could it work? I mean it does not. Should it work? Roman From

Re: [sqlite] rowid as foreign key

I am sorry, I did not ask the question correctly. I omitted "... link two tables, using foreign key...". I now see last sentence on http://sqlite.org/lang_createtable.html which states that it is not possible. Roman From: sqlite-users [sq

[sqlite] rowid as foreign key

Dear SQLiters, Is it possible to link two tables using rowid, the implicit column? I tried and it did not work, so I presume the answer to my question is "no". Thank you, Roman ___ sqlite-users mailing list sqlite-users@mailinglists.sqlit

Re: [sqlite] rowid as foreign key

link them. Perhaps I will use ALTER TABLE mechanism. Roman From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of Keith Medcalf [kmedc...@dessus.com] Sent: Monday, July 24, 2017 6:58 PM To: SQLite mailing list Subject: Re: [sql

[sqlite] WITH inside trigger in 3.16.2

on 3.16.22. Thank you, Roman ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] WITH inside trigger in 3.16.2

My apology, I can not read. http://sqlite.org/lang_createtrigger.html clearly states that CTE is not supported in triggers. Roman From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of Roman Fleysher [roman.fleys

Re: [sqlite] SAVEPOINT with multiple databases

Thank you, David. Now it totally makes sense to me. I realize this is SQL not SQLite question. Thank you, Roman From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of David Raymond [david.raym...@tomtom.com] Sent: Wednesday

Re: [sqlite] SAVEPOINT with multiple databases

Oh, now i understand. Thank you, Simon. Roman Original message From: Simon Slavin <slav...@bigfraud.org> Date: 5/16/17 5:35 PM (GMT-05:00) To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] SAVEPOINT with multiple databases

[sqlite] SAVEPOINT with multiple databases

on the transaction stack as any other, INSERT/UPDATE/DELETE? Thank you, Roman ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] PRAGMA optimize; == no busy handler?

Dear SQLiters, Vacuuming seems to belong to a different thread, but let me say that it is not always warranted. Vacuuming may change/reassign ROWIDs. If you have two databases (backup and production?) that used to be linked via such a key, it will break. Roman

Re: [sqlite] XOR operator

pes, but each value still has a type. And this is a very very big advantage of SQLite. Perhaps longer term is "flexibly strongly typed". Perhaps because "typed" implies "strongly" (what is a weak type?), strongly is redundant. Roman Original message

Re: [sqlite] Energy consumption of SQLite queries

) and because of the experience you gained by conclusion of the project, I am rather certain you will be able to obtain additional funding to continue and refine the answer to the newer version of SQLite available then. The future is in your hands! Roman

Re: [sqlite] probably recursive?

condition that if x is removed from one list, it must be removed from the other. This is easy to add for ones who understand how it works. Roman From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of E.Pasma [pasm...@concepts.nl] Sent

Re: [sqlite] 3.24 draft - upsert

Why does SQLite have to follow what PostgreSQL does? I thought SQLite is the leader. Roman Sent from my T-Mobile 4G LTE Device Original message From: Richard Hipp <d...@sqlite.org> Date: 5/9/18 5:48 AM (GMT-05:00) To: SQLite mailing list <sql

[sqlite] clocks in SQLite

(at 16:44:11). Time of start of 2283 looks correct, agrees with my watch, because I started this job manually. Roman ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] clocks in SQLite

Thank you for pointing the 24 hours. I did not notice the day change. Now, I have no idea how this can happen. I will investigate more. Roman From: Graham Holden [sql...@aldurslair.com] Sent: Tuesday, May 15, 2018 3:39 PM To: Roman Fleysher Cc: General

[sqlite] sqlite3AtoF Handling of high numbers

there is a value with the exact same value inside the database ( executed with the sqlite c++ api without usage of prepared parameters) Kind regards Roman Stiefsohn ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org

Re: [sqlite] probably recursive?

pots either because the points were never on the list or were eliminated. Roman From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of Barry Smith [smith.bar...@gmail.com] Sent: Tuesday, May 01, 2018 6:12 PM To: SQLite mailing list

Re: [sqlite] probably recursive?

Pairs (x,y) do not repeat. Actual x and y are positive integers, but I do not see how being positive can be relevant. Integer is important for sorting/comparison. Roman From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf

Re: [sqlite] probably recursive?

-05:00) To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] probably recursive? Ah my bad, I misunderstood the initial condition. nX is a function of X. My statements were only true if nX=X. Well, sorry about the noise. > On 2 May 2018, at 8:20 am,

[sqlite] probably recursive?

, number of dots on all vertical lines must be more than nX and number of dots on all horizontal lines must be more than nY. Could this be achieved with SQLite? Roman ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

Re: [sqlite] probably recursive?

) GROUP BY x HAVING count(x) < 25) ) SELECT x, y FROM deleteList; Roman From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of David Raymond [david.raym...@tomtom.com] Sent: Tuesday, May 01, 2018 10:27

  1   2   >