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.
In
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]
[mai
Hi RBS!
If I understood you correctly you need a tool to transform these data
just once?
So there is a pseudocode describing one of possible approaches. To
convenient transformation SQLite is not enough for me, I suggest to use
any script language like Lua, Ptython, etc.
1) With a statement
SELEC
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( "%m"
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 eve
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 PM
ight, 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 ot
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 databa
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-
F
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 b
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 you
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
> ot
12 matches
Mail list logo