ample code.
A big thank you to Dr Hipp for the prompt fix.
/Lindsay
Code output from shell built from latest trunk snapshot tarball:
SQLite version 3.26.0 2018-11-02 17:38:39
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to r
issue trying to test your fix or if the
fix itself is the issue.
Regards,
/Lindsay
On Fri, Nov 2, 2018 at 10:38 AM Richard Hipp wrote:
> Please try your test script on the latest trunk check-in and let us
> know whether or not it is working for you.
>
> --
> D. Richard Hipp
>
ags: apple-osx)
01:12:06 [e0d30c1862] *MERGE* Merge fuzz test cases computed by dbfuzz2.
(user: drh)
01:04:18 [d57873337a] Improved corrupt database detection in the
relocatePage() routine of the b-tree module. (user: drh)
/Lindsay
On Fri, Nov 2, 2018 at 4:49 PM Lindsay Lawrence
wrote:
> Hi,
;.open FILENAME" to reopen on a persistent database.
sqlite> .load './json1.so'
sqlite> attach "test.db" as test;
sqlite> INSERT INTO test.people (name, age) VALUES ('Alice', 30), ('Bob',
42);
Error: no such table: test.json_each
/Lindsay
3.25.2.
(sha1: c9ff08b91a0faacabe2acb240e5dba3cf81071f3)
Compiled with:
gcc -Os -I. -DSQLITE_THREADSAFE=0 -DSQLITE_ENABLE_JSON1 -DHAVE_USLEEP
-DHAVE_READLINE shell.c sqlite3.c -ldl -lreadline -lncurses -Os -o sqlite3
/Lindsay
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
s an amalgamation, version 3.25.2.
(sha1: c9ff08b91a0faacabe2acb240e5dba3cf81071f3)
Compiled with:
gcc -Os -I. -DSQLITE_THREADSAFE=0 -DSQLITE_ENABLE_JSON1 -DHAVE_USLEEP
-DHAVE_READLINE shell.c sqlite3.c -ldl -lreadline -lncurses -Os -o sqlite3
/Lindsay
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
long ago it was 6Mb or so. SQLite has added some incredible
functionality in recent years and the shell cli still comes in under 1Mb
for a nicely feature-full build. Apples and oranges. Still...
/Lindsay
On Fri, Feb 3, 2017 at 2:13 PM, Michael Falconer <
michael.j.falco...@gmail.com>
iently into
a spreadsheet, or another db, for further munging you could set csv mode
and/or force a download. As a note, unless you are sorting a very large
dataset the resource usage of all of this is quite low as sqlite just pipes
the dataset out over the http response as it is generated.
/Linds
ironment we run in where relational data can be fragmented and
distributed over many VMs and still be accessible with a common interface
and query language.
Many thanks.
Best Regards
Lindsay
On Wed, Feb 18, 2015 at 11:11 AM, Darko Volaric wrote:
> I second this notion. I think SQLite is uni
ion source and tested the above
change using my import data; about 1Gb of messy, but rfc4180 compliant,
CSV. It all imported cleanly.
sqlite3 is a wonderful bit of software. I have been using it for some time
now to munge and query multi-gigabyte size data sets and am very impressed
with its performance and capabilities.
Best Regards,
Lindsay
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
greatly appreciated.
Regards
Andrew Lindsay
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Try
select n.name, p.type, p.addr
from p
join name on p.id = n.id
union
select n.name, e.type, e.addr
from e
join name on e.id = n.id
Patty
On Fri, May 15, 2009 at 12:14 AM, Evan Burkitt wrote:
> This isn't a Sqlite question per se, but I know there are some SQL gurus
> here who might have some
I'd like to import a file into a table from php. Is there anyway to
execute the .import from php. I am using the pdo interface.
Patty
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Russell Leighton wrote:
>
> Big distruptive code change?
Also more opportunites for things to go wrong with mismatched index/db files
Also no longer can copy/move db as a single file
--
Lindsay
most as long as retrieving
> all the records.
I have noticed exactly that behaviour recently in MySQL and MSSQL (where
it had to be emulated). This was when implementing a web paging access
as the original poster is doing.
--
Lindsay
nt to do it would help people
help you.
"What low level C API's are there" is pretty ambigous.
--
Lindsay
Anish Enos Mathew wrote:
> Any body know whether there are any low level C API's for sqlite3 ?
>
Ummm - how about the native one ?
--
Lindsay
[EMAIL PROTECTED] wrote:
Agree in principle with what you're saying here as well, one suggestion
- perhaps you could mod your server to accept/general queries/output via
standard in/out. That way its could be piped over a multitude of channels.
Cheers - Lindsay
utput via
standard in/out. That way its could be piped over a multitude of channels.
Cheers - Lindsay
sed vi a ASCII line based protocol.
_javascript_ has excellent functions for parsing ASCII data, but support
for XML Parsing is erractic, in IE its done via a ActiveX object.
--
Lindsay
use a very
similar custom protocol over http to feed db data to a web app of mine.
--
Lindsay
:( Interested in the
protocol, it looks simple eniugh to integrate into a webapp.
--
Lindsay
? is the 2
oppressed by being under the 5 ? how is this the fault of the
patriarchy ? discuss
--
Lindsay
al
canon hardware. No chance at all that we'd be allowed to upload DLL's
or compile C on the platform.
--
Lindsay
it in anger yet though.
--
Lindsay
Richard wrote:
Still have found no sql program yet, that can beat Panorama in speed.
Since Panorama is RAM based, how about if you did your speed test with a
SQLite in memory database ?
--
Lindsay
in our app on 1000's of PC's, if it failed the PC's would
crash - badly. Believe me I would know ...
--
Lindsay
Kurt Welgehausen wrote:
2) use a cursor to browse a result set ? ...
No.
The sqlite_compile/step/finalize paradigm allows (requires really )
forward browsing through a result set.
wxSQLite has moved to http://sourceforge.net/projects/wxsqlite and is
currently in an active phase of development. No file releases yet (soon
! when I get the bind/reset api finalised)
CVS is usable though: linux (via configure & make install) and a Win32
VC project are supported.
--
Eugene Lin wrote:
Bert,
It is a COM-related problem, not a SQLITE problem
I can now tell you that it IS a sqlite problem NOT a COM problem. Sqlite is trying to create its temporary database at some location (which I'm not sure where) and it failed. I have found that you can force sqlite t
Tim McDaniel wrote:
From the Microsoft Platform SDK documentation concerning LoadLibrary:
"Note that two DLLs that have the same base file name and extension but
are found in different directories are not considered to be the same
DLL."
Interesting - my MSDN (April 2002) doesn't mention this, n
Sergey Startsev wrote:
Hello!
I am trying to load two copies of sqlite.dll at one time.
One - version 2.8.4, two - version 2.8.6
handle1:= loadlibrary('c:\2.8.4\sqlite.dll');
// this loaded OK
handle2:= loadlibrary('c:\custom\sqlite.dll');
// this return error
ERROR_NOACCESS (Invalid acces
Bert Verhees wrote:
Hi,
Since we are using the new List-headers on sqlite-list, I am
experiencing two disadvantages.
I recieve many emails twice, please do not send your emails twice, but
manually remove one from the To or CC when your emailer does not
support List-reply.
But at least we can
Bert Verhees wrote:
--
Who wants a "Reply-To" header added to the SQLite mails. This means
that regular emailclients (Outlook, Mutt, Mozilla, Pegasus, and more)
automatically fill in the address of the mailinglist when you hit reply.
I *D
Randal L. Schwartz wrote:
me via the list, before I realized what happened.
And I've learned to hit "F" vs "R" in my mailer. Please don't punish
me for being smart enough to operate my mailer simply to placate those
who don't. This is a mailing list about *sqlite*. Not about dog
breeding.
H
35 matches
Mail list logo
