On 05.12.2014 12:32, Dominique Devienne wrote:
On Fri, Dec 5, 2014 at 10:24 AM, Max Vlasov max.vla...@gmail.com 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 with
On 25.08.2014 20:47, Richard Hipp wrote:
On Mon, Aug 25, 2014 at 1:21 PM, forkandwait webb.spra...@gmail.com 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
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
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
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
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
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
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
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
On 10.01.2014 17:34, Richard Hipp wrote:
On Wed, Jan 8, 2014 at 2:35 PM, Richard Hipp d...@sqlite.org 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 implementation.
On 06.01.2014 00:58, Simon Slavin wrote:
On 5 Jan 2014, at 6:41pm, Petite Abeille petite.abei...@gmail.com wrote:
On Jan 5, 2014, at 6:56 PM, Igor Tandetnik i...@tandetnik.org wrote:
On 1/4/2014 7:15 PM, Elrond wrote:
Short: Could you implement alter table rename column?
The problem would
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
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
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
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
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
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
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
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
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
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't XML
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
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
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
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
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
On 09.03.2012 02:22, Nico Williams wrote:
On Thu, Mar 8, 2012 at 5:57 PM, Alek Paunova...@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 evaluable (to
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 which
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
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
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
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
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 assigning
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
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
35 matches
Mail list logo