[sqlite] Is readline ubiquitous on 32-bit x86 Linux?

The pre-built sqlite3 shell tool for x86 Linux available for download here: http://www.sqlite.org/download.html does not include readline support. Which makes it painful to use. Does anyone think that many systems would be affected if it dynamically linked against the system readline?

[sqlite] Sqlite subqueries

There's been many discussions on this topic, you can search for it, but I will try to recap in short: SQL does not work like this, not in SQLite or any other SQL engine may an entity construct be referenced by an uncontrolled data value. Of course it is easy to get around this in code whereby

[sqlite] Err

There is nothing unusual about the output - it looks exactly as expected (without knowing what is inside the tables referenced). As Igor already asked: Is there anything specific you find unusual? Is it the stats block that confuses you, but which you specifically requested with the ".stats

[sqlite] Is readline ubiquitous on 32-bit x86 Linux?

Or there's editline, used for some things as a partial readline substitute. On Wed, Feb 25, 2015 at 5:12 AM, Andreas Kupries wrote: > A possible (and small alternative) to readline would be Antirez > "linenoise". > Steve Bennet's fork adds windows portability and some other things. > >

[sqlite] How to insert a pointer data to sqlite?

I have a data: Id pid namemark 1 0 f1 sample 2 1 f2 sample 3 1 f3 sample 4 2 f4 sample 5 2 *id(2).name *id(2).mark These means that under id(2) and id(5) have same

[sqlite] How to insert a pointer data to sqlite?

Have you considered normalizing your database? On Wed, Feb 25, 2015 at 12:07 PM, YAN HONG YE wrote: > I have a data: > Id pid namemark > 1 0 f1 sample > 2 1 f2 sample > 3 1 f3 sample > 4 2 f4

[sqlite] How to insert a pointer data to sqlite?

On 25 Feb 2015, at 1:07am, YAN HONG YE wrote: > I have a data: > Idpid namemark > 1 0 f1 sample > 2 1 f2 sample > 3 1 f3 sample > 4 2 f4 sample > 5 2 *id(2).name *id(2).mark >

[sqlite] Is readline ubiquitous on 32-bit x86 Linux?

On Tue, Feb 24, 2015 at 7:12 PM, Andreas Kupries wrote: > A possible (and small alternative) to readline would be Antirez > "linenoise". > Steve Bennet's fork adds windows portability and some other things. > > https://github.com/antirez/linenoise > https://github.com/msteveb/linenoise >

[sqlite] Regarding creating a mem object and copying contents to it in SQLite

hello, I created a mem object in SQLite and copied a string value to its member and i initialized some other members to default values manually, it worked well but some times it shows realloc() error. I also found a function sqlite3VdbeMemSetStr() which will copy the string value

[sqlite] Using incremental BLOB functions against a BLOB column in a virtual table

Yes. The stored SQL string will contain the keyword "VIRTUAL". asql> select sql from sqlite_master where name='sgb_dd_draw'; sql - CREATE VIRTUAL TABLE sgb_dd_draw USING Partition (

[sqlite] Regarding creating a mem object and copying contents to it in SQLite

The mem object is internal to sqlite, it is not intended to be created/changed by user code. What are you trying to do that makes you think you need to manipulate internal structures? -Urspr?ngliche Nachricht- Von: Sairam Gaddam [mailto:gaddamsairam at gmail.com] Gesendet: Mittwoch,

[sqlite] Regarding creating a mem object and copying contents to it in SQLite

I am trying to optimize certain operations of SQLite internally, so i created mem object. On Wed, Feb 25, 2015 at 12:36 PM, Hick Gunter wrote: > The mem object is internal to sqlite, it is not intended to be > created/changed by user code. > > What are you trying to do that makes you think you

[sqlite] Regarding creating a mem object and copying contents to it in SQLite

Maybe you would like to exchange experiences with Prakash Premkumar about hacking SQLite internals. -Urspr?ngliche Nachricht- Von: Sairam Gaddam [mailto:gaddamsairam at gmail.com] Gesendet: Mittwoch, 25. Februar 2015 08:23 An: General Discussion of SQLite Database Betreff: Re: [sqlite]

[sqlite] Sqlite with VS2013

Can anyone please guide me to install sqlite desinger capabilities for VS2013. I have installed 'sqlite-netFx451-setup-bundle-x86-2013-1.0.94.0.exe' on my machine. I am not able to get the sqlite option in 'Choose Data Source' window. I am having VS2013 Professional version, Attached is the

[sqlite] Using incremental BLOB functions against a BLOB column in a virtual table

On Wed, Feb 25, 2015 at 7:52 AM, Hick Gunter wrote: > And the "explain" output will contain virtual table opcodes > I use this technique to discover which tables and virtual tables a view accesses (instead of trying to parse the query.) I execute "explain select rowid from $viewname", and look

[sqlite] Regarding creating a mem object and copying contents to it in SQLite

Yaa we work together and we need some assistance regarding that. On Wed, Feb 25, 2015 at 1:18 PM, Hick Gunter wrote: > Maybe you would like to exchange experiences with Prakash Premkumar < > prakash.prax at gmail.com> about hacking SQLite internals. > > -Urspr?ngliche Nachricht- > Von:

[sqlite] Regarding creating a mem object and copying contents to it in SQLite

On 25 Feb 2015, at 10:21am, Sairam Gaddam wrote: > Yaa we work together and we need some assistance regarding that. See our responses to Prakash Premkumar. The things he thought he could optimize turned out to be unhelpful. You will find that just using normal SQLite calls you get

[sqlite] new line now \r\n regardless the OS

Dear All, it looks like we are back in town with '\n' at the end of a line **even in CSV** mode. Can anyone please confirm me (ccing me since apparently I'm not part of this ML) that SQLite no longer forces RFC4180 \r\n ? Thank you! On Sun, Aug 17, 2014 at 7:28 PM, Andrea Giammarchi <

[sqlite] new line now \r\n regardless the OS

also relevant: https://tools.ietf.org/html/rfc2046#section-4.1.1 grabbed from: Encoding considerations: As per section 4.1.1. of RFC 2046 [3 ], this media type uses CRLF to denote line

[sqlite] new line now \r\n regardless the OS

On 2/25/15, Andrea Giammarchi wrote: > Dear All, > it looks like we are back in town with '\n' at the end of a line **even > in CSV** mode. > > Can anyone please confirm me (ccing me since apparently I'm not part of > this ML) that SQLite no longer forces RFC4180 \r\n ? > I get \r\n in CSV

[sqlite] Sqlite subqueries

e tables it is to use. Lots of database management and communications problems go away. -- next part -- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 473 bytes Desc: OpenPGP digital signature URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20150225/6e08d46f/attachment.pgp>

[sqlite] Sqlite subqueries

On 2/25/2015 9:16 AM, russ lyttle wrote: > To eliminate the need to reference a table would require combining 300 > tables into one table. Yes. > A user editing entries for one space could crash > the whole system. I don't see how this follows. > That's basically what happened aboard the

[sqlite] Sqlite with VS2013

Please try the 1.0.95.0 pre-release of that same install package. Sent from my iPod > On Feb 25, 2015, at 12:08 AM, Manoj Sakhare wrote: > > Can anyone please guide me to install sqlite desinger capabilities for > VS2013. > > I have installed

[sqlite] Sqlite subqueries

A Google search for "USS Yorktown" turned up the following: "On September 21, 1997, a division by zero error on board the USS Yorktown (CG-48) Remote Data Base Manager brought down all the machines on the network, causing the ship's propulsion system to fail." RobR -Original Message-

[sqlite] Sqlite subqueries

non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 473 bytes Desc: OpenPGP digital signature URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20150225/699f61a0/attachment.pgp>

[sqlite] How to insert a pointer data to sqlite?

Unless, I'm wrong. What you want to do is use two tables. One to store the node values and another that references them for whatever object using them. Say, points for a pair of triangles, a,b,c,d,e. If table triangle is a table pointing at the table point (id,object,point) you could have a

[sqlite] Database connection from within Visual Studio

Yes, there a several things that could be done, given statistics on number of downloads. A simple fix could be to reverse the order of the .net framework versions listed, so list 4,5,1 at the top and 2,0 at the bottom. And then Group all downloads for a Framework version together, instead of

[sqlite] Sqlite subqueries

Name: signature.asc Type: application/pgp-signature Size: 473 bytes Desc: OpenPGP digital signature URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20150225/f727abfc/attachment.pgp>

[sqlite] Appropriate Uses For SQLite

Hi Dr. Hipp, group, > In a feeble effort to do "marketing", I am sure that nothing you do is "feeble"! > I have revised the "Appropriate > Uses For SQLite" webpage to move trendy buzzwords like "Internet of > Things" and "Edge of the Network" above the break. See: Nothing wrong with TLAs

[sqlite] Appropriate Uses For SQLite

I first learned about SQLite in the Bioconductor branch of R. I figured if they could handle massive genetic databases in SQLite, SQLite ought to be able to handle a million (or even 12 million) voters in a voter file. Here is a brief article from 2006, "How to Use SQLite with R" by Seth Falcon.

[sqlite] recurrent failure mode

We're experiencing a new, recurrent failure mode in an old (ie; not recently changed) sqlite application. This may be associated with buggy networked file system implementations (thanks to apple and/or microsoft) The apparent problem is that indexes on a small table become corrupted by not

[sqlite] sqlite crash with malloc_printerr in sqlite3MemFree

Hi all, We sometimes, not always reproducible but it does recur from time to time, get the following crash stack with sqlite3 version 3.8.1, we couldn't tell much from our stack, wondering if there are possibly related bugs on sqlite3? #0 0x7fdd66214925 in raise () from /lib64/libc.so.6

[sqlite] sqlite crash with malloc_printerr in sqlite3MemFree

On 2/25/15, Zhao Lin wrote: > Hi all, > > We sometimes, not always reproducible but it does recur from time to time, > get the following crash stack with sqlite3 version 3.8.1, we couldn't tell > much from our stack, wondering if there are possibly related bugs on > sqlite3? The usual cause of

[sqlite] Appropriate Uses For SQLite

This might give an impression of the scale of what the BioConductor people are doing. "The Gene Expression Omnibus (GEO) at the National Center for Biotechnology Information (NCBI) is the largest fully public repository [as of 2005] for high-throughput molecular abundance data, primarily gene

[sqlite] recurrent failure mode

On 25 Feb 2015, at 8:23pm, Dave Dyer wrote: > The facile explanation would be that a transaction to insert a new > record was executed twice, but the indexes were incorrectly maintained. > > INSERT INTO "preference_table" VALUES('Picture Placer-707-1304b-19-Maranda >

[sqlite] Appropriate Uses For SQLite

On 25 Feb 2015, at 8:13pm, Jim Callahan wrote: > I first learned about SQLite in the Bioconductor branch of R. I figured if > they could handle massive genetic databases in SQLite, SQLite ought to be > able to handle a million (or even 12 million) voters in a voter file. I'm guessing that

[sqlite] sqlite3_column_count and sqlite3_data_count

On 2/25/2015 7:03 PM, Bart Smissaert wrote: > Could somebody tell me what the difference is between these 2 functions? sqlite3_column_count() returns correct number as soon as the statement is prepared. sqlite3_data_count returns zero unless the statement is actually positioned on a row

[sqlite] sqlite3_column_count and sqlite3_data_count

On 2/25/15, Igor Tandetnik wrote: > > Why both are needed, I'm not sure. > Historical accident -- D. Richard Hipp drh at sqlite.org

[sqlite] sqlite crash with malloc_printerr in sqlite3MemFree

A short while after I submitted the post we checked our log files and found a few SQLITE_FULL errors which may have something to do with this. We will investigate on that. Thanks for your reply! Regards, Zhao -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org

[sqlite] recurrent failure mode

> >Can you provide the schema (the CREATE TABLE and any CREATE INDEX commands) >for that table ? CREATE TABLE preference_table ( preferenceSet text,/* name of this preference group */ preferenceName text, /* a preference in this group */ preferenceValue text /* sort order of this

[sqlite] recurrent failure mode

On Wed, 25 Feb 2015 16:26:45 -0800 Dave Dyer wrote: > >Do you have any multi-access things going on ? Two or more > >computers, applications, processes or threads trying to access the > >database at the same time ? > > No, but it would be normal for the database to be on a different > computer

[sqlite] new line now \r\n regardless the OS

Funny enough, apparently we all get \n in Windows now :-) ( and yes, \r\n in Linux, isn't this hilarious ) Somebody filed a bug about this and I've actually/eventually/finally patched my code doing lazy evaluation of whatever comes after a 'SELECT 1' in CSV mode so that I should be sure enough

[sqlite] PhD student

nts/20150225/8d92f1dd/attachment.ksh>

[sqlite] Date - invlaid datetime

Good Morning, I am building a Windows Universal App using Azure Mobile Services and implementing offline data using sqlite as a local database. Everything is working great. Thank you for making this available. When I Sync the data everything works well except for the created

[sqlite] recurrent failure mode

We're experiencing a new, recurrent failure mode in an old (ie; not recently changed) sqlite application. This may be associated with buggy networked file system implementations (thanks to apple and/or microsoft) The apparent problem is that indexes on a small table become corrupted by not

[sqlite] Date - invlaid datetime

Date's represented as text (and the textual representation of a date) in SQLite are big endian (ISO8601). THis means that the biggest part goes on the left, the next biggest to the right of that, and so on. Time is in the 24 hour clock and AM/PM are not used. THis results in sortable

[sqlite] Memory Leak in ext/misc/compress.c

static void uncompressFunc( sqlite3_context *context, int argc, sqlite3_value **argv ){ const unsigned char *pIn; unsigned char *pOut; unsigned int nIn; unsigned long int nOut; int rc; int i; pIn = sqlite3_value_blob(argv[0]); nIn = sqlite3_value_bytes(argv[0]); nOut = 0;