Re: [sqlite] DB Partitioning and Performance

ud.org> wrote: > >On 27 May 2016, at 3:17am, Michael Hari <michael.h...@slalom.com> wrote: > >> I have a database that contains 2014,2015 and 2016’s worth of data broken >> down by year and quarter. In total, this db was 2.36 GB. Because of a >> replication requirem

[sqlite] DB Partitioning and Performance

I have a database that contains 2014,2015 and 2016’s worth of data broken down by year and quarter. In total, this db was 2.36 GB. Because of a replication requirement where the DB has to be under 2 GB, I’ve split the DB into 3 smaller databases by year (2014.db,2015.db,2016.db). I would need

Re: [sqlite] Attach Database and Database pooling

Never mind, there was an error in my code. On 5/26/16, 11:52 AM, "sqlite-users-boun...@mailinglists.sqlite.org on behalf of Michael Hari" <sqlite-users-boun...@mailinglists.sqlite.org on behalf of michael.h...@slalom.com> wrote: >Hi All, > > > >I’m trying

[sqlite] Attach Database and Database pooling

Hi All, I’m trying to preallocate about 20 sqlite connections each with the same “ATTACH DB” command. I’m getting “database x already in use” errors. Is this not possible to do? Can each independent X connection not have the same attached DB command? If not, what’s the preferred approach?

Re: [sqlite] Binary Difference in Sqlite database files instead of SQLdiff and patch ?

te-users-boun...@mailinglists.sqlite.org on behalf of slav...@bigfraud.org> wrote: > >On 24 May 2016, at 6:04pm, Michael Hari <michael.h...@slalom.com> wrote: > >> I’ve come to the conclusion that I would need to “split the file into two >> databases” as well. The challenge here

Re: [sqlite] Binary Difference in Sqlite database files instead of SQLdiff and patch ?

Hi Simon, We don’t want to zip up the entire db unfortunately. It would be around 250 MB zipped versus having Sparkle update with a 38 MB patch. (Bandwidth costs are important for us) I’ve come to the conclusion that I would need to “split the file into two databases” as well. The challenge

Re: [sqlite] Is IBatis / MyBatis ORM Framework supports SQLite Client Database

thanks On Fri, Feb 14, 2014 at 11:29 AM, Richard Hipp <d...@sqlite.org> wrote: > On Fri, Feb 14, 2014 at 11:24 AM, Hari Hara Sudhan Ramachandran < > loginsud...@gmail.com> wrote: > > > i tried to establish Database > > connection using Mybatis ( IBatis ) fr

[sqlite] Is IBatis / MyBatis ORM Framework supports SQLite Client Database

atis is not supporting SQLite Database. if so, what are the other well developed ORM framework supports SQLite Database. i am waiting for your earliest reply. Thanks, Hari ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi

[sqlite] sqlite3_exec function hanging upto 30 to 40 mins

Hi all, I am using sqlite 3.3.15 version in my setup on Solaris 10 SPARC machine. sqlite_exec function is hanging suddenly in the middle while retrieveing rows from a table. I am able to reproduce this very frequently. I did not understand why it is hanging for 30 to 40 mins without throwing any

[sqlite] want that particular time and date when a row is inserted in a table

row time when it was inserted. am i missing something? as i want time at the time of insert, so how i can get the that specific row time and date when this row was inserted. suggest me any ideas.. thanks Hari oum ___ sqlite-users mailing list sqlite-users@sq

[sqlite] problem with sqlite3_exec() and select sql statemant

Hi as i am new to sqlite. I have problem when i am using sqlite3_exec() function with select as i am using sqlite3_open() to opening database then creating table and inserting some information using sqlite3_exec() and 'create table' and 'insert into' then again if i use sqlite3_exec() with select

Re: [sqlite] make test fails at tcl-10.5

Works now. Thanks much! -Hari On Tue, 2005-08-16 at 07:11 -0400, D. Richard Hipp wrote: > On Mon, 2005-08-15 at 19:40 -0700, Hari Kodungallur wrote: > > Hi, > > > > I am using the latest from the CVS. While doing "make test", it fails at > > tcl-10.5 with a

[sqlite] make test fails at tcl-10.5

6 i386 GNU/Linux Thanks -Hari --- Hari Kodungallur SpikeSource Inc.