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 issu
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
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 initiating
> another action
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;
// proce
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 6:
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 row
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);
connection.LoadEx
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 initially.
>
> Hence there
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 i
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, which will be appended
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
>
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 sql
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 two: updated opera
>
> 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 ?
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 are using and what
> acces
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 some
> > sample code or algorithms, on that.
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 g
>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 r
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 c
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 change
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, tur
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 with anything better.
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
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(),
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, definitely does exist.
>
> Obviously you di
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. :)
___
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 for the
> customerid do
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 DA
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 head, here's how I would do
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 programming language you are using and what
> acce
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 Sla
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 mail. However you do it, it w
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 there is any possible to send a 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 list
sqlite-users@sqlite.org
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
__
35 matches
Mail list logo