I used sqlite 3.5.9 in my application.
I attempt to insert 1000 records. When i inserted 700 records, sqlite3_step()
return SQLITE_FULL.
The free disk space is about 1,300M and max id in the table is 700.
I have no idea how to solve it.
Could anyone help me?
On Mon, Feb 23, 2009 at 12:57 PM, Christoph Schreiber luky0...@yahoo.de wrote:
hi!
how expensive is sqlite3_open? i'm working on a small
(one-thread-per-connection) server. is it smart (in terms of cpu-time and
memory usage) to use sqlite3_open for every connection or is it better to
On Fri, Feb 27, 2009 at 8:06 AM, Wenton Thomas thomas.wen...@yahoo.com wrote:
I used sqlite 3.5.9 in my application.
I attempt to insert 1000 records. When i inserted 700 records,
sqlite3_step() return SQLITE_FULL.
The free disk space is about 1,300M and max id in the table is 700.
I
Good morning
I have problem with sqlite3_column_value function. I'm porting one project
using sqlite to version 3.3.6 but I'm not able to find when this function
were added to sqlite.
Thanks for reply
--
Ondrej Filip
e-mail: ondrej.fi...@zonio.net
mobile: 721 22 50 10
jabber:
This's very good!
I just download the codes from here:
http://www.apress.com/book/downloadfile/2847
dcharno wrote:
Could you tell me where can I find such documentation, or can you
recommend some books.
The Definitive Guide to SQLite by Michael Owens explains the SQLite
API in detail
Hello!
On Friday 27 February 2009 00:44:05 Alan Cohen wrote:
This is a bit of a religious question, but which are the mest/most
popular *nix GUIs out there? I'm using a firefox plugin but not
entirely happy with it. What do you use and why?
I'm prefer tksqlite:
Hello!
On Friday 27 February 2009 01:17:51 D. Richard Hipp wrote:
Then, I ran the .read command in sqlite3 to read in the sql
statements.
sqlite doesn't support the TO_Date function.
Please send me an example of the TOAD-generated INSERT statement that
includes a TO_Date function.
I
Hello!
On Thursday 26 February 2009 18:53:18 Jay A. Kreibich wrote:
I agree. The only major addition I'd like to see is full support for
referential integrity. I know you can fake it, to a degree, with
triggers, but I'd still like to see it baked into the database engine
itself.
Eclipse perform better for me than other all (Tortoise, WinCVS, etc).
Cross platform, excelent branching / merging support, visual list of
modified files, etc.
On Fri, Feb 27, 2009 at 03:51, J Jayavasanthan jayavasant...@gmail.comwrote:
You can also use GNU WinCVS,
I have tried out both methods in the FireFox extension SQLite Manager
and neither appears to work. Perhaps it is just FireFox parsing the
special character?
Greg
--
You can use the hex code of the non-printable character:
update tableA set field1 = line1 x'0a' line2
-Toby
Are
Why not just answer, unlimited to the POWA of your server? hehe
On Thu, Feb 26, 2009 at 6:54 AM, D. Richard Hipp d...@hwaci.com wrote:
On Feb 26, 2009, at 6:28 AM, Eversogood wrote:
Hi,
What is the maximum number of concurrent users for SQLite?
There is no limit, though writes are
Hi,
I am working on SQLite with C#.net-2008 Mobile application.
I tried to connect SQLite db through C# Mobile application, It gives error.
Any one please suggest What are the requirements to Using SQLite in C#
Mobile application.
I am waiting for u reply...
--
Regards Have a nice Day
Venu
On Thu, Feb 26, 2009 at 09:53:18AM -0600, Jay A. Kreibich wrote:
I've always wondered about this... someone please correct me if I'm
wrong, but my understanding is that there wasn't any difference
between a left and right join except for the argument order. It
seems like implementing
On Thu, 26 Feb 2009, Nuno Magalh?es might have said:
This is a bit of a religious question, but which are the mest/most
popular *nix GUIs out there? I'm using a firefox plugin but not
entirely happy with it. What do you use and why?
I prefer vi and sh.
Mike
At 01:28 PM 2/26/2009, J. R. Westmoreland wrote:
Can someone please give me a suggestion for a good client for CVS that runs
under Windows?
Use tortoise cvs. It's wonderful.
http://www.tortoisecvs.org/
___
sqlite-users mailing list
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
venugopala Reddy wrote:
I am working on SQLite with C#.net-2008 Mobile application.
I tried to connect SQLite db through C# Mobile application, It gives error.
Any one please suggest What are the requirements to Using SQLite in C#
Mobile
Howdy!
As you probably know, rendering engines are bundling SQLite to provide
the HTML5 Database API to webpages and widgets.
Then 3rd party webpages would access the database API to write data.
There should be a way for the user agent to control quotas. I was told
on IRC that currently such
Mike Eggleston wrote:
On Thu, 26 Feb 2009, Nuno Magalh?es might have said:
This is a bit of a religious question, but which are the mest/most
popular *nix GUIs out there? I'm using a firefox plugin but not
entirely happy with it. What do you use and why?
I prefer vi and sh.
Mike
Greg Robertson trifus...@gmail.com
wrote in message
news:151e70a00902270415t55996dccs5035ee4209f97...@mail.gmail.com
I have tried out both methods in the FireFox extension SQLite Manager
and neither appears to work.
Define doesn't work. Do you get an error? If the statement succeeds
but the
On Feb 27, 2009, at 8:17 AM, João Eiras wrote:
Howdy!
As you probably know, rendering engines are bundling SQLite to provide
the HTML5 Database API to webpages and widgets.
Then 3rd party webpages would access the database API to write data.
There should be a way for the user agent to
Well, i don't know enough of sqlite and I was told there was no such
feature. But what you wrote might be enough.
thank you.
On Fri, Feb 27, 2009 at 2:31 PM, D. Richard Hipp d...@hwaci.com wrote:
On Feb 27, 2009, at 8:17 AM, João Eiras wrote:
Howdy!
As you probably know, rendering engines
On Feb 27, 2009, at 8:50 AM, João Eiras wrote:
Well, i don't know enough of sqlite and I was told there was no such
feature. But what you wrote might be enough.
thank you.
On Fri, Feb 27, 2009 at 2:31 PM, D. Richard Hipp d...@hwaci.com
wrote:
On Feb 27, 2009, at 8:17 AM, João Eiras
On Thu, Feb 26, 2009 at 03:04:05PM -0600, Mike Eggleston scratched on the wall:
On Thu, 26 Feb 2009, Nuno Magalh?es might have said:
This is a bit of a religious question, but which are the mest/most
popular *nix GUIs out there? I'm using a firefox plugin but not
entirely happy with it.
Chris Wedgwood c...@f00f.org wrote in message
news:20090226172406.ga685...@puku.stupidest.org
On Thu, Feb 26, 2009 at 09:53:18AM -0600, Jay A. Kreibich wrote:
I've always wondered about this... someone please correct me if I'm
wrong, but my understanding is that there wasn't any difference
Hello!
On Friday 27 February 2009 16:25:28 Alexey Pechnikov wrote:
But it's work some time ago! How can I create view for attached databases
now? Create table is bad becouse attached database may be huge.
I did patch attach.c as
/* sqlite3ErrorMsg(pFix-pParse,
%s %T cannot
Hello!
Is there way to careate view such as
db eval {
CREATE TABLE view_report_01 AS
?SELECT s.name ?AS service_name,
? t_l_r.cost AS cost
?FROM work.users ? AS u,
? work.user_contracts ?AS u_c,
? work.user_services ?AS u_s,
? work.services ? AS s,
? telephony.telephony_log_rating AS t_l_r,
?
Hi!
I have a table with a timestamp column which I use to insert sqlite_uint64
values using sqlite3_bind_int64()
(values are retreived using sqlite3_column_int64() with a cast to
sqlite_uint64). This works fine with the C API.
The problem is that when I try to use the sqlite3 command line, if I
Hello!
On Friday 27 February 2009 18:08:19 you wrote:
[string map {\; \[ \] $user_id]
you can get rid of most threats, right?
We can do
set param {test' sql with some injection}
puts $param
set param [db onecolumn {select quote($param)}]
puts $param
and get result
test' sql with some
Hi all,
Lately I ran into an interesting problem. The problem is solved, but
I'm really curious about the inner works of the sqlite_master table.
I have an iPhone application. In the previous version, there was a
very slight chance (about 1%) that a query would fail. The user might
be
Lukhnos D. Liu lukhnos...@lithoglyph.com
wrote in message
news:24584eea-b339-408d-805b-9616cc7d9...@lithoglyph.com
Here's the interesting part. When my app failed, the preparation
always returned SQLITE_MISUSE. That was a very curious error. I
searched the documents, and it wasn't entirely
On Feb 28, 2009, at 3:50 AM, Igor Tandetnik wrote:
All statements prepared with sqlite3_prepare[16] are invalidated
whenever you change database schema in any way. Next time you use
such a
statement, you get SQLITE_MISUSE error and you have to finalize and
re-prepare it.
Use the newer
On Feb 27, 2009, at 2:30 PM, Lukhnos D. Liu wrote:
Some casual search in SQLite's source code revealed that it was about
some safety check mechanism (sqlite-magic), but it still didn't tell
me when and what constitues a misuse.
This is usually an indication that you passed in a database
Allan,
Thanks for your reply. I'm new to SQLite, but have used a similar list
of databases (with an emphasis on server vs. client side databases)
professionally for years. My background is designing and building
enterprise BI, ETL, and data warehouse systems using databases like
Oracle, DB2, SQL
On Feb 28, 2009, at 4:27 AM, D. Richard Hipp wrote:
This is usually an indication that you passed in a database connection
pointer to sqlite3_prepare() that had previously been closed. For
example:
sqlite3_close(db);
sqlite3_prepare(db, zSql, -1, pStmt, 0);
SQLite does *not*
Hello!
On Friday 27 February 2009 21:50:30 Kees Nuyt wrote:
A view or trigger in one database is not allowed to
reference tables (or other views) in other databases. The
reason is, the schema of the main database (in this case
your :memory: database) would be invalid once the main
database
Alexey,
Thank you for your reply and for sharing your success with SQLite. I'm
excited by your results (60x faster). On an informal basis, we've been
going back and re-benchmarking some of our old, 'traditional'
(Oracle/Informatica) ETL/DW projects and we now believe the majority of
these systems
This is a continuation of the SQLite vs. Oracle (parallelized)
thread with a request to learn how others are using SQLite with
very large data sets. The context of this post is processing
large data sets from a single process perspective, eg. this
question is being asked from a batch data
On Sat, 28 Feb 2009 00:20:48 +0300, Alexey Pechnikov
pechni...@mobigroup.ru wrote:
Hello!
On Friday 27 February 2009 21:50:30 Kees Nuyt wrote:
A view or trigger in one database is not allowed to
reference tables (or other views) in other databases. The
reason is, the schema of the main
Jonathon thejunk...@gmail.com wrote
in message
news:5dd932e10902271602m59107b2fnb8c9838d12b87...@mail.gmail.com
Here is my query:
SELECT * FROM tableR r
INNER JOIN tableU u ON u.id = r.u_id
LEFT JOIN tableP p ON u.p_id = p.id
ORDER BY p.p_name;
tableR has about 5 million records.
tableU
Binary! ... I only use 0's
On Fri, Feb 27, 2009 at 5:19 AM, Michael Comperchio fazoog...@gmail.com wrote:
Mike Eggleston wrote:
On Thu, 26 Feb 2009, Nuno Magalh?es might have said:
This is a bit of a religious question, but which are the mest/most
popular *nix GUIs out there? I'm using a
Nuno Magalhães wrote:
Here lots of SQLite management tools
http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
Keyword being lots. I've been to that site, which was what prompted
me to write in the first place. I'm looking for either web-based or
*nix. I know there are lots, i just want
Do you want this for data entry, or developing and managing the database
via SQL. I have yet to see a really good front end for data entry
although Dabo shows promise as a tool to make good data entry tools.
Thanks, i'll look into it. I want it as a means to create the inicial
schema and
Nuno Magalhães wrote:
Do you want this for data entry, or developing and managing the database
via SQL. I have yet to see a really good front end for data entry
although Dabo shows promise as a tool to make good data entry tools.
Thanks, i'll look into it. I want it as a means to create the
Jim Dodgen wrote:
Binary! ... I only use 0's
On Fri, Feb 27, 2009 at 5:19 AM, Michael Comperchio fazoog...@gmail.com
wrote:
Mike Eggleston wrote:
On Thu, 26 Feb 2009, Nuno Magalh?es might have said:
This is a bit of a religious question, but which are the mest/most
44 matches
Mail list logo