Re: [sqlite] SQLite for single user data manipulation

Hi Nick, >"I just can't find any input for people like me who just want a data manipulation tool for data that's too big to read into RAM?" Here is what I found, that may interest you : >From Wes Mc Kinney : (about medium datas handling) - slides :

[sqlite] how can i omit the number/0 in the result in sqlite?

sqlite3 test.db create table data(num1 float,num2 float); insert into data values(1.2,3.4); insert into data values(4,0); insert into data values(2,5); insert into data values(3,0); insert into data values(5.2,3); sqlite> select num1/num2 from data order by num1/num2 asc;

Re: [sqlite] printf function is shown in docs but not found when I try it

Simon Slavin wrote: > > On 18 Apr 2014, at 2:49pm, c...@isbd.net wrote: > > > Xubuntu 13.10 (which I'm currently using) has sqlite 3.7.17. > > > > Xubuntu 14.04 has sqlite 3.8.2, I'm not sure if they're likely to move > > to anything newer during its lifetime. > > If

[sqlite] Remote access to SQLite in Linux from Windows.

Folks, We plan to remote access to SQLite in Linux from Windows using .NET C# 1. Any existing tools are available? 2. Is possible to use SSH for remote? Thanks, TFZ ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] how can i omit the number/0 in the result in sqlite?

On Fri, Apr 18, 2014 at 10:35 PM, 水静流深 <1248283...@qq.com> wrote: > sqlite3 test.db create table data(num1 float,num2 float); insert into > data values(1.2,3.4); insert into data values(4,0); insert into data > values(2,5); insert into data values(3,0); insert into data values(5.2,3); > sqlite>

Re: [sqlite] cannot set connection while a datareader is active

Il 16/04/2014 22.33, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Joe i cannot find the way for follow the command object properties you saycould you tell me what and how to observe exactly please ? You might need to add the System.Data.SQLite project(s) to the solution in order to

Re: [sqlite] printf function is shown in docs but not found when I try it

n Sat, 19 Apr 2014 10:38:01 +0100, c...@isbd.net wrote: >Simon Slavin wrote: >> >> On 18 Apr 2014, at 2:49pm, c...@isbd.net wrote: >> >> > Xubuntu 13.10 (which I'm currently using) has sqlite 3.7.17. >> > >> > Xubuntu 14.04 has sqlite 3.8.2, I'm not sure if they're

Re: [sqlite] cannot set connection while a datareader is active

Stefano Ravagni wrote: > > Joe have you somes help advice for my case ? I don't receive your answer > from 3 days... > I'm still unable to reproduce the behavior you describe here locally. Are you able to post all the code that interacts with System.Data.SQLite? That might help me to narrow

Re: [sqlite] cannot set connection while a datareader is active

Il 19/04/2014 20.12, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Joe have you somes help advice for my case ? I don't receive your answer from 3 days... I'm still unable to reproduce the behavior you describe here locally. Are you able to post all the code that interacts with

[sqlite] [ANNOUNCEMENT] Updated: sqlite3-3.8.4.3-1 for Cygwin/Cygwin64

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine Changes since 3.8.4.1-1 = * Updated to upstream 3.8.4.3 release. See: * One new Cygwin package:

Re: [sqlite] cannot set connection while a datareader is active

Stefano Ravagni wrote: > > Is a big project wich re-call many function and interacts many times > with sqlite provider... i could try to isolate a piece of code but > isolating the code i don't know if the error will be reproduced...but i > will try is all VB codeare you interested to