RE: [sqlite] Is sqlite the right db for me?

Hi Steve, as a possible alternative for Python you may take a look at Lua language. www.lua.org Here is also a few webserver platform such as Xavante. Web-pages looks as standard html pages with Lua code fragment (similar to ASP but simpler) Lua supports SQLite with nice library luasqlite.

RE: [sqlite] Transpose table

It's nice that problem was solved. JFYI. In common, task for creating sparse matrix from plain sql normalized table is very common for OLAP. Maybe you shall read something about it if these task arised from time to time. Best regards, Denis -Original Message- From: [EMAIL PROTECTED]

RE: [sqlite] Dealing with dates in the format yyyymmdd

Hi RBS! In my application I use following approach: It is a part of view to export csv data to Excel: CREATE VIEW v_export_data_std AS SELECT localnumber, remotenumber, sipuser, strftime( "%Y", timestart, 'unixepoch', 'localtime' ) AS year, strftime(

RE: [sqlite] SQLite error: Database is locked

Hi Rama! Unfortunatelly I haven't any experience with Linux. But I reproduce situation on my system (Win XP), and have noticed that after kiliing Process A files ~testDb.db3 ~testDb.db3-journal are usable for Process B. Process B just reuse file ~testDb.db3-journal file for own needs, and

RE: [sqlite] about temp table

Hello Sarah, First of all, to create TEMPorary table you shall use one of the following statements: create temp table myt(age smallint) or create table temp.myt(age smallint) WBR, Denis -Original Message- From: Sarah [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 1:31

RE: [sqlite] Very wide tables and performance

they are unreadable :-) Cheers Jose On 9/14/06, Denis Povshedny <[EMAIL PROTECTED]> wrote: > Hi Jose! > > It is really hard to believe that you do not have a sparse matrix. I > mean that for every single row: from 2 colums only a several > columns are used and others

RE: [sqlite] Very wide tables and performance

Hi Jose! It is really hard to believe that you do not have a sparse matrix. I mean that for every single row: from 2 colums only a several columns are used and others are nil. This is a point to perform so-called normalizations for the table. The single exception what I remember is OLAP

RE: [sqlite] building sqlite.lib

Hi Rick! The 'LIB' itself is a command for building library from command line. But if you are using VisualC++ IDE, enter these data as an linker's commandline option. It may be not easy to find out, so there's a screenshot from my computer. Please note I use MSVC 7.1 -Original Message-

RE: [sqlite] UPDATE reports SQL logic error or missing database

Hello Simon! Just for your information. I have often receive this error (SQL logic error or missing database) when some constraints failed or keys aren't unique. I use 3.3.4; earlier with version 3.2.8 I had correct responses for non-uniqueness failures. So I think when you update data there may

RE: [sqlite] Best way to compare two databases

Hi Juan! People give you a several advices about alternative solutions. But I try to get back to your original question ("¿how to do, in the best way, the new phase 2?") I suppose that database structure isn't changed and we're talking about tracking data differences only. I also suppose that

RE: [sqlite] Preferred way to copy/flush new memory db to disk db ?

Maybe you shall open in sqlite3_open a temporary file as a database file? And move it to destination in case of success WBR, Denis --- My requirements are > database file must be removed from disk if any error while > creating/copying tables, records or indices >