[sqlite] sqlite3AtoF()

Hello, Could you consider an exponentiation by squaring (in the main release) instead of current n-multiplication of exponents? I've observed that an average time spent in sqlite3AtoF() is greatly reduced by 12% to over 30%, depending on an exponent's magnitude and a compiler. It is nothing more

Re: [sqlite] How to prevent the insertion of cycles into a hierarchical table?

Thanks for the wonderfully simple and concise solution. I see now triggers do support CTEs if they SELECT a RAISE() function. I never thought of using a BEFORE trigger. Fijne kerstdagen On 24 December 2017 at 17:17, E.Pasma wrote: > On 24/12/2017 11:56, Shane Dev wrote: >

Re: [sqlite] TRIM Function in Python3's sqlite3 import

David - thanks for the pointer to when TRIM showed up. Python is 10 years out of date!! Wow!! Upgrade was not super difficult, I kind of figured it out with a lot of searching for answers. Searching about upgrades, I found this listing:

Re: [sqlite] Suspected bug: parse error depending on platform

Finally unlike with Ubuntu, for Windows, there is not even a need to build the library, it’s already available from https://sqlite.org/download.html -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users mailing list

Re: [sqlite] How to prevent the insertion of cycles into a hierarchical table?

On 24/12/2017 11:56, Shane Dev wrote: Related to my previous question https://www.mail-archive.com/sqlite-users@mailinglists.sqlit e.org/msg107527.html, I want to prevent the client from inserting a cycle. For example - sqlite> .sch edges CREATE TABLE edges(parent integer not null, child

Re: [sqlite] How to prevent the insertion of cycles into a hierarchical table?

make child a unique key. so each node can only have 1 parent. On Sun, Dec 24, 2017 at 6:44 AM, Lifepillar wrote: > On 24/12/2017 11:56, Shane Dev wrote: > >> Related to my previous question >> https://www.mail-archive.com/sqlite-users@mailinglists.sqlit >>

Re: [sqlite] How to prevent the insertion of cycles into a hierarchical table?

On 24/12/2017 11:56, Shane Dev wrote: Related to my previous question https://www.mail-archive.com/sqlite-users@mailinglists.sqlite.org/msg107527.html, I want to prevent the client from inserting a cycle. For example - sqlite> .sch edges CREATE TABLE edges(parent integer not null, child

[sqlite] How to prevent the insertion of cycles into a hierarchical table?

Related to my previous question https://www.mail-archive.com/sqlite-users@mailinglists.sqlite.org/msg107527.html, I want to prevent the client from inserting a cycle. For example - sqlite> .sch edges CREATE TABLE edges(parent integer not null, child integer not null, constraint self_reference

Re: [sqlite] Modify the sqlite database with DB Browser to update a new field

I would suspect this is "DB Browser for SQLite" application. It has an 'execute SQL' tab, so the raw code can be directly entered, or the table modified through a gui. It's pretty straightforward to use, and had a wiki on its support pages. This isn't the place to guide you though, but it has a