No I'm not. Thanks for pointing this out, Tom
Good god. Its there, under Terminal!
On 06/05/2008, at 4:22 PM, BareFeet wrote:
> Hi Stephen,
>
>> I'm a recent (4 days) convert from XP to Mac OS Leopard. What a
>> great system
>
> Welcome aboard :-)
>
>> I've downloaded latest SQLite3 for Mac b
Hi Stephen,
> I'm a recent (4 days) convert from XP to Mac OS Leopard. What a
> great system
Welcome aboard :-)
> I've downloaded latest SQLite3 for Mac but it came as .bin not .dmg.
Are you aware that SQLite is already installed in Mac OS X (SQLite
version 3.4 in Leopard)?
Tom
BareFeet
C
On 5/6/08, Stephen Tucker <[EMAIL PROTECTED]> wrote:
> I'm a recent (4 days) convert from XP to Mac OS Leopard. What a great
> system
>
> I've downloaded latest SQLite3 for Mac but it came as .bin not .dmg.
> Can someone tell me how to install this? Run from "Terminal"?
>
> Apol if this is a st
I'm a recent (4 days) convert from XP to Mac OS Leopard. What a great
system
I've downloaded latest SQLite3 for Mac but it came as .bin not .dmg.
Can someone tell me how to install this? Run from "Terminal"?
Apol if this is a stupid question
___
sq
On 5 May 2008 at 11:50, D. Richard Hipp wrote:
> Looking at the code, I do not see why this fails, assuming you have
> large-file support turned on (which you seem to have, and it is the
> default, after all.) The ".import" code does fopen() then fgets() to
> read the file. Does fopen() no
Hi,
> The make ends with the message:
> *** Error code 1
> make: Fatal error: Command failed for target `libsqlite3.la'
This is not a significant error message. The important messages are before
this one.
> Has anybody an idea, what the problem can be and how I can solve it?
It's hard to tell
I have a question about the new PRAGMA journal_mode:
Since PERSIST is likely to be faster than DELETE on
most platforms, is there ever a reason *not* to use
it?
Put differently, is there any advantage to DELETE
over PERSIST?
- Richard Klein
___
sqlite-
Just thinking again about indexing strategies on virtual tables, I'm wondering
why virtual tables could not be indexed using the "normal" SQLite command
"INDEX". Indeed, I just expected that the data inside the column of the virtual
table could be sequentially scanned (using the "xColumn" callb
On Mon, May 5, 2008 at 4:05 AM, Dan <[EMAIL PROTECTED]> wrote:
> On May 5, 2008, at 1:59 PM, John Passaniti wrote:
> > I am trying to decide if sqlite is appropriate for my system.
> > [...]
>
> Use transactions if you did not already plan to.
Yes, thanks. In the simplest case, I would be wri
You must use || (doble pipe) to concatenate strings or what ever.
Note that || don't concatenate nulls
'CHE' || null
is
null
sorry about my poor english
Joanne Pham escribió:
> Hi All,
> I had the table, appMapTable as defined below:
> appId, appName, appType
> 1, appname, 2
> 2, appname, 3
> .
Hi All,
I had the table, appMapTable as defined below:
appId, appName, appType
1, appname, 2
2, appname, 3
appName always has string as appname and now I want to concatenate the appName
with appId
so the result will be:
1,appname1,2
2, appname2,3
.
I ran the following sql statement :
upda
Hi Fred,
I agree with you but I think that a specific rule could be added in the parser
in order to deal with an identifier containing dots only when it is used after
a "using" in a "create virtual table" statement... Am I wrong?
Anyway, this is not a very big issue :-)
Aladdin
> Date: Mon, 5
On May 5, 2008, at 11:37 AM, Michael Lackhoff wrote:
> Hello,
>
> thanks to the flexibility of sqlite I can use a sybase database dump
> as
> a source for import into my database. Only problem: the file to import
> is over 2GB and I get a "file not found" error. The file is there, it
> can be r
Hello,
thanks to the flexibility of sqlite I can use a sybase database dump as
a source for import into my database. Only problem: the file to import
is over 2GB and I get a "file not found" error. The file is there, it
can be read by split and imported after the split and the resultung
sqlite
[EMAIL PROTECTED] wrote:
> I use a c++ program to
> open a connection to my database with no issues, but when trying to
> exec any sql statements after that, i get SQLITE_BUSY (i.e. database
> is locked).
>
> Even if I change the sql statement, I always get SQLITE_BUSY. This is
> frustrat
Don't think that will happen. "Dot" notation is used as in
"databasename.tablename" and is therefore a restricted use notation.
Fred
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Aladdin Lampe
Sent: Monday, May 05, 2008 8:57 AM
To: sqlite-users@sqlite.org
Hi list!
I've just finished a set of sqlite3 virtual tables and I would like to name
them with a "dot notation", ie "data.source1", "data.source2" created like that:
sqlite3_create_module(db, "data.source1", &dataModule1, 0);
sqlite3_create_module(db, "data.source2", &dataModule2, 0);
... and t
Hi!
SQL Maestro Group announces the release of SQLite Data Wizard 8.4, a
powerful Windows GUI solution for SQLite data management.
http://www.sqlmaestro.com/products/sqlite/datawizard/
SQLite Data Wizard provides you with a number of easy-to-use wizards to
generate PHP and ASP.NET scripts for th
I try to install sqlite3 on my sun solaris 2.10 machine.
I use the amalgamation (3.5.8), run configure and then call make.
The make ends with the message:
*** Error code 1
make: Fatal error: Command failed for target `libsqlite3.la'
Has anybody an idea, what the problem can be and how I can solv
On May 5, 2008, at 1:59 PM, John Passaniti wrote:
> I am trying to decide if sqlite is appropriate for my system.
>
> The target is an embedded system. It's an ARM9 processor running
> under Linux 2.6. The system's primary storage is NAND flash, using
> jffs2. The system is essentially a datal
Hi,
Without knowing the details of sqlite implementation on indexing, I
would imagine if you do some benchmarking runs,
and collect systrace like log, and see if # of writes and reads are
exceeding you requirement.
Regards,
- Kun
On Sun, May 4, 2008 at 11:59 PM, John Passaniti
<[EMAIL PROTECTED
I am trying to decide if sqlite is appropriate for my system.
The target is an embedded system. It's an ARM9 processor running
under Linux 2.6. The system's primary storage is NAND flash, using
jffs2. The system is essentially a datalogger, where at regular
intervals (typically once per minute)
22 matches
Mail list logo