Re: [sqlite] BLOB read/write in chunks?

Thanks. If I try to break these 200MB files into smaller chunks myself and insert the pieces into individual rows are there any recommendations as to a row size (10K, 64K, 1MB...)? and do I need to make any *.h constant file changes to indicate that I want to work with larger row sizes (or

Re: [sqlite] DEFAULT datetime

In version 2 you have to do that with a trigger. Versions 3.1 and onwards have "DEFAULT CURRENT_TIME" and friends. http://www.sqlite.org/lang_createtable.html Dan. --- Gabor Szabo <[EMAIL PROTECTED]> wrote: > Is it possible to set datetime('now') as the default value of a field ? > >

Re: [sqlite] DEFAULT datetime

On 5/5/05, Dan Kennedy <[EMAIL PROTECTED]> wrote: > In version 2 you have to do that with a trigger. Versions 3.1 and > onwards have "DEFAULT CURRENT_TIME" and friends. > > http://www.sqlite.org/lang_createtable.html thanks, this is great. ... and sorry for the duplicate e-mail. Gabor

Re: [sqlite] BLOB read/write in chunks?

Ran across this this morning ... removed in 3.0 (10) Are there any known size limits to SQLite databases? As of version 2.7.4, SQLite can handle databases up to 241 bytes (2 terabytes) in size on both Windows and Unix. Older version of SQLite were limited to databases of 231 bytes (2

Re: [sqlite] Follow up question about security

On 5/5/05, Dong Xuezhang-A19583 <[EMAIL PROTECTED]> wrote: > I understand that I got to encrypt and decrypt it, but what happened for the > indexed column? If I have a collate column at Chinese PINYIN, after you > encrypt it, the sorting method will be broken, so is there any encrypt >

RE: [sqlite] Follow up question about security

On Thu, 2005-05-05 at 10:38 -0700, Dong Xuezhang-A19583 wrote: > I understand that I got to encrypt and decrypt it, but what happened > for the indexed column? If I have a collate column at Chinese PINYIN, > after you encrypt it, the sorting method will be broken, so is there > any encrypt

[sqlite] PRAGMA page_size problems

This is related to a posting and also bug report (ticket 1230, I since closed) from last week. First: HPUX 11.11 64bit rp4440 server, 6 CPUs, 8 gig of RAM, tcl 8.4.9, sqlite 3.2.1 I was having problems inserting into a :memory: database using tclsqlite last week. First I create a table, then

[sqlite] Original Conf

Quick question I need answered to send to the sysadmin but do I need to both download and install sqlite and also use the DBD::SQLite module when coding in perl?? I think this is true, but he is under the impression I only need the perl DBD module and he is usually correct. --Leander

Re: [sqlite] PRAGMA page_size problems

> I was having problems inserting into a :memory: database using tclsqlite last > week. > First I create a table, then start doing inserts. > > At about record 2400, I was getting a "Bus error(coredump)". As a SWAG: The last time I had a buserror coredump on a machine like that it was cured by

Re: [sqlite] Original Conf

DBD::SQLite is self contained. if you want to run queries from the command line, like to test stuff. you will need the sqlite download. I like to build both from the same sqlite sources so the versions are identical. Quoting Leander Gillard <[EMAIL PROTECTED]>: > Quick question I need

Re: [sqlite] Original Conf

you only need DBD::SQLite it is self contained Quoting Leander Gillard <[EMAIL PROTECTED]>: > Quick question I need answered to send to the sysadmin but do I need to both > > download and install sqlite and also use the DBD::SQLite module when coding > in perl?? > > I think this is true,

Re: [sqlite] Error while loading shared libraries: libsqlite.so.0

Leander Gillard wrote: Sorry to ask such a newb question but shouldn't I have to use a uname and pwd to acces the sqlite db, if not, how should I protect it ? Leander From whom? Does your OS allow setting read and write permissions? Anything else is roll-your-own. Gerry

[sqlite] Valgrind errors

I get a huge amount of valgrind errors when using the SQLite library. Is there something I'm missing in my app that would cause all these errors? Just a sample: ==3614== Thread 8: ==3614== Conditional jump or move depends on uninitialised value(s) ==3614==at 0x1B904700: memcpy

[sqlite] OT: Prechecking SQL

I know sqlite will parse an SQL statement with running it, reporting any errors. Is there an ODBC way of doing this? I anticipate some users of my app replacing the SQLite back end with a different (ODBC) database system, and I would like to check unknown SQL out before I release it to the

[sqlite] Re: OT: Prechecking SQL

Sigh. Amazing what the lack of an 'out' will do to a sentence: >I know sqlite will parse an SQL statement with running it, reporting > any errors. That should be: I know sqlite will parse an SQL statement without running it, reporting any errors. On 5/5/05, Keith Herold <[EMAIL PROTECTED]>

[sqlite] Is threading enabled?

Hi, How can i find out at runtime (or when compiling my application) whether threading is enabled in sqlite? I scanned the source code and there seems no easy way to find out. -- Wolfgang