Re: [sqlite] New word to replace "serverless"

Dear Richard and SQLiters, I would like to ask, why is it so important to indicate that SQLite, in reference to threads or client/server, " does not work that way". I think this might help to find the words to describe it. Is it because some embedded systems do not support threads? Is it

Re: [sqlite] New word to replace "serverless"

Perhaps "server" is not the right emphasis? Maybe it is the client? Thus, "clientless"? This means that each SQlite session serves itself. Self-sufficient. Roman From: sqlite-users on behalf of Richard Hipp Sent: Monday, January 27, 2020 5:18 PM To: General

Re: [sqlite] Test failures on GPFS

I use SQLite over GPFS , but in DELETE (which I think is the default) mode. Not WAL mode. No issues with locking, except performance when accessing concurrently from multiple nodes. As others pointed out, this has to do with the overhead due to lock requests. GPFS must coordinate with many

Re: [sqlite] [EXTERNAL] Re: what is the optimized way to do the vaccum?

A side note about VACUUM: If I remember correctly, tables which do not have INTEGER PRIMARY KEY will have their rowid column reassigned. Be careful if you are using rowid. Roman From: sqlite-users on behalf of Simon Slavin Sent: Thursday, December 5, 2019

Re: [sqlite] database is empty but intact

e is empty but intact On 8 Nov 2019, at 12:03am, Roman Fleysher wrote: > I am using command line sqlite3 with -vfs unix-none. This disables locking > within SQLite. Instead, locking is provided externally by FLoM (distributed > file lock manager). I asked questions in a thread &q

[sqlite] database is empty but intact

Dear SQLiters, I am using command line sqlite3 with -vfs unix-none. This disables locking within SQLite. Instead, locking is provided externally by FLoM (distributed file lock manager). I asked questions in a thread "disable file locking mechanism over the network". It is possible that FLoM

Re: [sqlite] Network file system that support sqlite3 well

I was raising/discussing similar question. Look through SQLite archive for : disable file locking mechanism over the network Client/server manager for SQLite is not enough. Internally, Sqlite will still request lock from the file system and the overhead will still be there. Once the

Re: [sqlite] Network file system that support sqlite3 well

Transaction delays apply to read as well. SQLite places a lock while reading too, to ensure the database is intact during read. Otherwise tables will half half complete rows. Read "begin transaction", difference between immediate and exclusive transactions. Roman Sent from my T-Mobile 4G

Re: [sqlite] Network file system that support sqlite3 well

I know for sure that IBM's GPFS guarantees locking. I think GPFS is "global parallel file system". It is a distributed file system. But it will be rather slow. If only few jobs run in parallel, all will be ok. Locking will always guarantee database integrity. With lots of jobs, you will see

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)

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] Date time input

I had to deal with a similar conversion. I think the answer to why date() does not take other formats is simple: SQLite is minimalistic. This string processing can be done outside SQLite library. Minimalism of SQLite is one of the criteria for what gets implemented. It has few mathematical

Re: [sqlite] Copy-on-write VFS

Maybe this for this scenario: You have in-memory database, used mostly for reading and you want to save its copy to disk when update on in-memory is performed? Otherwise, what is copied and what is to write in "copy on write"? From: sqlite-users

Re: [sqlite] disable file locking mechanism over the network

Medcalf [kmedc...@dessus.com] Sent: Saturday, September 28, 2019 12:48 AM To: SQLite mailing list Subject: Re: [sqlite] disable file locking mechanism over the network On Friday, 27 September, 2019 22:11, Roman Fleysher wrote: >Based on the link you provide, it looks like I need unix-none

Re: [sqlite] disable file locking mechanism over the network

ta=02%7C01%7Croman.fleysher%40einstein.yu.edu%7C07b8076c03944d262b0808d743c6f9a6%7C04c70eb48f2648079934e02e89266ad0%7C1%7C1%7C637052394192099402sdata=Jkew%2B%2FZJkF2GZbtfYYtHfbFsXJiv%2FMUHfwveVXYdvxI%3Dreserved=0 >-Original Message- >From: sqlite-users On >Behalf Of Roman Fleysher >Sent

Re: [sqlite] disable file locking mechanism over the network

Subject: Re: [sqlite] disable file locking mechanism over the network On Friday, 27 September, 2019 17:00, Roman Fleysher wrote: >I am using SQLite over GPFS distributed file system. I was told it >honestly implements file locking. I never experienced corruption. But it >is slow in the sense

Re: [sqlite] disable file locking mechanism over the network

27, 2019 7:53 PM To: SQLite mailing list Subject: Re: [sqlite] disable file locking mechanism over the network On 27 Sep 2019, at 11:59pm, Roman Fleysher wrote: > From experience, it seems that because SQLite still requests file locks, the > performance increase is not that big. I

[sqlite] disable file locking mechanism over the network

( somewhat related to Re: [sqlite] Safe to use SQLite over a sketchy network?) Dear SQLiters, I am using SQLite over GPFS distributed file system. I was told it honestly implements file locking. I never experienced corruption. But it is slow in the sense that when many jobs from many compute

Re: [sqlite] Is this a bug?

WHERE CAST(10 * cosSquared AS INT) = 9 On Tue, 18 Jun 2019 at 16:44, Roman Fleysher wrote: > Dear SQLiters, > > > I can not figure out what I am doing wrong. In testing, I simplified to > the following: > > CREATE TABLE cosSquared(refVolume INT, vecVolume INT, cosSquared REAL);

[sqlite] Is this a bug?

Dear SQLiters, I can not figure out what I am doing wrong. In testing, I simplified to the following: CREATE TABLE cosSquared(refVolume INT, vecVolume INT, cosSquared REAL); SELECT refVolume, CAST(10*max(cosSquared) AS INT) FROM cosSquared GROUP BY refVolume; refVolume

Re: [sqlite] select within transaction

:22 AM, Roman Fleysher wrote: > I have a transaction consisting of two commands: update and select. The idea > is to get new state after update: > > PRAGMA busy_timeout = 50; > BEGIN EXCLUSIVE; > UPDATE OR ROLLBACK t SET c = 5 WHERE ...; > SELECT d FROM t WHERE c

Re: [sqlite] select within transaction

and then when the CLI closes it will rollback the uncommitted transaction. -Original Message- From: sqlite-users On Behalf Of Roman Fleysher Sent: Friday, June 14, 2019 2:23 PM To: General Discussion of SQLite Database Subject: [sqlite] select within transaction Dear SQLiters, I a

[sqlite] select within transaction

Dear SQLiters, I am using sqlite3 shell. I have a transaction consisting of two commands: update and select. The idea is to get new state after update: PRAGMA busy_timeout = 50; BEGIN EXCLUSIVE; UPDATE OR ROLLBACK t SET c = 5 WHERE ...; SELECT d FROM t WHERE c = 5 AND ...; COMMIT; Is this

Re: [sqlite] add constant to INTEGER PRIMARY KEY

pated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Roman Fleysher >Sent: Thursday, 13 December, 2018 15:39 >To: General Discussion of SQLite Database >Subject: [sqlite] add constant to INTEGER PR

[sqlite] add constant to INTEGER PRIMARY KEY

Dear SQLiters, I would like to update a column declared as INTEGER PRIMARY KEY. This column is parent to a column of another table: table1 ( t INTEGER PRIMARY KEY NOT NULL); table2 (t INTEGER PRIMARY KEY NOT NULL REFERENCES table1(t) ON DELETE CASCADE ON UPDATE CASCADE); I keep PRAGMA

Re: [sqlite] Grouping guidance

Hypothesis can never be proven. It can only be rejected with data contradicting it at hand. "..the quickest way ..." implies someone else corrects you. From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of Don V Nielsen

Re: [sqlite] nested foreign keys

--- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Roman Fleysher >Sent: Wednesday, 24 October, 2018

Re: [sqlite] nested foreign keys

are you doing and what error are you seeing? - David On Wed, Oct 24, 2018 at 11:30 PM Roman Fleysher < roman.fleys...@einstein.yu.edu> wrote: > Dear SQLiters, > > I am trying to set up what I would call "nested foreign keys": > > create grandParent (id PRIMARY KE

[sqlite] nested foreign keys

Dear SQLIters, I am trying to set up what I would call "nested foreign keys": create grandParent( id PRIMARY KEY) create parent (id PRIMARY KEY REFERENCES grandParent(id)) ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] nested foreign keys

Dear SQLiters, I am trying to set up what I would call "nested foreign keys": create grandParent (id PRIMARY KEY ) create parent (id PRIMARY KEY REFERENCES grandParent(id)) create child (id PRIMARY KEY REFERENCES parent(id)) SQLite complains. Does it mean that grand children are not allowed?

[sqlite] INSERT OR REPLACE and foreign keys

Dear SQLiters, I am using INSERT OR REPLACE to update a table which holds a column which servers as a foreign key. But I noticed a strange behavior: If the parent record existed, then replace mechanism replaces it, but the records from children tables are deleted. The foreign key is set up to

Re: [sqlite] Find key,value duplicates but with differing values

but with differing values On 2018/10/11 9:53 PM, Roman Fleysher wrote: > It is hard for me to tell which is index, which is value and so forth in your > example, but how about this single select: > > SELECT DISTINCT key, value FROM theTable; > > This lists all distinct key-v

Re: [sqlite] Find key,value duplicates but with differing values

It is hard for me to tell which is index, which is value and so forth in your example, but how about this single select: SELECT DISTINCT key, value FROM theTable; This lists all distinct key-value possibilities. Or, SELECT key, value FROM (SELECT DISTINCT key, value FROM theTable) GROUP BY

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] clocks in SQLite

Dear SQLIters, I use datetime('now') to record when a job gets started and stopped. As soon as a job stops, new is started. Thus stop of the previous should be within a second of the start of the next, as you see in the first few lines. But then the clock jumps. Job 1847 ends at 16:44:11 and

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 Date: 5/9/18 5:48 AM (GMT-05:00) To: SQLite mailing list

Re: [sqlite] probably recursive?

Thank you Cezary and others who commented. For some reason, I did not receive email from Cezary, only comments on it. I was under impression that RECURSIVE can not be used in sub-query. I see that it can. But, most importantly, could you elaborate more on how it works. I agree it is n-to-n

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,

Re: [sqlite] probably recursive?

to me, but it should be easier because you only need to find a single number (which you can then plug into a delete statement). If my statement about the square is not obvious to prove in your head I can try write a proof for that but I'm not much good at proofs. > On 2 May 2018, at 7:27 am, Roma

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 of

Re: [sqlite] probably recursive?

2018, at 5:34pm, Roman Fleysher <roman.fleys...@einstein.yu.edu> wrote: > With recursive route, I am thinking I need to build deleteList(x,y). Rather than actually delete rows, if you can, insert a new column in the table of all points. It starts with every row set to TRUE. When you dec

Re: [sqlite] probably recursive?

ty sets - but this would be painfully slow next to a simple software algorithm that prunes/resolves a 2-dimensional array - exponentially worse so for larger grid sizes. On 2018/05/01 2:45 AM, Roman Fleysher wrote: > Dear SQLiters, > > I have trouble solving this problem, maybe it is impo

[sqlite] probably recursive?

Dear SQLiters, I have trouble solving this problem, maybe it is impossible? I have a table with two columns x and y, both integers. Imagine they are coordinates on X-Y plane, dots. I need to find all x's that have more than nX dots, and all y's that have more than nY dots. Both conditions must

Re: [sqlite] exit status of command shell

rror: near line 1: no such table: sqlite_monster 1 Piped SQL lacking a trailing semicolon does indeed cause the shell to report the wrong last command status. Peter On Wed, Apr 4, 2018 at 4:46 PM, Roman Fleysher < roman.fleys...@einstein.yu.edu> wrote: > Dear SQLiters, > > > I

[sqlite] exit status of command shell

Dear SQLiters, I am using sqlite3 shell from bash scripts and I stumbled on what I think is incorrect exit code on error. In the first scenario, on error the exit code is 1 -- expected, in the second it is 0 -- unexpected. The error message is the same in both. Is that normal? echo -e "ww;

Re: [sqlite] primary key in another column

sqlite] primary key in another column On 1/26/2018 6:20 PM, Roman Fleysher wrote: > I think I effectively did as you suggested using triggers. I insert NULL into > the ID column to create a row. This triggers the trigger to run update on the > table to populate the columns based on the

Re: [sqlite] primary key in another column

that don't need such a view, create a simple pass through view). On 1/26/18 6:30 PM, Roman Fleysher wrote: > No, I can not compute inside forEachRow. ForEachRow is now universal, can be > applied to any table. If I modify SELECT inside it to fit specific purpose, > forEachRow will use uni

Re: [sqlite] primary key in another column

it in the select query that is getting the data? On 1/26/18 6:03 PM, Roman Fleysher wrote: > My implementation of "for Each row" requires all columns to be populated. It > is a dumb thing: > > forEachRow commandToBeExecuted itsArgumentsWhichReferToColumns > > The files are ima

Re: [sqlite] primary key in another column

From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of Igor Tandetnik [i...@tandetnik.org] Sent: Friday, January 26, 2018 6:10 PM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] primary key in another column On 1/26/2018 6:03 PM, Roman Fleysher wrote: >

Re: [sqlite] primary key in another column

f Igor Tandetnik [i...@tandetnik.org] Sent: Friday, January 26, 2018 5:56 PM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] primary key in another column On 1/26/2018 5:47 PM, Roman Fleysher wrote: > I will use this table as a manager. There will be multiple columns holding > various

Re: [sqlite] primary key in another column

qlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of Igor Tandetnik [i...@tandetnik.org] Sent: Friday, January 26, 2018 5:33 PM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] primary key in another column On 1/26/2018 4:43 PM, Roman Fleysher wrote: > I would like to use prim

Re: [sqlite] primary key in another column

); ... Is that a right solution? Roman From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of Roman Fleysher [roman.fleys...@einstein.yu.edu] Sent: Friday, January 26, 2018 4:43 PM To: General Discussion of SQLite Database Subject: [sqlite

[sqlite] primary key in another column

Dear SQLiters, I would like to use primary key as a way to create unique column entry: CREATE TABLE A( id INTEGER PRIMARY KEY, fileName TEXT NOT NULL) such that file name is always prefix followed by the ID for the content to be: ID fileName 1 prefix_1 2 prefix_2 That is when I

Re: [sqlite] Energy consumption of SQLite queries

Dear Ali, A couple of comments. Indeed lots of energy is transferred into heat, but not all. Therefore, using temperature (after calibrating specific heat coefficient of the device ) is not a good method. Some energy is radiated as visible and invisible light and hard to catch it all. Some as

Re: [sqlite] XOR operator

The point is that terminology is chosen for a reason and can not be dismissed. "Flexibly typed" means it is typed. It means SQLite knows how many bytes: without knowing it would not be able to establish equality "IS". Flexibly means columns can contain values of mixed types, but each value

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] Syntax Restrictions On UPDATE, DELETE, and INSERT Statements Within Triggers

Dear Richard, Dear SQLiters, This is not clear to me as well. If I have two databases, db1 and db2. Both have table t. db1.t and bd2.t. I want to create a TEMPORARY trigger that upon insert in db1.t does something with db2.t. Because: TEMP triggers are not subject to the same-database rule.

[sqlite] transfer records with foreign key

Dear SQLiters, I have two tables linked by a foreign key, linkID. I need to transfer content of these two tables into two corresponding tables in another database preserving the link. However, the second database already has records and numeric value of linkID can not be preserved. Nor its

Re: [sqlite] command shell .timeout

/17, Roman Fleysher <roman.fleys...@einstein.yu.edu> wrote: > Dear SQLiters, > > I am using sqlit3 command shell. It has ".timeout" command. What is the > difference between: > > .timeout MS > PRAGMA busy_timeout = milliseconds; They accomplish the same thing.

[sqlite] command shell .timeout

Dear SQLiters, I am using sqlit3 command shell. It has ".timeout" command. What is the difference between: .timeout MS PRAGMA busy_timeout = milliseconds; I am getting "database is locked" when accessing the same file from multiple concurrent shells and trying to set timeouts to avoid this.

Re: [sqlite] rowid as foreign key

dump/load operations. --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Roman Fleysher >Sent: Monday, 24 July, 20

Re: [sqlite] rowid as foreign key

lite-users-boun...@mailinglists.sqlite.org] on behalf of Gwendal Roué [gwendal.r...@gmail.com] Sent: Monday, July 24, 2017 3:17 PM To: SQLite mailing list Subject: Re: [sqlite] rowid as foreign key > Le 24 juil. 2017 à 20:58, Roman Fleysher <roman.fleys...@einstein.yu.edu> a > écr

[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.sqlite.org

Re: [sqlite] SAVEPOINT with multiple databases

commit/rollback, or savepoint release/rollback will never leave you with a different set of attached databases than before that statement. -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Roman Fleysher Sent: Wednesday, May 17

Re: [sqlite] SAVEPOINT with multiple databases

On 16 May 2017, at 10:09pm, Roman Fleysher <roman.fleys...@einstein.yu.edu> wrote: > I think I came to a point where I need to learn SAVEPOINTs. > > I am trying to understand documentation if creation and release of save > points covers all presently attached databases, that

[sqlite] SAVEPOINT with multiple databases

Dear SQLiters, I think I came to a point where I need to learn SAVEPOINTs. I am trying to understand documentation if creation and release of save points covers all presently attached databases, that is those before save point is created? Is attaching a database just a command that will sit on

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

[sqlite] WITH inside trigger in 3.16.2

Dear SQLiters, I am trying to create a trigger with body: WITH ... DELETE FROM ... and it does not seem to work (Error: near "DELETE": syntax error). But I can execute the body itself without errors. Does it mean that WITH clause is not supported within trigger? I use SQLite version 3.16.22.

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:

Re: [sqlite] Developing a SQLite3 DB remotely

I do not have big experience in the area, but have some. I think that light weight use is not the right thing to ask. I have seen NFS delays of 20 seconds: file was created on one machine and showed up on another after 20 seconds. This depends on how heavy OTHER things are, not how heavy

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

Dear SQLiters, Is it possible that sqlite3 version 3.17.0 (command shell) does not pick up updated content of a DB file? I updated DB while it was attached in sqlite3 and SELECT did not produce new results. Instead it printed the same output as before DB file was updated. Update was performed

Re: [sqlite] extension to run bash

I am not even sure myself this is the right path. I have table with file names and need operations to be performed on columns (i.e. on files). Results, numeric or new file names, are to be recorded in a column. I see two ways: From bash script, make list of rows, run commands, load results

Re: [sqlite] extension to run bash

On 1/11/17, Roman Fleysher <roman.fleys...@einstein.yu.edu> wrote: > Yes, Richard, this is exactly what I mean. > Then maybe use the https://www.sqlite.org/src/file/ext/misc/rot13.c extension as a prototype from which to develop yours. -- D. Richard Hipp d..

Re: [sqlite] extension to run bash

] extension to run bash On 1/11/17, Roman Fleysher <roman.fleys...@einstein.yu.edu> wrote: > Dear SQLites, > > I am using exclusively sqlite3 shell for all the processing and may need > ability to run bash commands and assign result to a column. For example: > > UPDATE result SET

[sqlite] extension to run bash

Dear SQLites, I am using exclusively sqlite3 shell for all the processing and may need ability to run bash commands and assign result to a column. For example: UPDATE result SET nRows =` wc -l fileNames` ; Here I used `` as would be in bash for command substitution. This would run wc command

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 Date: 11/21/16 7:12 AM (GMT-05:00) To:

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

: [sqlite] replace "\n" with nothing replace(columname, char(10), ''); Sometimes, depending on your OS's interpretation of '\n', it might actually be char(13)+char(10) or such (that's hex 0x0D and 0x0A). Get the HEX() from such a line to be sure. On 2016/07/05 9:00 PM, Roman Fley

[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? Thank you, Roman

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

Dear Richard, Dear SQLiters, Thank you, Simon, for sending the link. I would like to offer several comments on the podcast. 1. Why SQLite is popular. Instead of describing how I selected SQLite to solve our DB needs, I will recount story of Sony, its introduction of transistor radio that I

[sqlite] datetime in CHECK

sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at mailinglists.sqlite.org] on behalf of Cecil Westerhof [cldwester...@gmail.com] Sent: Wednesday, May 04, 2016 5:37 PM To: SQLite mailing list Subject: Re: [sqlite] datetime in CHECK 2016-05-04 22:43 GMT+02:00 Roman Fleysher : &g

[sqlite] datetime in CHECK

Dear SQLiters, I am trying to use CHECK constraint is column of a table to enforce datetime format and this works: AcquisitionDateTEXT CHECK (AcquisitionDate IS date(AcquisitionDate)) when I insert '2015-08-10'. But this AcquisitionDateTime TEXT CHECK (AcquisitionDateTime IS

[sqlite] bug in PRAGMA ignore_check_constraints?

...@sqlite.org] Sent: Thursday, September 10, 2015 7:53 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] bug in PRAGMA ignore_check_constraints? On 9/10/15, Richard Hipp wrote: > On 9/10/15, Roman Fleysher wrote: >> Dear SQLiters, >> >> I am trying to temporarily dis

[sqlite] PRAGMA integrity_check

Database Subject: Re: [sqlite] PRAGMA integrity_check On 9/10/15, Roman Fleysher wrote: > 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? > Apparently it do

[sqlite] bug in PRAGMA ignore_check_constraints?

Dear SQLiters, I am trying to temporarily disable CHECK constraint given in columns of table definition. As far as I understand, PRAGMA ignore_check_constraints='yes'; should do it. However this example demonstrates that it is not: CREATE TABLE subject( subjectID INT, gender TEXT

[sqlite] PRAGMA integrity_check

of Simon Slavin [slav...@bigfraud.org] Sent: Thursday, September 10, 2015 7:35 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] PRAGMA integrity_check On 11 Sep 2015, at 12:32am, Roman Fleysher wrote: > Meanwhile, I tested if PRAGMA integrity_check checks column constrai

[sqlite] PRAGMA integrity_check

:04am, Roman Fleysher wrote: > I wanted to check the behavior and set up a test database. I use (for now) > SQLite 3.8.8.3 and discovered that setting ignore_check_constraints = 'yes' > did not disable INT PRIMARY KEY NOT NULL constraint on a column. Is that > expected? Yeah. Tha

[sqlite] PRAGMA integrity_check

Database Subject: Re: [sqlite] PRAGMA integrity_check On 10 Sep 2015, at 11:06pm, Roman Fleysher wrote: > PRAGMA integrity_check is described to check UNIQUE and NOT NULL constraints. > Does it check other CHECK constraints specified in the column definition? I'm 90% sure it does not

[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] Thanks SQLite

I dare to add my thanks here, with a much simpler example. Initially, for me, CTE was another thing to learn. Then I wanted SQLite to compute statistics on a simple two-column table. Not a big deal, I typed the equation and was done. Next day, I needed the same equation to be applied to

[sqlite] how to cite SQLite

rs-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 2:27 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] how to cite SQLite On 7/13/15, Simon Slavin wrote: > > On 13 Jul 2015, at 4:51pm

[sqlite] how to cite SQLite

Discussion of SQLite Database Subject: Re: [sqlite] how to cite SQLite On 7/13/15, Roman Fleysher wrote: > Dear SQLiters, > > I am writing a scientific paper to describe our research. To manage data, we > use SQLite. I would like to acknowledge SQLite and cite it properly in

[sqlite] how to cite SQLite

Dear SQLiters, I am writing a scientific paper to describe our research. To manage data, we use SQLite. I would like to acknowledge SQLite and cite it properly in the paper. Is there a suggested way of doing it? A conference presentation? A paper, a book? In the simplest form I will use URL.

[sqlite] index broken by insert

From: Roman Fleysher Sent: Tuesday, May 19, 2015 3:48 PM To: General Discussion of SQLite Database Subject: RE: [sqlite] index broken by insert Dear Richard, Dear Simon, Dear SQLiters, It is such a pleasure to deal with smart people. Pure joy. How quickly Simon figured out the problem

[sqlite] index broken by insert

M (GMT-05:00) To: General Discussion of SQLite Database Subject: Re: [sqlite] index broken by insert On 5/19/15, Roman Fleysher wrote: > CREATE TRIGGER demographicInsert AFTER INSERT ON subject FOR EACH ROW BEGIN > INSERT INTO Exam (subjectID, examID, examType) VALUES (NEW.subjectID, >

[sqlite] index broken by insert

-- Dear SQLiters, -- Here is schema first, table is below, -- followed by offending statement. -- you can copy and paste the entire body -- my comments are SQL compatible - -- STEP 1 -- -- create gender and handedness tables to fix possible values -- then

[sqlite] index broken by insert

-bounces at mailinglists.sqlite.org] on behalf of Igor Korot [ikoro...@gmail.com] Sent: Tuesday, May 19, 2015 1:35 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] index broken by insert Hi, Roman, On Tue, May 19, 2015 at 1:23 PM, Roman Fleysher wrote: > "Confirmation&q

[sqlite] index broken by insert

_ From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at mailinglists.sqlite.org] on behalf of Roman Fleysher [roman.fleys...@einstein.yu.edu] Sent: Tuesday, May 19, 2015 12:25 PM To: General Discussion of SQLite Database Subject: [sqlite] index broken by insert Dear SQLiters, I

[sqlite] index broken by insert

Dear SQLiters, I do not really know what info to provide for sufficient information. I use SQLite shell only for all create/insert manipulations. This insert below causes PRAGMA integrity_check; to report missing index (what appears to be on every inserted row): SQLite version 3.8.8.3

[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

  1   2   >