Re: [sqlite] Free Page Data usage

Hi, Sir, the 32 TB size is not always going to be reached. The Database is going to be used to store blocks of a Block Device like /dev/sda1 The size can reach 3-4 TB easily and would start from atleast 20-100 GB. 32 TB of data though impractical as of today will be possible in 2-3 years. The

Re: [sqlite] help needed for major SQLite problem

On 02/08/2014 03:00 AM, C M wrote: This is a follow-up to a question I asked on this list on Sep 1st, 2013, about an error that I was randomly getting with disk-based SQLite database in a Python desktop application. I now have more info to provide about the error...such as what was asked for at

Re: [sqlite] Avoiding holding a lock for too long

On 7 Feb 2014, at 10:44pm, Tim Streater wrote: > Now I'm finding that sometimes the "processing results here" can take a > minute or so, as it involves reading a file from disk and sending it to a > remote host. Instead of twiddling my thumbs waiting for this, I'm

[sqlite] Avoiding holding a lock for too long

I have some PHP code, roughly as follows (ignoring error handling): $dbh = new SQLite3 ('/path/to/mydb'); $res = $dbh->query ('select a,b,c from mytable where d=23'); // for example while (true) { $reg = $res->fetchArray (SQLITE3_ASSOC); if ($reg===false) break; //

Re: [sqlite] help needed for major SQLite problem

This is a follow-up to a question I asked on this list on Sep 1st, 2013, about an error that I was randomly getting with disk-based SQLite database in a Python desktop application. I now have more info to provide about the error...such as what was asked for at that time: On Sun, Sep 1, 2013 at

Re: [sqlite] Free Page Data usage

A database that is geared for 32TB size and you are concerned about rather insignificant space wasted by the page size that is needed to reach the 32TB max size... does not make any sense unless you are simply paranoid about space. Removing the gaps in the table space when deleting a row (or

Re: [sqlite] Errors Compiling Extension percentile.c

Denis Burke wrote: > > How do I access such functions? If I am missing some existing docs, please > just point me to them. > Something like this: SQLiteConnection connection = new SQLiteConnection("Data Source=:memory:;"); connection.Open(); connection.EnableExtensions(true);

Re: [sqlite] Free Page Data usage

On 7 Feb 2014, at 6:35pm, Raheel Gupta wrote: > As you may see that there is now 25% data deleted in each page. > > Now even if I do insert another 2500 rows (25% of original size) my > database size reaches 125% of the original size when I inserted the 1 > rows

Re: [sqlite] Free Page Data usage

Hi, I use a page size of 64 KB. But my row consists of 2 columns that is : i - Auto Increment Integer, b - 4096 Bytes of BLOB data Now for the sake of calculation, lets say 16 rows fit in a page and my table has 1 rows when I start. Now, lets say I delete some data which is not in sequence

Re: [sqlite] Free Page Data usage

Can you write more about how this is causing you a problem? Most users don't experience this as a problem On Feb 7, 2014 10:30 AM, "Raheel Gupta" wrote: > > > > SQLite's tables are B-trees, sorted by the rowid. Your new data will > > probably get an autoincremented rowid,

Re: [sqlite] Send Mail from sqlite

Have your application that is performing the update send an email when it does an update/insert/delete. >I like to know if there is any possible to send a mail from sqlite. > >I wanted to know if there is option to configure smtp in sqlite, which >will help me to send a mail. > >My requirement

[sqlite] Redundant #define's in os_unix.c

Hi all, In src/os_unix.c line 105, _LARGE_FILE is defined if SQLITE_DISABLE_LFS is not defined. But before that, is included, which contains exactly the same #defines already. This means that _LARGE_FILE will be defined twice. Most likely, one day in the past this code moved from os_unix.c to

Re: [sqlite] Error: "File is encrypted or is not a database"

On 7 Feb 2014, at 10:49am, Iksanov Husain wrote: > We have an encrypted SQLite database with a password which is set > programmatically in .NET interface. Can you tell us which encryption system you used to encrypt your database ? Did you change anything in the last day or

Re: [sqlite] Free Page Data usage

> > SQLite's tables are B-trees, sorted by the rowid. Your new data will > probably get an autoincremented rowid, which will be appended at the end > of the table. > > A page gets reorganized only when about 2/3 is free space. > Anyway to make this ratio to lets say 1/3 ?

Re: [sqlite] Send Mail from sqlite

Simon Slavin wrote on Friday, February 07, 2014 5:06 AM >> On 7 Feb 2014, at 9:59am, Vairamuthu wrote: >> Thanks for your response, it will be great help if you can get me >> some sample code or algorithms, on that. > > That would depend on what programming language you

Re: [sqlite] Send Mail from sqlite

Thanks to all for the suggestion, will try my best to implement this solution. On Fri, Feb 7, 2014 at 6:28 PM, Kevin Martin wrote: > On 7 Feb 2014, at 09:59, Vairamuthu wrote: > > > Thanks for your response, it will be great help if you can get me

Re: [sqlite] Free Page Data usage

Raheel Gupta wrote: > When I delete just 2-3 rows, that page is not reused for the new data > which will be inserted in the future. SQLite's tables are B-trees, sorted by the rowid. Your new data will probably get an autoincremented rowid, which will be appended at the end of the table. A page

Re: [sqlite] Errors Compiling Extension percentile.c

>I'm not exactly sure what is causing your compilation errors; however, the >recent releases of System.Data.SQLite (specifically the SQLite.Interop.dll >interop assembly) already include the percentile extension (as well as a >couple other extensions). > >-- >Joe Mistachkin Joe - Thanks for the

[sqlite] Error: "File is encrypted or is not a database"

Hi! We have an encrypted SQLite database with a password which is set programmatically in .NET interface. This base has been used by our application for a long time and everything has been OK till today. On opening base this error occurs: "File is encrypted or is not a database". Noone could

[sqlite] Error: "File is encrypted or is not a database"

Hi! We have an encrypted SQLite database with a password which is set programmatically in .NET interface. This base has been used by our application for a long time and everything has been OK till today. On opening base this error occurs: "File is encrypted or is not a database". Noone could

Re: [sqlite] Mimic MERGE in a trigger

On Fri, Feb 7, 2014 at 2:50 PM, Constantine Yannakopoulos < alfasud...@gmail.com> wrote: > As for scaled integers for amounts, if it was up to me I would prefer BCDs > but this choice is out of my hands. Oh, also the "cube" table can contain records for many accumulators (e.g. debit, credit,

Re: [sqlite] Mimic MERGE in a trigger

On Fri, Feb 7, 2014 at 2:10 PM, Simon Slavin wrote: > You're right. Let's see if I can make it up to you. I do think you came > up with the right strategy, and that doing INSERT OR IGNORE is going to > give you the best result overall. > Thanks. I myself couldn't come up

[sqlite] Free Page Data usage

Hi, My Page size is 64KB and I store around 4KB of row data in one row. I store around 1 rows in one table and the database size reaches 42MB. Now, I am facing a peculiar problem. When I delete just 2-3 rows, that page is not reused for the new data which will be inserted in the future. The

[sqlite] Unit-test failure in SQLite (64-bit)

When running the SQLite unit-tests on Cygwin64 (but the same is expected to happen on any 64-bit UNIX-like system): $ .libs/testfixture.exe test/tclsqlite.test tcl-1.1... Ok tcl-1.2... Ok tcl-1.2.1...Segmentation fault (core dumped) The cause of this crash is the Tcl function Tcl_AppendResult(),

Re: [sqlite] Mimic MERGE in a trigger

On 7 Feb 2014, at 11:32am, Constantine Yannakopoulos wrote: > On Fri, Feb 7, 2014 at 1:27 PM, Simon Slavin wrote: > >> Don't do it like that. >> >> Use 'INSERT OR IGNORE' to insert a record with a zero amount. >> Then update the record which, now,

Re: [sqlite] Mimic MERGE in a trigger

On Fri, Feb 7, 2014 at 1:27 PM, Simon Slavin wrote: > Don't do it like that. > > Use 'INSERT OR IGNORE' to insert a record with a zero amount. > Then update the record which, now, definitely does exist. > Obviously you didn't read all of my message. :)

Re: [sqlite] Mimic MERGE in a trigger

On 7 Feb 2014, at 11:03am, Constantine Yannakopoulos wrote: > I would like to create a trigger on table CustomerTrans that performs the > accumulation of transaction amounts in CustomerAccum. This trigger should > - Insert a record with the transaction amount if a record

[sqlite] Mimic MERGE in a trigger

Hello everyone, Given a master table, a table of transactions and a table of cumulative amounts per transaction master: CREATE TABLE Customer ( id INTEGER PRIMARY KEY, firstname VARCHAR(50), lastname VARCHAR(50) ); CREATE TABLE CustomerTrans ( id INTEGER PRIMARY KEY, transactiondate

Re: [sqlite] Send Mail from sqlite

On 7 Feb 2014, at 09:59, Vairamuthu wrote: > Thanks for your response, it will be great help if you can get me some > sample code or algorithms, on that. I'm assuming you're using SQLite embedded within another application on something unix like. Off the top of my

Re: [sqlite] Send Mail from sqlite

On Fri, Feb 7, 2014 at 11:06 AM, Simon Slavin wrote: > On 7 Feb 2014, at 9:59am, Vairamuthu wrote: > > > Thanks for your response, it will be great help if you can get me some > > sample code or algorithms, on that. > > That would depend on what

Re: [sqlite] Send Mail from sqlite

Not sure now if SQLite does events that can be picked up by your application, but I use a VB wrapper (vbRichClient, written by Olaf Schmidt) that does do SQLite events. If events can't be used then I presume you need to poll the database for changes. RBS On Fri, Feb 7, 2014 at 10:06 AM, Simon

Re: [sqlite] Send Mail from sqlite

On 7 Feb 2014, at 9:59am, Vairamuthu wrote: > Thanks for your response, it will be great help if you can get me some > sample code or algorithms, on that. That would depend on what programming language you are using and what access it has to any method of sending

Re: [sqlite] Send Mail from sqlite

Thanks for your response, it will be great help if you can get me some sample code or algorithms, on that. On Fri, Feb 7, 2014 at 5:55 PM, Simon Slavin wrote: > > On 7 Feb 2014, at 9:51am, Vairamuthu wrote: > > > Hi > > > > I like to know if

Re: [sqlite] Send Mail from sqlite

On 7 Feb 2014, at 9:51am, Vairamuthu wrote: > Hi > > I like to know if there is any possible to send a mail from sqlite. No it's not. Sorry, you are going to have to do some programming. Simon. ___ sqlite-users mailing

[sqlite] Send Mail from sqlite

Hi I like to know if there is any possible to send a mail from sqlite. I wanted to know if there is option to configure smtp in sqlite, which will help me to send a mail. My requirement I need to send a notification mail once the table is getting updated/inserted/deleted. Regards Muthu