[sqlite] Katai based SQLite file format readers

SQLite file format [1] as executable description in Katai Struct YAML [2] (contribution of Mr. Mikhail Yakshin [3]). Katai seems as a very good library in the hot field of the declarative binary formats manipulation. King Regards, Alek [1] https://sqlite.org/fileformat.html

Re: [sqlite] Excel Pivot Table

Forgot to mention the most important feature of spreadsheet datasources: Once you linked your e.g. pivot to a datasource, you always can refresh it (usually Ritgh Click/Refresh), after a DB data change. Kind Regards, Alek ___ sqlite-users mailing list

Re: [sqlite] Excel Pivot Table

Hi Dennis, On 2019-10-17 02:11, Harris, Dennis wrote: I sure this has been asked a 100 times but what is the best practice to get data from SQLITE to Excel? I would like to have a pivot table that updates upon open. Excel and it's leading open source alternative - LibreOffice Calc, both

[sqlite] [OT] DVCS/Data (was: Re: Network file system that support sqlite3 well)

Off topic And a something relatively new from the future (I hope) filed of DVCS/Data (like SQLite+Fossil in one). Dolt: https://github.com/liquidata-inc/dolt Underlying versioned DB: https://github.com/attic-labs/noms Data commit sample:

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

On 2019-10-16 01:47, Peng Yu wrote: Is there a solution that are known to fill in this niche? Thanks. Would be clusteded SQLite (distributed SQLite instead of central shared DB) be a good option for your project? - Bellow, I am pasting my bookmarks for few well established projects

Re: [sqlite] Safe sqlite over remote filesystem?

On 2018-08-14 16:07, Wout Mertens wrote: Is there a way to use safely sqlite in this situation, perhaps by using extra lock files or some other additional mechanism? One solution I can think of involves sending all writes through a single master, via files describing changes and lots of

Re: [sqlite] Stored Procedures

On 2018-05-09 03:56, Richard Hipp wrote: ... The other benefit of stored procedures is that it provides a way to code up a common operation once (correctly!) and store it in the database, rather than having multiple clients all have to work out the operating themselves (some of them perhaps

Re: [sqlite] disassemble extension (Was: kooky thought: a vm-only build (for embedded). feasible?)

On 2018-04-15 21:54, dave wrote: Anway, has this been discussed before? Or is it a fool's errand? Same kind of fool here :-) After Mr.Hipp response, which suggest that hwaci.com does not sell SSE anymore, the community could try to reproduce the same idea against current VDBE

Re: [sqlite] sequencer

On 2017-08-02 20:24, Nico Williams wrote: On Wed, Aug 02, 2017 at 07:48:52PM +0300, Alek Paunov wrote: On 2017-08-02 18:23, Sylvain Pointeau wrote: ... CREATE SEQUENCE IF NOT EXISTS SEQ_1 START WITH 12123; insert into MYTABLE(SPECIFIED_NUMBER, OTHERINFO) values (seq_1.nextval, 'other info

Re: [sqlite] sequencer

On 2017-08-02 18:23, Sylvain Pointeau wrote: ... CREATE SEQUENCE IF NOT EXISTS SEQ_1 START WITH 12123; insert into MYTABLE(SPECIFIED_NUMBER, OTHERINFO) values (seq_1.nextval, 'other info') BTW, your request is somewhat related with the brand new union-vtab SQLite extension [1] (for

[sqlite] sqldiff nowadays

Hi MM, Sorry for the late replay - I usually manage to check the list only once a day :-(. On 2016-03-22 16:05, MM wrote: ... >> If, by chance, you are on something Fedora based, I could give you some >> hints how to help our lead maintainer - Jan Stanek with the package >> enhancement myself.

[sqlite] sqldiff nowadays

On 2016-03-22 13:49, Richard Hipp wrote: > On 3/22/16, MM wrote: >> Hello, >> I can see sqldiff appearing here: >> >> https://www.sqlite.org/sqldiff.html >> >> and in the downloads page as part of a linux 32bit binary package. >> Alas I don't see any 64bit package. > > The 32bit binaries will run

[sqlite] Schema-less JSON SQLite DB?

Hi Hayden, On 14.07.2015 03:43, Hayden Livingston wrote: > Is there a concept of a schema-less JSON SQLite DB? > > My reason is simple: versioning. We have lot of business metrics that > get updated let's say once a month, and we need to be agile to get > them. Right now, we just put the

[sqlite] Where sqlite vtables are used? (was: Search for text in all tables)

On 05.12.2014 12:32, Dominique Devienne wrote: On Fri, Dec 5, 2014 at 10:24 AM, Max Vlasov wrote: Not particularity the answer to your question, but rather a method you or others might use. I once implemented a virtual table "allvalues" that outputs all database values

Re: [sqlite] Window functions?

On 25.08.2014 20:47, Richard Hipp wrote: On Mon, Aug 25, 2014 at 1:21 PM, forkandwait wrote: You used the word "immense" which I like - it is an apt description of the knowledge and effort needed to add windowing functions to SQLite (and probably any other database

Re: [sqlite] Problem with recursive CTE

On 25.08.2014 15:42, Frank Millman wrote: I have upgraded to version 3.8.6, and I can confirm that it now works. Thanks very much, Richard and Keith Now I have to figure out how to get Python to use the upgraded version, but that is one for the python mailing list. You may consider upgrade

Re: [sqlite] Virtual table API performance

On 05.03.2014 11:02, RSmith wrote: On 2014/03/05 10:41, Dominique Devienne wrote: On Tue, Mar 4, 2014 at 9:41 PM, Elefterios Stamatogiannakis One thing that IMHO long term might improve the situation would be if SQLite's own "native" tables would use the same Virtual Table API,//... ...//Of

Re: [sqlite] Virtual table API performance

On 04.03.2014 20:25, Eleytherios Stamatogiannakis wrote: On 04/03/14 20:11, Alek Paunov wrote: On 04.03.2014 15:05, Eleytherios Stamatogiannakis wrote: On 03/03/14 03:01, Alek Paunov wrote: It seems that the easiest optimization for this (very often) VT use case (bulk streaming) is SQLite add

Re: [sqlite] Virtual table API performance

On 04.03.2014 15:05, Eleytherios Stamatogiannakis wrote: On 03/03/14 03:01, Alek Paunov wrote: It seems that the easiest optimization for this (very often) VT use case (bulk streaming) is SQLite add-on in _C_ to be written, implementing vtable interface specialization containing xNextPage

Re: [sqlite] Virtual table API performance

On 02.03.2014 21:38, Elefterios Stamatogiannakis wrote: Under this view, the efficiency of the virtual table api is very important. Above query only uses 2 VTs in it, but we have other queries that use a lot more VTs than that. Max tests in C shows 2x CPU work, but he explains that the test is

Re: [sqlite] Still trying to track down loadable extensions

On 21.02.2014 02:05, Nico Williams wrote: https://github.com/slightfoot/sqlite3-extensions https://github.com/salviati/sqlite3-lz4 https://github.com/ralight/sqlite3-pcre http://sqlite.mobigroup.ru/wiki?name=extensions http://sqlite.mobigroup.ru/wiki?name=utils

Re: [sqlite] Still trying to track down loadable extensions

On 21.02.2014 01:19, Peter Haworth wrote: I'm still hunting for loadable extensions. The SQLite web site makes reference to extensions being part of the source code in the contrib folder but when I browser around there, I can only see 2 files dlmalloc and sqlcon. I see that you are

Re: [sqlite] Recursive query?

On 10.01.2014 17:34, Richard Hipp wrote: On Wed, Jan 8, 2014 at 2:35 PM, Richard Hipp wrote: FYI: The 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

Re: [sqlite] RFE: Rename Column

On 06.01.2014 00:58, Simon Slavin wrote: On 5 Jan 2014, at 6:41pm, Petite Abeille wrote: On Jan 5, 2014, at 6:56 PM, Igor Tandetnik wrote: On 1/4/2014 7:15 PM, Elrond wrote: Short: Could you implement alter table rename column? The problem

Re: [sqlite] SQLite version 3.8.2 running 2.5x faster for some queries.

On 23.11.2013 13:18, Richard Hipp wrote: SQLite must know that the function always gives the same output given the same inputs. No every function works that way. Counterexamples include random() and last_insert_rowid(). But most built-in functions are factorable in the same way that

Re: [sqlite] SQL 2003 in sqlite

On 12.11.2013 10:45, Sylvain Pointeau wrote: The merge statement is really missing in sqlite... Definitely it is missing ... for maybe 0.05% of the (advanced) SQLite users :-). Much large group missing UPDATE and DELETE statements over joins at first place. Is there any plan to integrate

Re: [sqlite] Which constraint is being violating??

On 04.11.2013 11:46, Rafa de Miguel wrote: Yes, I knew that but that info it doesn't really help me too much FWIW: You probably are aware of this too, but just in case: On the browsers, especially these without build-in WebSQL (sqlite) support, the developer can fallback to a C to LLVM IR to

Re: [sqlite] Feature Request: Binding Arrays

On 01.11.2013 22:04, Alek Paunov wrote: After reading the whole tread I suspect that you have already considered the whole thing about the :memory: DB bridging the GUI with the real DB but I am curious why? Sorry - unfinished sentence: ... why you have rejected this approach

Re: [sqlite] Feature Request: Binding Arrays

Hi Dominique, On 16.10.2013 11:40, Dominique Devienne wrote: We have an SQLite virtual-table heavy application with a lot of the GUI driven by SQL queries, and often times we have queries of the form ... create table t (name text, type text, primary key (name, type)); select * from t

Re: [sqlite] Feature Request: Binding Arrays

On 31.10.2013 18:37, Nico Williams wrote: On Wed, Oct 16, 2013 at 07:28:04AM -0400, Richard Hipp wrote: Please see http://www.sqlite.org/src/artifact/2ece66438?ln=13-75 I've been thinking for a while -ever since I happened upon jq(1)- that a marriage of jq and SQLite3 would be wonderful. jq

Re: [sqlite] SQLite, HTML5 and Javascript

On 29.10.2012 20:44, Rose, John B wrote: 1) We are looking for simple examples, with source code, of a UI using HTML5 to query and add data to an SQLite database 2) We are also looking for examples using Javascript to query an existing SQLite database. And maybe add data to an existing

Re: [sqlite] sqlite versus MySQL automatic defragmentation on SSDs?

Hi David, On 29.10.2012 11:58, David Barrett wrote: Because in practice, as someone actually doing it (as opposed to theorizing about it), it works great. The MySQL portions of our service are always in a semi-constant state of emergency, while our sqlite portions just hum along And given

Re: [sqlite] Unofficial poll

On 23.09.2012 23:59, Simon Slavin wrote: On 23 Sep 2012, at 9:55pm, Alek Paunov <a...@declera.com> wrote: This feature is very useful for storing hierarchical data - XML, JSON, ASTs, objects in the script engines (e.g. Lua, Python, ...), etc. Really ? I don't know about ASTs, but aren

Re: [sqlite] Unofficial poll

On 23.09.2012 13:37, Baruch Burstein wrote: Has anyone ever actually taken advantage of this feature? In what case? Yes, This feature is very useful for storing hierarchical data - XML, JSON, ASTs, objects in the script engines (e.g. Lua, Python, ...), etc. IMHO, If the understanding of the

Re: [sqlite] INSERT OR REPLACE

On 12.03.2012 16:02, Christian Smith wrote: I've had a similar problem in the past, and solved it by using a pre-insert trigger to do the desired update. Thus, the insert/update from above becomes just an insert (or ignore), with an implied update in the trigger, which appears to be sematically

Re: [sqlite] Cyrillic support

On 10.03.2012 19:07, Mite wrote: I am using the newest version of SQLite. How do I enable support for Cyrillic letters? Whenever I enter something in the DB with Cyrillic letters it gets saved like this ?? I don't think so. Please try the attached shell script. Also, you can check this

Re: [sqlite] INSERT OR REPLACE

On 09.03.2012 17:39, Nico Williams wrote: Perhaps a Google summer of code project or something? Perhaps. Unfortunately not :-(. Google people have made a mistake in the past - looking for formal criteria to guarantee the openness of the initiative they included the rule that mentoring

Re: [sqlite] INSERT OR REPLACE

On 09.03.2012 02:22, Nico Williams wrote: On Thu, Mar 8, 2012 at 5:57 PM, Alek Paunov<a...@declera.com> wrote: Let suppose hypothetical function: asm(sql): returns VDBE assembler code for the sql parameter (like 'explain' but with full instruction attributes) I am curious, Is it eva

Re: [sqlite] INSERT OR REPLACE

Hi List, On 09.03.2012 01:15, Nico Williams wrote: SQL was not, originally, a Turing complete language (unless one were to consider cross self joins of large tables for driving iteration as good enough), but nowadays it pretty much is, therefore it is a programming language. The language

Re: [sqlite] GUI for SQLite

On 08.03.2012 15:13, gregorinator wrote: I've been happy with SQLite Studio: http://sqlitestudio.one.pl/ Just tried Sqlite Studio following your advice - Great tool: * open source * implemented in scripting language (Tcl/Tk) * available as single executable * SQL editor with highlighting

Re: [sqlite] Some pieces of the puzzle are coming together

On 21.01.2012 16:00, John Elrick wrote: manifestation. As frustrating as it has been to narrow down the cause, I Frustrating ... ? John Elrick, 2012-01-13: """ I created a logging system which took a specific set of data and converted all of the automatically run queries to an SQL script

Re: [sqlite] search

BTW, in my eyes, sqlite has the full potential to become most used DB engine for hierarchical data too (besides relational), once someone clever hacker manage to port something like Pathfinder [1,2,3] (which is, let say, optimizing XQuery/SQL compiler) to generate VDBE bytecode (like the

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

On 15.11.2011 22:35, Nico Williams wrote: my answer: a plethora of interfaces to the same data (posts/threads). +1 I'd like to see: - RSS/Atom feeds - web UIs ("web forum" UIs) - stable HTTP APIs - mobile apps specifically for fora (probably based on HTTP APIs) - e-mail interface

Re: [sqlite] status of unqlspec / sqlite

Hi, Recent comment on the topic from unql mailing list: https://groups.google.com/forum/#!msg/unql/dVc_cM1ZGw8/3QHE1_MIqRQJ On 04.11.2011 10:50, sqlite-us...@h-rd.org wrote: Hi, some time ago Richard was involved in http://www.unqlspec.org/ . Is that still going on? I am quite interested in

Re: [sqlite] Using SQLite on Windows 64bit

I have 64-bit binary package for my OS (kindly maintained by guy named Panu Matilainen, outside of the sqltie.org core team). I have installed this package after the command: yum install sqlite This currently installs 3.7.5 for me. If I want to test/use different version I type: fossill

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

This was said above in the thread - try this google query: site:mail-archive.com inurl:sqlite-users "How about a" BTW, Some day I would be happy to use FTS powered search across the mail archives, maybe with additional feature (authorized with list-member credentials) for tagging and

Re: [sqlite] C API docs

I do not know the answer, but I am thinking for an attempt to extract them as clang+lpeg exercise. Why you are asking ... ? On 24.10.2011 16:05, Baruch Burstein wrote: How are the C API documents auto-generated? Which tool is used? I see that they are all in the comments in the code, but

Re: [sqlite] How to use SQLite as a data source in Excel (tables and pivottables)

Hi Frank, You can take a look at my start-up file for excel 2000/2003: http://source.declera.com/excel/personal.xls (I am also attaching contained VBA module db.bas) With started personal.xls [1], one can open empty sheet named "sqlite", enter the path to sqlite database file in cell A1, and