On 3/19/09 11:07 AM, erfon haubenstock m...@erfon.com wrote:
Hello Jean-Denis! I did it manually in terminal. I'm not familiar with
macports or finks.
Here's the exact code i used:
$ curl http://www.sqlite.org/sqlite-3.6.11.tar.gz | tar zx
$ cd sqlite-3.6.11
$ ./configure
On Thu, 19 Mar 2009 03:39:11 +0200, Tristan Seligmann
mithra...@mithrandi.net wrote:
Divmod Axiom[1] is a Python ORM built on SQLite; one of the book
keeping tables it creates in the database has a column named
indexed, which became a reserved word around SQLite 3.6.4 (?). The
obvious fix for
On 3/19/09 10:28 AM, erfon haubenstock m...@erfon.com wrote:
This is really strange. I'm using a mac with leopard which comes with
version 3.4.0 installed. I've installed 3.6.11, and it installs
successfully as far as I can tell, but then when I check the version with
sqlite3 --version in
On Thu, 19 Mar 2009 02:54:34 -0700 (PDT), baxy77bax
b...@hi.htnet.hr wrote:
hi my question is : if i create table that contains primary key like;
create table TEST (field1 varchar not null primary key);
do i need to create index on it or not?
No, the primary key implies an index will be
Hello Jean-Denis! I did it manually in terminal. I'm not familiar with
macports or finks.
Here's the exact code i used:
$ curl http://www.sqlite.org/sqlite-3.6.11.tar.gz | tar zx
$ cd sqlite-3.6.11
$ ./configure --prefix=/usr/local
$ make
$ sudo make install
thank you :-)
erfon
Any available free SQLite Database Comparer/Diff Tool?
Thanks,
Ev
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hello,
I’m hoping that someone will be able to assist me in figuring out why Firefox
consistently fails to operate properly for our Macintosh users here at St.
Cloud State University. I’ve created a bug report with bugzilla, but am now
being referred to your organization. The bug report # is
Hi,.
baxy77bax schrieb:
hi my question is : if i create table that contains primary key like;
create table TEST (field1 varchar not null primary key);
do i need to create index on it or not?
Yes, the primary key is indexed
and is it better to create table with a primary key and then
On 3/19/09 12:20 PM, erfon haubenstock m...@erfon.com wrote:
EEESH, i installed macports and when i try to port install i get an error
that says the error port: command not found
maybe this has something to do with it? my
On Mar 18, 2009, at 4:18 PM, Lessinger, Robert A. wrote:
Hello,
I’m hoping that someone will be able to assist me in figuring out
why Firefox consistently fails to operate properly for our Macintosh
users here at St. Cloud State University. I’ve created a bug report
with bugzilla,
EEESH, i installed macports and when i try to port install i get an error
that says the error port: command not found
maybe this has something to do with it? my
$PATH=usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin
Jean-Denis
This is really strange. I'm using a mac with leopard which comes with
version 3.4.0 installed. I've installed 3.6.11, and it installs
successfully as far as I can tell, but then when I check the version with
sqlite3 --version in terminal, the version is shows that the installed
version is STILL
In the first query the (select id from tbl2 where name='Joe') is referred to as
a SUBQUERY.
The second query is uses a JOIN because you are joining together data from
different rows.
-Jeff
-Original Message-
From: sqlite-users-boun...@sqlite.org
On Thu, 19 Mar 2009 19:06:52 +0800, Ev
eversog...@gmail.com wrote:
Any available free SQLite Database Comparer/Diff Tool?
At least one tool is listed on
http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
And of course you can diff a dump:
# sqlite3 test_38.db3 .dump t38
# sqlite3 test_41.db3
:-D
one more question :
if i create primary key on my table and then import the data (assuming i
used transactions) will my import be faster or slower vs the case where i
import the data first and then create key (foreign key ??) and index the
table.
the point is that i need my import to be
:-D
one more question :
if i create primary key on my table and then import the data (assuming i
used transactions) will my import be faster or slower vs the case where i
import the data first and then create key (foreign key ??) and index the
table.
the point is that i need my import to be
On Mar 19, 2009, at 9:38 AM, baxy77bax wrote:
:-D
one more question :
if i create primary key on my table and then import the data
(assuming i
used transactions) will my import be faster or slower vs the case
where i
import the data first and then create key (foreign key ??) and
nop no i ment up to 50 MB an these are tough to import(i just wanted to
mention that because on these records import is slownig down and it is not
so fast any more example if i import one set of data that is small and the
other that is large the overall time is T1= t1 +t2 but if i mix those
It is not an open source project but you are welcome to access to the
source code.and notes.
The intent of the project is to provide a highly efficient application
server for AJAX support of browser-based IT networks. To that end the
design criteria were:
o Minimize process and thread
On Thu, 19 Mar 2009 06:38:33 -0700 (PDT), baxy77bax
b...@hi.htnet.hr wrote:
:-D
one more question :
if i create primary key on my table and then import the data (assuming i
used transactions) will my import be faster or slower vs the case where i
import the data first and then create key
Roger:
1. Sorry, I don’t want to screw up somebody with my post
2. It was not my proposal
3. Thank you for the information that I may program/implement whatever I want
4. Your comments sound to me that you are living in a 7bit ASCII country, do
you?
George
-Ursprüngliche Nachricht-
Hello,
I'm beginner and uses sqlite3.
I'm trying to record informations in a database, but this fails.
I have followed http://www.sqlite.org/c3ref/stmt.html
rc = sqlite3_open(DB_FILENAME, metadata_db);
rc = sqlite3_exec(metadata_db,
CREATE TABLE IF NOT EXISTS metadata
is autocommit on?
try adding a manual commit.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Olivier FAURAX
Sent: Thursday, March 19, 2009 10:56 AM
To: General Discussion of SQLite Database
Subject: [sqlite] What am I doing
Hello all,
I'm working on a GUI application using Tcl/Tk with sqlite back end on windows.
Now, multiple users will be running this and all users must have a copy of the
db local to their PC or in a shared drive. At least that is my understanding of
how sqlite works.
1. What are my options
Olivier FAURAX ofau...@neotion.com wrote:
I'm beginner and uses sqlite3.
I'm trying to record informations in a database, but this fails.
I have followed http://www.sqlite.org/c3ref/stmt.html
rc = sqlite3_open(DB_FILENAME, metadata_db);
rc = sqlite3_exec(metadata_db,
CREATE
I've been reading and thinking about this topic for a while, and would like to
add my thoughts.
I realize that we don't vote on features, but I feel that this type of idea
has merit.
It is true, that SQLite has user defined collations, and a extension could be
registered, but the problem with
Greetings...
I am updating an sqlite db from another sqlite db and it is working fine,
unless the record does not exists. ie.
ATTACH db2 AS client; ;
BEGIN;
INSERT OR REPLACE INTO LSOpenJobs
SELECT * FROM client.LSOpenJobs
WHERE login='x' AND XtraB '2000';
Noah Hart n...@lipmantpa.com wrote:
Number 2, your platform may not support the sqlite3_create_collation
interface. For example, Firefox now includes SQLite. Unfortunately,
while Firefox supports user defined functions, their implementation
does not support user defined collations.
Someone
jose isaias cabrera cabr...@wrc.xerox.com
wrote:
I am updating an sqlite db from another sqlite db and it is working
fine, unless the record does not exists. ie.
ATTACH db2 AS client; ;
BEGIN;
INSERT OR REPLACE INTO LSOpenJobs
SELECT * FROM client.LSOpenJobs
On Thu, Mar 19, 2009 at 12:01 PM, jose isaias cabrera
cabr...@wrc.xerox.com wrote:
Greetings...
I am updating an sqlite db from another sqlite db and it is working fine,
unless the record does not exists. ie.
ATTACH db2 AS client; ;
BEGIN;
INSERT OR REPLACE INTO LSOpenJobs
Igor Tandetnik writes:
This is not quite true. You say custom functions are supported: then you can
do ORDER BY sortkey(textField), with a suitably defined sortkey() function
(see strxfrm, LCMapString). You can't however build indexes using such a
function, something you can do with a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mail.sqlite wrote:
4. Your comments sound to me that you are living in a 7bit ASCII country, do
you?
I am British but currently happen to live in the US, and have lived in
every hemisphere whether you cut the earth horizontally or vertically.
My
On Thu, Mar 19, 2009 at 09:52:55AM -0700, Noah Hart wrote:
I've been reading and thinking about this topic for a while, and would
like to add my thoughts.
I realize that we don't vote on features, but I feel that this type
of idea has merit.
It is true, that SQLite has user defined
On Thu, 19 Mar 2009 08:14:52 -0700 (PDT), anjela patnaik
anjela_...@yahoo.com wrote:
Hello all,
I'm working on a GUI application using Tcl/Tk with
sqlite back end on windows. Now, multiple users will be
running this and all users must have a copy of the db
local to their PC or in a shared
Nico wrote:
Number 1, the database is no longer portable. The only solution to
this is to include the functionality in the core.
Yes but, there is no single Unicode collation. Collation is
language-specific, even when using Unicode. Thus you're asking that
SQLite3 have a plethora of built-in
On Thu, Mar 19, 2009 at 12:31:00PM -0700, Noah Hart scratched on the wall:
Rather my point is that it would be of benefit if SQLite would have
some built in mechanism for a rule-based collation.
SQLite *does* have a mechanism for rule-based or any-other based
collations: User defined
Igor Tandetnik wrote...
jose isaias cabrera
wrote:
I am updating an sqlite db from another sqlite db and it is working
fine, unless the record does not exists. ie.
ATTACH db2 AS client; ;
BEGIN;
INSERT OR REPLACE INTO LSOpenJobs
SELECT * FROM client.LSOpenJobs
P Kishor wrote
On Thu, Mar 19, 2009 at 12:01 PM, jose isaias cabrera wrote:
Greetings...
I am updating an sqlite db from another sqlite db and it is working fine,
unless the record does not exists. ie.
ATTACH db2 AS client; ;
BEGIN;
INSERT OR REPLACE INTO LSOpenJobs
SELECT * FROM
Hi again. Thanks for trying to help me by the way : D
I tried relauching terminal and even restarting my computer, but to no
avail.
I'm not totally sure I understand when you say:
One common pitfall here is that you must open a new shell for the port
command to be recognised (or re-export the
On Thu, Mar 19, 2009 at 5:29 PM, erfon haubenstock m...@erfon.com wrote:
Hi again. Thanks for trying to help me by the way : D
I tried relauching terminal and even restarting my computer, but to no
avail.
I'm not totally sure I understand when you say:
One common pitfall here is that you
On Mar 19, 2009, at 4:29 PM, erfon haubenstock wrote:
Hi again. Thanks for trying to help me by the way : D
I tried relauching terminal and even restarting my computer, but to no
avail.
I'm not totally sure I understand when you say:
One common pitfall here is that you must open a new
Ok, we're getting somewhere now. I typed /usr/local/bin/sqlite3 -version and
got 3.6.11.
But when i typed sqlite3 --version i get 3.4.
So it must be a path issue. This is my first experience with PATH. I know
I need to change my path, but I don't know what is missing from it that is
giving
Thanks for pointing me to that piece of the guide. Copying the contents of
my .profile into my .bash_login fixed the port command problem i was having
: D
This is my first experience with paths, .profile, or .bash_login and
macports so this has all be quite a learning experience for me. I feel
ok so macports installed sqlite3 just fine, but how do i check the version?
i think i now have 3 versions of sqlite installed.
1 - when i type sqlite3 --version i get version 3.4.0
2 - when i type usr/local/bin/sqlite3 --version i get version 3.5.4
3 - I know that macports has installed
On Mar 19, 2009, at 5:19 PM, erfon haubenstock wrote:
ok so macports installed sqlite3 just fine, but how do i check the
version?
i think i now have 3 versions of sqlite installed.
1 - when i type sqlite3 --version i get version 3.4.0
2 - when i type usr/local/bin/sqlite3 --version i get
Hi,
I'm seeing a very strange, consistently reproducible case, in which
SQLITE_CORRUPT is being returned in response to a simple insert
statement. There is only one connection to the db so it is unlikely a
concurrency issue. The insert is immediately after the table is
created. The table
On Thu, Mar 19, 2009 at 6:19 PM, erfon haubenstock m...@erfon.com wrote:
ok so macports installed sqlite3 just fine, but how do i check the version?
i think i now have 3 versions of sqlite installed.
1 - when i type sqlite3 --version i get version 3.4.0
2 - when i type usr/local/bin/sqlite3
On Mar 19, 2009, at 8:33 PM, Kim, Albert wrote:
/* The maximum page number is 2^31. Return SQLITE_CORRUPT if a page
** number greater than this, or zero, is requested.
*/
if( pgnoPAGER_MAX_PGNO || pgno==0 || pgno==PAGER_MJ_PGNO(pPager) ){
return SQLITE_CORRUPT_BKPT;
Yeah, a religious question, i know, but what's recomended?...
I have a small site that may have some images for some products. Said
products may also have descriptions. I have other small sites and one
where i'd like to manipulate large texts (say around 5 paragraphs...
~5000 characters).
What's
Hi all,
Some of my users have been reporting strange database problems
recently, which seem to have gone away when I removed a call to
enable_shared_cache(). The problems were noticeable in at least 3.6.1
and 3.6.11, when using databases of 30MB+, and doing large updates
using pysqlite.
There
2009/3/19 Nuno Magalhães nunomagalh...@eu.ipp.pt:
Yeah, a religious question, i know, but what's recomended?...
I have a small site that may have some images for some products. Said
products may also have descriptions. I have other small sites and one
where i'd like to manipulate large texts
Unfortunately, a user has just reported the same primary key error
message with shared cache disabled, although the freezing appears to
have been fixed.
However, when I ask the user to send me their deck, I find that:
sqlite pragma integrity_check;
integrity_check
---
ok
sqlite
Ok, i think i figured it out, only took me about 8 hours!
see the path i had:
$PATH=usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:/usr/bin:/bin:/usr/sb
in:/sbin:/usr/local/bin:/usr/X11/bin
it's missing the / as the very beginning of the path. i changed it to
/usr/local... and now
53 matches
Mail list logo