On Fri, 26 Apr 2013 14:02:02 -0400
Roland Hughes rol...@logikalsolutions.com wrote:
It actually does make sense to add chunking to sqlite. There would be
some computational overhead, but, that all depends on the chunk size and
the cache size of the database. It makes no sense to implement
Speaking as an IT professional with 20+ years in the field, I would have
to say adding any kind of file system support to SQLite would be a
horrible thing. Yes, I've used Oracle. I've also used the only real
product Oracle has, RDB on OpenVMS. I've written books covering MySQL,
PostgreSQL, and
Writing a FS as sqlite3 as backend sounds an interesting challenge.
But I would like recalling everyone, that the question was about
writing an arbitrary precision integer in the DB considering that
the library writes the representation in a FILE*.
At the end I wrote a little FILE* wrapper
+0.75 to Roland for splitting the data, and another +1 for reiterating the
true functionality of what LITE means.
Splitting the data into chunks will help with keeping a database small as
it can throw the raw data into pages that were previously marked as
deleted, thereby not increasing the
On Fri, Apr 26, 2013 at 12:26 PM, Stephen Chrzanowski
pontia...@gmail.comwrote:
Streaming a chunk of data as one huge thing is going to be
faster in regards to writing and reading.
That depends. See http://www.sqlite.org/intern-v-extern-blob.html
--
D. Richard Hipp
d...@sqlite.org
On 26 Apr 2013, at 5:26pm, Stephen Chrzanowski pontia...@gmail.com wrote:
ALL THAT SAID, I doubt it'd get implemented
I'm also in this category. In fact I hope it doesn't get implemented. Yes,
technically it can be done. But it's the sort of thing people assign as
Computer Science
It actually does make sense to add chunking to sqlite. There would be
some computational overhead, but, that all depends on the chunk size and
the cache size of the database. It makes no sense to implement YAFS
(Yet Another File System) inside of SQLite.
While many here view SQLite only in
On 4/23/2013 3:17 PM, James K. Lowden wrote:
On Tue, 23 Apr 2013 10:28:35 -0400
Richard Hipp drh-czdrofg0bjidnm+yrof...@public.gmane.org wrote:
In summary: No, a bare SQLite blob does not provide file-system
semantics. But you can write a wrapper library around SQLite that
does provide
On Tue, Apr 23, 2013 at 6:17 PM, James K. Lowden
jklow...@schemamania.orgwrote:
On Tue, 23 Apr 2013 10:28:35 -0400
Richard Hipp d...@sqlite.org wrote:
In summary: No, a bare SQLite blob does not provide file-system
semantics. But you can write a wrapper library around SQLite that
does
On Mon, Apr 22, 2013 at 7:39 AM, Paolo Bolzoni
paolo.bolzoni.br...@gmail.com wrote:
I noticed that sqlite3_blob_write cannot increase the size of the pointed
open blob. So I ask, there is a way to treat a blob as a stream so I can
write
or read values in it with ease?
Short answer: No.
On Tue, Apr 23, 2013 at 4:28 PM, Richard Hipp d...@sqlite.org wrote:
...implemented file-system semantics on top of SQLite. I propose an API
something like this:
SQLFILE *sqlite3fs_fopen(const char *zPath, const char *zMode);
For anyone wanting to take that (admittedly large) step, i
Imagine what could happen if, for example, git where to start using this
library. Instead of the .git directory containing lots and lots of
separate files, your repository would be a single .git file which was
really an SQLite database accessed through the sqlite3fs wrapper.
I use Sqlite for a
On Tue, Apr 23, 2013 at 10:28:35AM -0400, Richard Hipp scratched on the wall:
Or, if you really want file-system semantics on top of your database (and
this is a reasonably idea, actually) you could write a wrapper library that
implemented file-system semantics on top of SQLite.
As a side
On Tue, 23 Apr 2013 10:28:35 -0400
Richard Hipp d...@sqlite.org wrote:
In summary: No, a bare SQLite blob does not provide file-system
semantics. But you can write a wrapper library around SQLite that
does provide file-system semantics for large blobs, and doing so
would have many
I have a table with a column of type BLOB, and I use a library that
exports or imports
its data structure writing or reading from a FILE*.
(see the bottom of this page:
http://gmplib.org/manual/I_002fO-of-Integers.html#I_002fO-of-Integers )
So my idea was creating a FILE* wrapper around
On 22 Apr 2013, at 12:39pm, Paolo Bolzoni wrote:
But I noticed that sqlite3_blob_write cannot increase the size of the pointed
open blob. So I ask, there is a way to treat a blob as a stream so I can write
or read values in it with ease?
Unfortunately the size (length) of the BLOB is very
It won't be as easy, but I guess I need to get the size of the gmp integer
before so to allocate the blob and later writing in it.
On Mon, Apr 22, 2013 at 2:10 PM, Simon Slavin slav...@bigfraud.org wrote:
On 22 Apr 2013, at 12:39pm, Paolo Bolzoni wrote:
But I noticed that sqlite3_blob_write
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 22/04/13 04:39, Paolo Bolzoni wrote:
But I noticed that sqlite3_blob_write cannot increase the size of the
pointed open blob. So I ask, there is a way to treat a blob as a stream
so I can write or read values in it with ease?
This is discussed
18 matches
Mail list logo