Re: [sqlite] SQLite DB backups on Windows

> What we're thinking of doing is pushing the PENDING_BYTE from the first > byte past the 1GB boundary to somewhere deep in the 64-bit range (such > as perhaps the 1TB boundary). We would have to update many lock and > unlock calls in os_win.c to do so, mainly adding a high-order 32-bit >

Re: [sqlite] Resources for newbies.

You addressed Dwight's example, but not his question -- which is whether there is a resource for answering questions like this. dave nelson On Fri, Aug 1, 2008 at 6:55 PM, Rich Shepard <[EMAIL PROTECTED]>wrote: > On Fri, 1 Aug 2008, Dwight Ingersoll wrote: > > > SQLite specific. For example,

Re: [sqlite] Finding similar duplicates

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Brandon, Nicholas (UK) wrote: > I have a table with first_name and a last_name column. I would like to > find similar duplicates BTW there exists a whole algorithm for doing this with part influenced by the medical industry (matching patient records)

Re: [sqlite] Resources for newbies.

On Fri, 1 Aug 2008, Dwight Ingersoll wrote: > SQLite specific. For example, when/why would one choose to attach database > files over having the scheme reside in one database file, performance > considerations when databases are attached vs. single file databases. Dwight, SQLite is designed

Re: [sqlite] Resources for newbies.

On Fri, Aug 1, 2008 at 4:03 PM, Rich Shepard <[EMAIL PROTECTED]>wrote: > On Fri, 1 Aug 2008, Dwight Ingersoll wrote: > > > I have a slew of newbie type questions, ... > > Er, what sort of questions? SQL, specific to SQLite, or something else? > > Rich > SQLite specific. For example, when/why

Re: [sqlite] Resources for newbies.

i am in the same situation simple questions for example, i postyed this earlier today: Getting "logic error or bad data" when using largw data strings: I create the database as follows: create table Event( Key TEXT[unique], DateTime DATE, Event TEXT, PRIMARY KEY (Key) ) I add

Re: [sqlite] Resources for newbies.

On Fri, 1 Aug 2008, Dwight Ingersoll wrote: > I have a slew of newbie type questions, ... Er, what sort of questions? SQL, specific to SQLite, or something else? Rich -- Richard B. Shepard, Ph.D. | IntegrityCredibility Applied Ecosystem Services, Inc.|

Re: [sqlite] SQLite DB backups on Windows

On Aug 1, 2008, at 3:14 PM, Arun Bhalla wrote: > Hi there, > > We are performing backups of the SQLite DB file by opening an > IMMEDIATE > transaction and then copying the file. (cf. > , >

Re: [sqlite] SQLite DB backups on Windows

I forgot to mention that we're using SQLite 3.5.9. Arun Arun Bhalla wrote: > Hi there, > > We are performing backups of the SQLite DB file by opening an IMMEDIATE > transaction and then copying the file. (cf. > , >

[sqlite] SQLite DB backups on Windows

Hi there, We are performing backups of the SQLite DB file by opening an IMMEDIATE transaction and then copying the file. (cf. , ) On Windows we use CopyFileA

[sqlite] Resources for newbies.

I have a slew of newbie type questions, and was wondering if there were other resources (preferably searchable) I could go look at before I start asking here. I'm pretty sure my questions are of the sort that makes people roll their eyes thinking "if I see that question one more time" I'd

Re: [sqlite] More on ICU extension (windows)

On Friday 01 August 2008 19:59:16 Alexey Pechnikov wrote: > Hello! > > > And how about SQLite+ICU compilation? Is it work for you? Not yet, but I will try to solve the problems myself before asking for more help. > > > > In configure.in > > I'm sorry, in Makefile.in, of cource I was about to

Re: [sqlite] More on ICU extension (windows)

I don't think the sqlite3.exe command-line tool converts its input strings to utf8 before parsing them. I think its because non-Windows platforms have utf8 console sessions, and Windows consoles use the default Windows codepage. So when you're inserting from the console, you're inserting

Re: [sqlite] More on ICU extension (windows)

Hello! > > And how about SQLite+ICU compilation? Is it work for you? > > In configure.in I'm sorry, in Makefile.in, of cource. > > TCC += -DSQLITE_ENABLE_ICU=1 `icu-config --ldflags` > LIBOBJ += icu.lo > > icu.lo:   $(TOP)/ext/icu/icu.c $(HDR) >   $(LTCOMPILE) -c $(TOP)/ext/icu/icu.c >

Re: [sqlite] Default Column Values

On Aug 1, 2008, at 7:32 AM, DG wrote: > I am using SQLite 3.6.0 under Windows. I created a table using the > following schema: > > CREATE TABLE CurrentValues ( > Time_Stamp DATETIME DEFAULT CURRENT_TIMESTAMP, > Sensor_ID WORD DEFAULT 1 NOT NULL, > Sensor_Name VARCHAR(20), > Sensor_Type

Re: [sqlite] More on ICU extension (windows)

Hello! В сообщении от Friday 01 August 2008 15:49:40 Graeme написал(а): > On Friday 01 August 2008 16:45:54 Alexey Pechnikov wrote: > > Hello! > > > > В сообщении от Friday 01 August 2008 14:49:04 Alexey Pechnikov написал(а): > > > Try this > > >

Re: [sqlite] Error on loading ICU extension

On Friday 01 August 2008 13:21:08 Alexey Pechnikov wrote: > Hello! > > В сообщении от Friday 01 August 2008 11:41:54 Mihai Limbasan написал(а): > > What does > > > > ldd /path/to/your/compiled/libSqliteIcu.so > > > > report? > > On linux debian for workable libSqliteIcu.so: > > $ ldd

Re: [sqlite] More on ICU extension (windows)

On Friday 01 August 2008 16:45:54 Alexey Pechnikov wrote: > Hello! > > В сообщении от Friday 01 August 2008 14:49:04 Alexey Pechnikov написал(а): > > Try this > > http://dload.mobigroup.ru/sqlite-ext/icu/3.5.9/libSqliteIcu.dll --snip-- > sqlite> SELECT load_extension('libSqliteIcu.dll'); > SQL

[sqlite] Default Column Values

I am using SQLite 3.6.0 under Windows. I created a table using the following schema: CREATE TABLE CurrentValues ( Time_Stamp DATETIME DEFAULT CURRENT_TIMESTAMP, Sensor_ID WORD DEFAULT 1 NOT NULL, Sensor_Name VARCHAR(20), Sensor_Type VARCHAR(8), Sensor_Value FLOAT DEFAULT 0 NOT NULL,

Re: [sqlite] More on ICU extension (windows)

Hello! В сообщении от Friday 01 August 2008 14:49:04 Alexey Pechnikov написал(а): > Try this > http://dload.mobigroup.ru/sqlite-ext/icu/3.5.9/libSqliteIcu.dll sqlite3 :memory: SQLite version 3.5.9 Enter ".help" for instructions sqlite> SELECT load_extension('libSqliteIcu.dll'); SQL error: error

Re: [sqlite] sqlite + .net cf

Tom Lancaster wrote: > > i'm considering using sqlite as a replacement for sql server ce in a > mobile device that periodically syncs with a web server. It's the right thing to do. I did it and everything's working just fine! > I wish to use sqlite because I will be able to assemble the whole

Re: [sqlite] More on ICU extension (windows)

Hello! В сообщении от Friday 01 August 2008 14:05:09 Christophe Leske написал(а): > Graeme schrieb: > > I apparently successfully compiled the ICU extension with: > > Has anyone sucessfully compiled the ICU extension for Windows (XP)? If > so, i would be very interested in the steps, thank you. >

[sqlite] More on ICU extension (windows)

Graeme schrieb: > I apparently successfully compiled the ICU extension with: > Has anyone sucessfully compiled the ICU extension for Windows (XP)? If so, i would be very interested in the steps, thank you. Also, isn´t it that the command line interpreter for windows (the one offered at the

Re: [sqlite] Error on loading ICU extension

On Friday 01 August 2008 13:21:08 Alexey Pechnikov wrote: > Hello! > > В сообщении от Friday 01 August 2008 11:41:54 Mihai Limbasan написал(а): > > What does > > > > ldd /path/to/your/compiled/libSqliteIcu.so > > > > report? > > On linux debian for workable libSqliteIcu.so: > > $ ldd

Re: [sqlite] Error on loading ICU extension

Hello! В сообщении от Friday 01 August 2008 11:41:54 Mihai Limbasan написал(а): > What does > > ldd /path/to/your/compiled/libSqliteIcu.so > > report? On linux debian for workable libSqliteIcu.so: $ ldd libSqliteIcu.so linux-gate.so.1 => (0xe000) libm.so.6 =>

Re: [sqlite] Error on loading ICU extension

What does ldd /path/to/your/compiled/libSqliteIcu.so report? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error on loading ICU extension

On Friday 01 August 2008 12:48:49 Alexey Pechnikov wrote: > Hello! > > В сообщении от Friday 01 August 2008 11:10:45 Graeme написал(а): > > > Try to install before > > > libicu-dev > > > libicu38 > > > > Thanks Alexey. I have both those installed. I assume you did not change > > anything else to

Re: [sqlite] Error on loading ICU extension

Hello! В сообщении от Friday 01 August 2008 11:10:45 Graeme написал(а): > > Try to install before > > libicu-dev > > libicu38 > > Thanks Alexey. I have both those installed. I assume you did not change > anything else to get it to work? No problem in code. Problem with dependencies. $

Re: [sqlite] Error on loading ICU extension

On Friday 01 August 2008 11:57:17 Alexey Pechnikov wrote: > Hello! > > В сообщении от Friday 01 August 2008 00:49:56 Graeme написал(а): > > I apparently successfully compiled the ICU extension with: > > > > gcc -shared icu.c `icu-config --ldflags` -o libSqliteIcu.so > > > > but when I try to load

Re: [sqlite] Error on loading ICU extension

Hello! В сообщении от Friday 01 August 2008 00:49:56 Graeme написал(а): > I apparently successfully compiled the ICU extension with: > > gcc -shared icu.c `icu-config --ldflags` -o libSqliteIcu.so > > but when I try to load it like this (using the TCL API, linux binary from > the site): > > load