Hi All,
I am using sqlite-amalgamation-3_7_3.zip source in my project.
I tested VACUUM command on a DB file which has lot of holes(fragmentation
caused by deletion of random records ) but the source file size does not
change. Instead sqlite applies the vaccum command and writes data into new
tempo
On February 15, 2011, Black, Michael (IS) wrote:
> I'll give you another failure point that most people never see or think of.
>
> I used to manage numerous Linux systems with RAID-5. One time I had a
> drive fail, the spare kicked in, and then during the rebuild a 2nd drive
> failed...hosing the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/22/2011 07:17 PM, Phil Oertel wrote:
> Sorry for being unclear, I'm referring to the ability to emulate
> oracle-specific features and syntax, like ROWNUM for example.
What else?
ROWNUM seems spectacularly useless! You should be able to use OF
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/22/2011 02:39 PM, Robert Hairgrove wrote:
> On Tue, 2011-02-22 at 08:46 -0800, Roger Binns wrote:
>> What you think you are seeing is not happening. The documentation is
>> correct.
>
> OK ... but what about that which the GDB debugger is seei
The suggestion apparently derives from comments in attach.c
For example:
http://gears.googlecode.com/svn/trunk/third_party/sqlite_google/src/attach.c
/*
** An SQL user-function registered to do the work of an ATTACH statement.
The
** three arguments to the function come directly from an attach sta
Sorry for being unclear, I'm referring to the ability to emulate
oracle-specific features and syntax, like ROWNUM for example.
On Feb 22, 2011 6:44 PM, "Pavel Ivanov" wrote:
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi
Could you please explain what is "Oracle compatibility mode"? And how
can anyone make an attempt to use it for SQLite if SQLite doesn't have
such feature?
Pavel
On Tue, Feb 22, 2011 at 9:28 PM, Phil Oertel wrote:
> Hi sqliters,
>
> After a recent failed attempt to use SQLite as an in-memory fak
On Mon, Feb 21, 2011 at 9:42 AM, Sam Carleton wrote:
> On Sun, Feb 20, 2011 at 4:11 PM, Scott Hess wrote:
>
>> You can also convert:
>> ATTACH DATABASE x AS y KEY z
>> to:
>> SELECT sqlite_attach(x, y, z)
>> where the parameters can be turned into bind arguments. Then embedded
>> quotes won't
Hi sqliters,
After a recent failed attempt to use SQLite as an in-memory fake Oracle for
some of my tests, I'm curious whether anyone has attempted an Oracle
compatibility mode for SQLite. H2 and others have this tremendously useful
feature, but there doesn't seem to be anything available for thos
On Tue, 2011-02-22 at 08:46 -0800, Roger Binns wrote:
> On 02/22/2011 05:29 AM, Robert Hairgrove wrote:
> > I'm trying to understand how the VFS implementation works.
>
> What you think you are seeing is not happening. The documentation is correct.
OK ... but what about that which the GDB debug
On Tue, Feb 22, 2011 at 9:07 AM, Philip Graham Willoughby
wrote:
>
> On 22 Feb 2011, at 15:41, Max Vlasov wrote:
> > The obvious solution is public-key cryptography. The question is about
> > different ways how it could be implemented with sqlite. The requirement for
> > this system is that it sho
Hi Tom,
if you do not have a command line tool in one of the software package you can
do two things:
1) try to create an FTS or RTree table. It will fail if the extensions are not
supported.
2) create a database having all to be tested extension and then issue a SELECT
* statement on the tab
I dont' know the details of the busy handler. Not clear to me that it should
sequentialize the requests.
Perhaps you're better off just using a flag that you could check between your
commit;begin so that if there's a request in the queue you go process it before
continuing.
commit;
if item_in
On Tue, Feb 22, 2011 at 7:07 PM, Philip Graham Willoughby <
phil.willoug...@strawberrycat.com> wrote:
> On 22 Feb 2011, at 15:41, Max Vlasov wrote:
> > The obvious solution is public-key cryptography. The question is about
> > different ways how it could be implemented with sqlite. The requirement
I wanted to thank Michael D. Black and Simon Slavin for replying to my
question. I was wondering how long the sqlite_busy_handler should sleep for
before SQLite tries to access the datbase again. Our chief engineer was
wondering whether the writing function could set an event when the writ
On Tue, 22 Feb 2011 10:16:20 +1100, BareFeetWare
wrote:
>On 22/02/2011, at 4:31 AM, skywind mailing lists wrote:
>
>> "Supports SQLite extension" would be an accurate feature description. And in
>> the cell (value) I suggest to put - if supported - FTS2, FTS3, RTree etc.,
>> otherwise a "-". A
Public-key encryption is not designed as a method to encrypt data, it is meant
as a means to prove a digital signature and to prevent man in the middle
attacks.
Web servers do use public keys but only to encrypt the symmetric key that is
used to encrypt the actual data traffic.
You will want t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/22/2011 05:29 AM, Robert Hairgrove wrote:
> I'm trying to understand how the VFS implementation works.
What you think you are seeing is not happening. The documentation is correct.
> However, if I open a database and inspect the VFS contained
On 22 Feb 2011, at 15:41, Max Vlasov wrote:
> The obvious solution is public-key cryptography. The question is about
> different ways how it could be implemented with sqlite. The requirement for
> this system is that it should operate in two modes:
> - insert-only when no reading operation is used.
Hi,
recently I was thinking about a system when logs about something are written
encrypted without interaction with the user, but for reading the contents
one would need the key.
The obvious solution is public-key cryptography. The question is about
different ways how it could be implemented with
I don't know what's the best value for chunk size. I'm not even sure
that it's useful to set it to any value at all. So let your test
results guide you. The only thought I have is the chunk size should be
a multiple of page size (don't know if SQLite's code rounds up to such
multiple internally).
What I meant is this:
Database size = 1 MB. When opening connection, set chunk to ~100 kB.
Database size = 100 MB. When opening connection, set chunk to ~10 MB.
Database size = 1 GB. When opening connection, set chunk to ~100 MB.
I guess SQLITE_FCNTL_CHUNK_SIZE should be a 2^n value, so this giv
On Tue, Feb 22, 2011 at 04:03:22PM +0100, Haldrup Office wrote:
> Hello list,
>
> I'm in the process of writing a little interface tool for notes and
> adress databases from an iPad.
>
> Using MS Word VBA and SQLite3_StdCall.dll.
> My query looks quite simply put:
> SELECT ROWID,creation_da
On 22 Feb 2011, at 3:03pm, Haldrup Office wrote:
> Using MS Word VBA and SQLite3_StdCall.dll.
> My query looks quite simply put:
> SELECT ROWID,creation_date,title FROM Note
>
> and it runs fine and returns w/o problems.
>
> When I iterate through it, though, and I try to read a long note (
Please reply to the list, not to me only.
It's impossible to set chunk size to percentage of the database size,
you can only set a constant value.
Pavel
On Tue, Feb 22, 2011 at 9:13 AM, Sven L wrote:
> Thanks a lot! :D
>
> What do you think of setting the chunk size to approximately 10% of the
Hello list,
I'm in the process of writing a little interface tool for notes and
adress databases from an iPad.
Using MS Word VBA and SQLite3_StdCall.dll.
My query looks quite simply put:
SELECT ROWID,creation_date,title FROM Note
and it runs fine and returns w/o problems.
When I iterate t
sqlite3_step can be called several times if your statement returns
some rows (like select statement). In this case each call of
sqlite3_step except last one will return SQLITE_ROW. Last call will
return SQLITE_DONE. And in case of any error sqlite3_step will return
SQLITE_ERROR or some extended err
Is SQLITE_FCNTL_CHUNK_SIZE what you are looking for? See more
information about it here:
http://www.sqlite.org/c3ref/c_fcntl_chunk_size.html. Notice that this
feature appeared only in recent version of SQLite, so if you have some
earlier version you won't be able to control it and SQLite will
grow/
I'm trying to understand how the VFS implementation works. If I fetch
the default VFS with sqlite3_vfs_find(NULL), these members:
xDlOpen
xDlError
xDlSym
xDlClose
all have non-NULL values. However, if I open a database and inspect the
VFS contained in the sqlite3*, these four members are
There are several problems:
1) You wrote to the wrong list. sqlite-dev is for those who develop
SQLite, sqlite-users is for those who develop using SQLite.
2) You didn't say what problem you have with that piece of code.
3) You didn't call sqlite3_step() after sqlite3_bind_text() to
actually execut
On Tue, Feb 22, 2011 at 5:22 AM, Benoit Mortgat wrote:
> Hello,
>
> I have come across a strange behaviour of SQLite 3.7.5.
>
> The following query:
>
> SELECT DISTINCT COALESCE(a.xxx, b.yyy) value
> FROM tbl1 a
> LEFT OUTER JOIN tbl2 b
>ON a.zzz = b.ttt
> EXCEPT
> SELECT DISTINCT ggg value
Can't seem to find a setting to control how the database file grows when full.
Is there such a setting?
It looks like the file increases by some < 100 kB when it is full. I want to
change this to around 10 MB (or even more) to avoid file fragmentation.
Any ideas?
Thanks
On Tue, Feb 22, 2011 at 5:22 AM, Benoit Mortgat wrote:
> I could send a samble database with full query to a developer if
> needed in order to reproduce that.
>
Please do send the sample database and the full queries.
--
D. Richard Hipp
d...@sqlite.org
_
Hello,
I have come across a strange behaviour of SQLite 3.7.5.
The following query:
SELECT DISTINCT COALESCE(a.xxx, b.yyy) value
FROM tbl1 a
LEFT OUTER JOIN tbl2 b
ON a.zzz = b.ttt
EXCEPT
SELECT DISTINCT ggg value
FROM tbl3;
will not return any results (which seems to be correct).
Ho
34 matches
Mail list logo