Hello,
When I add text to the database, it's getting truncated because
SQLite is converting it to a number. For example, I enter "9.0", but
SQLite stores it as "9".
Is there a way to force the value to be inserted as string?
Thanks,
-- Tito
Hi Tiago,
Unfortunately, I cannot always specify the column names. I wrote a
framework used by other developers, so I must honor whatever SQL
query they decide to execute.
I just hope to see a fix for this soon.
Thanks a lot for your answer,
-- Tito
On 20/05/2005, at 18:26, Tiago Dionizio
Hello Tim,
OK... so I'm not the only one!
I didn't know what else to try... does anyone have a workaround or
trick of some sort? Is this a known bug?
Thanks,
-- Tito
On 20/05/2005, at 14:24, Tim McDaniel wrote:
-Original Message-
From: Tito Ciuro [mailto:[EMAIL PROTECTED]
Sent: Friday
Hello Dr. Hipp,
On 19/05/2005, at 16:08, D. Richard Hipp wrote:
On Thu, 2005-05-19 at 15:58 -0400, Tito Ciuro wrote:
Hello everyone,
I just downloaded SQLite 3.2.1 to replace 3.1.2. My wrapper stopped
working iimediately. After checking why, I realized that
'full_column_names' is not working
Hello everyone,
I just downloaded SQLite 3.2.1 to replace 3.1.2. My wrapper stopped
working iimediately. After checking why, I realized that
'full_column_names' is not working. Looking through the archives
reveals other developers having the same issue.
Is it just me or is
Alessandro,
Take a few minutes to read the different wiki pages. There is a lot of
info there. Answering your question:
http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuning
Just scroll at the end of the page: Use transactions when updating
tables. Another reference:
On 6 ene 2005, at 18:01, aleks ponjavic wrote:
What I want to do is drop and add columns, couldn't find something
appropriate with sqlite, atleast it doesn't seem as ALTER TABLE works,
how can I do it instead?
Maybe it isn't possible?
Please check the archives. It's been discussed already:
On Friday, December 24, 2004, at 01:29AM, Will Leshner <[EMAIL PROTECTED]>
wrote:
>On Thu, 23 Dec 2004 19:08:05 -0500, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
>
>> (3) This would be a huge change that would require
>> a lot of code. Isn't it easier just to add
>>
Hello Steve,
Visiting the link I posted with my post would have answered your
question :-)
QuickLite is a Cocoa wrapper for SQLite.
-- Tito
On Dec 15, 2004, at 13:24, Steve Frierdich wrote:
What is QuickLite 1.5.3 ?
Tito Ciuro wrote:
Hello everybody,
I'm pleased to announce that QuickLite 1.5.3
Hi Jeff,
Works for me...
By the way, SquidSQL crashed with my data:
Date/Time: 2004-12-15 10:10:16 +0100
OS Version: 10.3.6 (Build 7R28)
Report Version: 2
Command: SquidSQL
Thread 0 Crashed:
0 libSystem.B.dylib 0x90006e40 strlen + 0x20
1 com.apple.CoreFoundation
Hello everybody,
I'm pleased to announce that QuickLite 1.5.3 is now available.
What’s New in this Version
--
- In-cursor data matching
- Set operations on cursors: union, minus and intersection
- Support for attached databases
- More convenience methods in all 3 classes
-
Hello Dr. Hipp,
On Nov 20, 2004, at 02:36, D. Richard Hipp wrote:
To be honest, I'm not sure the test suite checks the case where you
explicitly declare ROWID INTEGER PRIMARY KEY. But I did just try this
myself and I cannot seem to reproduce the problem. Can anybody else
get it to fail?
It's a
On Nov 20, 2004, at 02:14, Darren Duncan wrote:
At 1:59 AM +0100 11/20/04, Tito Ciuro wrote:
When I create an 'address' table, I pass this string to SQLite:
1) CREATE TABLE address(ROWID INTEGER PRIMARY KEY,First
QLString,Last QLString,ZIP QLString,Country QLString);
And SQLite returns a series
Hello Paolo,
On Nov 19, 2004, at 10:24, P. Morandi wrote:
Hi everybody.
After using VACUUM on a sqlite db, the first time I try to do an
INSERT in a table
(always the same table) I get the "DATABASE SCHEMA HAS CHANGED" error,
but later
queries have no problems, only the first one.
If I don't
Hello,
The link to the 'precomp_test.c' file seems to be broken:
http://cvs.hwaci.com/sqlite/attach_get?id=58,precomp_test.c
Does someone have this file?
Thanks,
-- Tito
Hello Didier,
Check: http://www.hwaci.com/sw/sqlite/prosupport.html
The second paragraph in particular...
Regards,
-- Tito
On Nov 2, 2004, at 13:58, Didier BRETIN wrote:
Hello,
I'm new to SQLite, and I try to know if it is possible to crypt de
database file used by
SQLite. I try to find some
Hello Vladimir and Ulrik,
On Oct 28, 2004, at 01:01, Vladimir Vukicevic wrote:
You need to use "IS NULL" as opposed to "= NULL".
Thanks so much. Works like a charm :-)
Regards,
-- Tito
Hello,
I'd like to remove all rows with a specific column equaling NULL. I've
tried this:
SQLite version 3.0.8
Enter ".help" for instructions
sqlite> select * from address;
Ciuró|1|Javi||España
Garaicoechevarria|2|Ana||España
Ciuró|3|Tito||España
Miti|4|Sam||Italy
Schmuck|5|Joe||Germany
sqlite>
Thanks a lot Tiago!
-- Tito
On 23 oct 2004, at 23:30, Tiago Dionizio wrote:
I believe this is what you are looking for:
http://www.sqlite.org/lang.html#transaction
Tiago
On Sat, 23 Oct 2004 22:50:36 +0200, Tito Ciuro <[EMAIL PROTECTED]> wrote:
Hello,
Sorry to post the question again, but
Hello,
Sorry to post the question again, but after reading the "File Locking
And Concurrency In SQLite Version 3" page
(http://www.sqlite.org/lockingv3.html), I still haven't been able to
locate info on DEFERRED, IMMEDIATE, and EXCLUSIVE transactions. Could
someone please explain the
Thanks a lot Dr. Hipp.
Regards,
-- Tito
On 19 oct 2004, at 13:51, D. Richard Hipp wrote:
Tito Ciuro wrote:
Version 3.0.8 adds support for DEFERRED, IMMEDIATE, and EXCLUSIVE
transactions. Where can I find more info about that?
http://www.sqlite.org/lang.html#transaction
Hello,
Version 3.0.8 adds support for DEFERRED, IMMEDIATE, and EXCLUSIVE
transactions. Where can I find more info about that?
Thanks,
-- Tito
Hello,
The only reference I see about timezone support in SQLite is in this
example:
Compute the date and time given a unix timestamp 1092941466, and
compensate for your local timezone.
SELECT datetime(1092941466, 'unixepoch', 'localtime');
I found this here:
On Oct 7, 2004, at 16:00, Steve Frierdich wrote:
The same databases that are recognized and work in Sqlite version
2.8.15 are not recognized in Sqlite version 3.0.7. When the sqlite
function sqlite3_get_table is called using version 3.0.7 the result is
26 which is:
File opened that is not a
On Oct 6, 2004, at 08:38, Ken Cooper wrote:
Anyone else experiencing this?
Do you mean http://www.sqlite.org?
-- Tito
Hi Kirk,
On Oct 5, 2004, at 21:10, Kirk Haines wrote:
But is there a way to get the name of that field?
1) I obtain the SQL statement that generated the table in the first
place with something like this:
SELECT sql FROM sqlite_master WHERE tbl_name = 'test';
2) The above statement returns
Here are some relevant links:
http://www.sqlite.org/cvstrac/wiki?p=SqliteTools
-- Tito
On Sep 28, 2004, at 23:53, Tito Ciuro wrote:
Which platform are you interested in?
-- Tito
On Sep 29, 2004, at 00:54, Edgardo Rossetto wrote:
Anything like a visual manager for sqlite dbs?
or just the command
Which platform are you interested in?
-- Tito
On Sep 29, 2004, at 00:54, Edgardo Rossetto wrote:
Anything like a visual manager for sqlite dbs?
or just the command line tool?
Regards,
Edgardo
On Sep 19, 2004, at 09:46, EzTools Support wrote:
There was a definition for MAX_BYTES_PER_ROW. I cannot find it anymore
in 3.0.7. Is there still such a concept as maximum row size?
http://www.mail-archive.com/[EMAIL PROTECTED]/msg03325.html
-- Tito
On Sep 16, 2004, at 14:47, [EMAIL PROTECTED] wrote:
What do I have to do to make this faster? And reading? Please, give me
a
concrete answer with examples if possible...
http://www.sqlite.org/cvstrac/wiki?p=PerformanceConsiderations
-- Tito
Hello,
Is it safe to call sqlite3_finalize() even if sqlite3_prepare() has
returned an error? Or should I call sqlite3_finalize() only when
sqlite3_prepare() has returned SQLITE_OK?
TIA,
-- Tito
Hello Matt,
On Sep 2, 2004, at 19:46, Matt Wilson wrote:
I would expect for sqlite3_busy_timeout(db, 3); to make the step()
on statement 2 wait 30 seconds before returning, but it returns
immediately.
I believe sqlite3_busy_timeout() is called whenever sqlite3_step()
returns SQLITE_BUSY. In
Hello everybody,
Today Webbo is releasing QuickLite 1.5 Beta, a Cocoa wrapper for
SQLite, the embeddable SQL database engine.
QuickLite already includes SQLite, so there's no need to download and
to configure. It provides the developer with a SQL database without
running a separate RDBMS
I'm definitely not happy about this...
Let me get this right... it seems that you're cruising along fine with
SQLITE_OK's all over the place when suddenly one of your
threads/processes get a SQLITE_BUSY signal in the middle of a
transaction. In order to solve the crisis, one of the transactions
Hello,
The point is that when two threads or
processes are trying to write at the same time, one of the two
must back off, abandon their transaction (using ROLLBACK) and let
the other proceed.
And how can this be done? What if there are more threads involved? Who
decides?
-- Tito
On Aug 11,
On 6 ago 2004, at 13:34, Peter Lau wrote:
it works... what's up?
On Aug 5, 2004, at 11:41 AM, Tito Ciuro wrote:
Test
It didn't seem to work yesterday. I though the mailing list was down...
-- Tito
this to do with the schema? Am I missing something?
Thanks again,
-- Tito
On 5 ago 2004, at 3:39, Tito Ciuro wrote:
Hello,
This happens with SQLite 3.0.3 on Mac OS X 10.3.4.
I'm issuing a simple 'SELECT * FROM people' on my database. When I
reach 'sqlite3VdbeExec', it falls on the following error
Test
smime.p7s
Description: S/MIME cryptographic signature
Hello,
This happens with SQLite 3.0.3 on Mac OS X 10.3.4.
I'm issuing a simple 'SELECT * FROM people' on my database. When I
reach 'sqlite3VdbeExec', it falls on the following error:
if( rc==SQLITE_OK && iMeta!=pOp->p2 ){
sqlite3SetString(>zErrMsg, "database schema has changed",
(char*)0);
Hello,
This happens with SQLite 3.0.3 on Mac OS X 10.3.4.
I'm issuing a simple 'SELECT * FROM people' on my database. When I reach 'sqlite3VdbeExec', it falls on the following error:
if( rc==SQLITE_OK && iMeta!=pOp->p2 ){
sqlite3SetString(>zErrMsg, "database schema has changed", (char*)0);
rc =
Hello Ara,
On 3 ago 2004, at 10:09, Ara.T.Howard wrote:
regarding atomic creation of lockfiles: this can be done using
link(2). i
have a library and command line tool for doing so, but have never
tested it on
a mac. it can be found at
http://raa.ruby-lang.org/project/lockfile/
I have
Hello Ara,
On 2 ago 2004, at 9:59, Ara.T.Howard wrote:
the simplest way to do this is to create a
file for each db, say db.lock, and to apply a blocking read/write to
this file
depending on the intent of your operation. the contents of this file
are not
important - it is merely used as a mutex
Hello John,
On 28 jul 2004, at 23:42, John Mistler wrote:
I created an application with XCode for OS X that interfaces with a
MySQL
database. I would like to switch it over to SQLite. Could someone
shed
some light on how I go about incorporating the SQLite library into my
application? For
Dennis,
Run 'configure' and then 'make'. The file "config,h" will be created
automatically.
Regards,
-- Tito
On 26 jul 2004, at 21:09, Dennis Volodomanov wrote:
Hello all,
I just downloaded the whole repository and tried to recompile (v3), but
in sqliteInt.h there's a header include "config.h"
On 25 jul 2004, at 23:50, gohaku wrote:
Hi everyone,
I was just curious if there is a way to see what tables have been
created in a SQLite database.
SELECT tbl_name FROM sqlite_master;
-- Tito
smime.p7s
Description: S/MIME cryptographic signature
On 25 jul 2004, at 5:47, Yves Chaufour wrote:
Why has it not been added for SQLite 3 ?
It's perhaps the more wanted SQLite feature, and we can't understand
why it
isn't yet implemented.
Perhaps because you haven't you seen the tremendous amount of work that
has been put into version 3. The
Hello everybody,
Should I set 'PRAGMA full_column_names = OFF' every time I execute a
SELECT statement, or just once, right after I open the database? What
is the lifetime of this setting?
Thanks,
-- Tito
Hello,
your best bet is to first declare the database without indexes, then
load all the data, then add the indexes afterwards.
Indeed.
Just for the kicks, I've tested with 100K records. These are the
results:
No indexes: 21 sec.
Indexing while inserting: 50 sec.
Indexing after inserting: 37
Hello Stephen,
On Jun 11, 2004, at 12:18, Drew, Stephen wrote:
The problem with having separate pointers is that the threads
themselves do
not have any idea of the database they will be using, which is wrapped
in
shared classes. The threads are merely worker threads that do arbitrary
jobs.
I
Hi Stephen,
Check this: http://www.sqlite.org/cvstrac/wiki?p=MultiThreading
Regards,
-- Tito
On 10 jun 2004, at 17:05, Drew, Stephen wrote:
From the SQLite FAQ:
"Threadsafe" in the previous paragraph means that two or more threads
can
run SQLite at the same time on different "sqlite" structures
Puneet, Will and Kurt,
You all have very good points. While I agree partially with Will and
Kurt, Puneet is definitely closer to my opinion.
I'm writing a tool to access *any* SQLite database. The problem is that
the current introspection implementation in SQLite is incomplete. Yes,
I agree
Hello Gerry,
Thanks for your answer. Your email is quite clear, but it still doesn't
address a key point.
On 28 may 2004, at 23:07, Gerry Snyder wrote:
When you do a "SELECT *", the results contain only columns
that are explicitly declared in the CREATE TABLE statement.
If you have declared an
Hello,
When I retrieve ROWID's datatype, I get INTEGER. Shouldn't it be
INTEGER PRIMARY KEY, the way I created it? The questions arises when
performing the ALTER-like operation as shown here:
http://www.sqlite.org/faq.html#q13
If I trust SQLite, then I'll add ROWID with an INTEGER datatype.
Hello everybody,
Today I'm releasing QuickLite, a Cocoa wrapper for SQLite, the
embeddable SQL database engine.
QuickLite already includes SQLite, so there's no need to download and
to configure. It provides the developer with a SQL database without
running a separate RDBMS process. QuickLite
Hello Paul,
You just beat me by a couple minutes! :-)
Thanks, I've found out this statement works as well:
-> INSERT INTO address_backup(ROWID,First,Last,Country) SELECT
ROWID,First,Last,Country FROM address;
Thanks a lot,
-- Tito
On 26 may 2004, at 9:15, Paul Smith wrote:
Shouldn't the
Hello,
I would like to add a new column to an existing table on-the-fly. I've
followed the code found on SQLite's website:
http://sqlite.org/faq.html#q13 and modified it slightly to the
following:
Adding table 'address' to the database...
-> CREATE TABLE address(ROWID INTEGER PRIMARY
ow that is the basic "industry standard" design for
Client-Server.
Fred
-----Original Message-
From: Tito Ciuro [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 19, 2004 1:35 AM
To: George Ionescu
Cc: Sqlite Forum
Subject: Re: [sqlite] Re: Life of a cursor
Hello George,
After that, it's
Hello George,
After that, it's of no use to keep the database open, so it closes it.
And sends the results obtained back to the client.
Wow! This is the first I hear that. Wouldn't that be an expensive
operation? (opening, closing, reopening...)
Thanks for your comments!
Regards,
-- Tito
On 19
Hello,
I'm testing Jim Lyon's sqaux library and I have a question regarding
cursor validity. The call _sqaux_rowset_open() copies the results to a
table_rowset structure. The question I have is the following: even
though a table_rowset lives after the database has been closed, does
this
Sascha,
On 15 may 2004, at 10:48, Sascha Kuehn wrote:
here is my selectstatement: "SELECT * FROM WorkBook WHERE name LIKE
'%page%'"
the workbook table contains several rows where "name" contains
"pageup" and i want to get only this rows. but the selectstatement
doesn't work. can somebody help
Hello,
On 12 may 2004, at 20:19, D. Richard Hipp wrote:
SELECT '500'=500;
Is the result "0" or "1"? In other words, what happens when
you compare a number to a string that looks like that number.
Are they equal or not?
I vote for "0".
Regards,
-- Tito
Hello,
A few days ago I posted a question and I haven't seen any comments so
far. I'm really curious about ROWID's volatility. How can I make sure
that ROWIDs do not get re-initialized? I'm posting the message once
again hoping that someone will explain how I should properly use
ROWIDs.
Hello,
Would this explanation about ROWID make sense?:
Referencing ROWID: If you make references to ROWID but then export
your database (using, for example, the ".dump" command of the sqlite
shell) and reimport it, all of your ROWIDs will change and your
references won't
be right any more.
Hello,
I definitely recommend SixFeetUp: http://www.sixfeetup.com
We've been doing business with them for two years with excellent
results. They host our website and e-mail accounts.
Regards,
-- Tito
On 31 mar 2004, at 17:30, D. Richard Hipp wrote:
For the past 9 months, www.sqlite.org has
Hi Peter,
I'm using SQLite on Panther with XCode. I can send you a snapshot of
the files needed. Since it'll be an image, please contact me privately
if you're interested.
Regards,
-- Tito
On 11 mar 2004, at 17:02, Peter Lau wrote:
Hi Greg,
On Mar 11, 2004, at 4:56 PM, Greg Obleshchuk
Hello,
On 8 mar 2004, at 18:57, Will Leshner wrote:
Are you seeing these results with the callback or with
sqlite_get_table. I'm betting sqlite_get_table, because the callback
doesn't return results in that fashion. Anyway, you can't get the
types with sqlite_get_table. Only with the
Hello,
On 8 mar 2004, at 18:47, Dennis Cote wrote:
How are you interfacing to SQLite? Are you using the C API directly?
If so,
are you using sqlite_exec() with a callback function (the callback
API), or
are you using the sqlite_compile(), sqlite_step(), and
sqlite_finalize()
(the newer
Hello guys,
Now that 2.8.13 is out, is 'PRAGMA show_datatypes = ON' by default? I
wonder because I'm still not getting the data types in the result set.
I posted a message yesterday and after upgrading to 2.8.13 I'm still
getting the same results. Can someone *please* give me some pointers?
Hello,
Where can I check older (last week) emails posted in the SQLite list?
Thanks,
-- Tito
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Hello Thiago,
http://www.sqlite.org/cvstrac/wiki?p=MultiThreading
Regards,
-- Tito
On 24 feb 2004, at 10:31, Thiago Mello wrote:
Hi,
Im using Sqlite in my application, and I want to two process bem able
to
insert records in a table, SQLite support process concurrence, or I
have
to do this
On 30 oct 2003, at 12:04, Dennis Volodomanov wrote:
Hello everybody,
Is there any easy way to modify an existing table? I need to do three
things:
1) add one more column
2) change the name of one column (keeping the data intact)
3) rename a table
Or do I have to read in and then write out the
it's busy and that machine should
wait,
otherwise just continue.
Does that sound reasonable? Are there any potential flaws in my logic
here?
Thank you!
Dennis
- Original Message -----
From: "Tito Ciuro" <[EMAIL PROTECTED]>
To: "Dennis Volodomanov" <[EMAIL P
Hello Dennis,
On miércoles, octu 29, 2003, at 09:16 Europe/Paris, Dennis Volodomanov
wrote:
That issue is, if I query a row before I want to change it, and I get
some
values, and reading from a database is allowed by all, even if the
database
is locked for writing, then how will I know that
101 - 173 of 173 matches
Mail list logo