Jim Dodgen wrote:
> Binary! ... I only use 0's
>
> On Fri, Feb 27, 2009 at 5:19 AM, Michael Comperchio
> 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/mos
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 crea
> 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 cha
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
Binary! ... I only use 0's
On Fri, Feb 27, 2009 at 5:19 AM, Michael Comperchio 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 firefox
"Jonathon" 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 has 100k re
Hello All,
I have a simple query that seems to be going very very very slow. I am not
sure why sqlite is behaving this way, which is why I decided to burden you
guys with my question. My guess is that the query optimizer might not be
able to decipher what exactly I want to do, and thus computes
On Sat, 28 Feb 2009 00:20:48 +0300, Alexey Pechnikov
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 database (in this ca
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 process
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
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
> databa
Hello!
On Friday 27 February 2009 23:35:50 pyt...@bdurham.com wrote:
> I'm interested in exploring whether or not SQLite can be used as an ETL
> tool with large data sets (~80+ Gb). In this context, SQLite would be
> run on 64-bit Intel servers with lots of RAM (16-64 Gb). The data would
> be stor
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*
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 S
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 databas
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
"Lukhnos D. Liu"
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 clear to me why one
> wou
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 wonde
Hi,
Similar to SQL developer => wxSQLite+
Free: GPL v3
for Linux (compiled provided for mandriva 2009) but sources are provided.
Nuno Magalhães a écrit :
>> Here lots of SQLite management tools
>>
>> http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
>>
>
> Keyword being "lots". I've bee
> 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 to know which one(s) y
On Fri, 27 Feb 2009 16:25:28 +0300, Alexey Pechnikov
wrote:
>Hello!
>
>I did try
>
>$ sqlite3 :memory:
>SQLite version 3.6.11
>Enter ".help" for instructions
>Enter SQL statements terminated with a ";"
>sqlite> attach database 'merch.db' as work;
>sqlite> create view test as select * from work.us
Hi,
Here lots of SQLite management tools
http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
Best regards
Fred
Nuno Magalhães a écrit :
> Greetings,
>
> 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
> enti
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 s
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 u
Hello!
On Friday 27 February 2009 17:32:36 Arjen Markus wrote:
> This is the Tcl binding, right?
> You could replace the variable by its value using [string map]:
>
> db eval [string map [list USER_ID $user_id ...] $sql_statement]
>
> or more directly:
>
> db eval \
> "CREATE TABLE view_repor
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,
? tel
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 re
"Chris Wedgwood" 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
>>
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 wit
Not doing any much. Just investigating. I'm actually more concerned
with the html5 things.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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
> wrote:
>>
>> On Feb 27, 2009, at 8:17 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 wrote:
>
> On Feb 27, 2009, at 8:17 AM, João Eiras wrote:
>
>> Howdy!
>>
>> As you probably know, rendering engines are bun
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
"Greg Robertson"
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 value appears to
Hello!
I did try
$ sqlite3 :memory:
SQLite version 3.6.11
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> attach database 'merch.db' as work;
sqlite> create view test as select * from work.users;
SQL error: view test cannot reference objects in database work
But
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 an
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 featu
-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 appli
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
sqlite-users@sqlite
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
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 implement
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
Why not just answer, unlimited to the POWA of your server? hehe
On Thu, Feb 26, 2009 at 6:54 AM, D. Richard Hipp 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 seriali
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
>A
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 wrote:
> You can also use GNU WinCVS, http://www.wincvs.org/download.html
> Regards,
> Jay
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.
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 func
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:
http://reddog.s35.xrea.com/w
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 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: nezna...@jabber.cz
On Fri, Feb 27, 2009 at 8:06 AM, Wenton Thomas 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 have no idea how to so
On Mon, Feb 23, 2009 at 12:57 PM, Christoph Schreiber 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
> create a pool of p
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?
53 matches
Mail list logo