Re: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

On 2/7/07, Ralf Junker <[EMAIL PROTECTED]> wrote: PS: For anyone interested: The new SQLiteSpy with table cell editing is now available at http://www.yunqa.de/delphi/sqlitespy/ Ralf, thanks SQLiteSpy. Download link is not working though. -- Nemanja Corlija <[EMAIL

Re: [sqlite] Function question

t. Here's a list of available functions: http://www.sqlite.org/lang_expr.html#corefunctions If you decide to write one your self, you can compile it as a loadable extension and load it at runtime from SQL using load_extension() function. -- Nemanja Corl

Re: [sqlite] Memory database to file

e a schema like this: CREATE TABLE t1(name TEXT PRIMARY KEY, age INT); You'd want to transform that into something more like this: CREATE TABLE t1(name TEXT, age INT); CREATE INDEX t1_idx1 ON t1(name); This whole thing will probably provide no significant gain if your resul

Re: [sqlite] Re: Table Schema

a valid SQL statement that you can execute via a sqlite3_exec() from C. But you can use above mentioned "PRAGMA table_info(tbl_name);", which is a valid SQL statement in SQLite and you can execute it via a sqlite3_exec() from C. http://www.sqlite.org/pragma.html#

Re: [sqlite] File db to memory db and back

ry little code change. Richard, thank you very much. Regards -- Nemanja Corlija <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] File db to memory db and back

On 1/19/07, Nicolas Williams <[EMAIL PROTECTED]> wrote: On Fri, Jan 19, 2007 at 12:28:55AM +0100, Nemanja Corlija wrote: > Even though this is a once a week thing, I still need to speed it up. > I see 2 possible solutions: > 1. Find some way to move file db to memory db and ba

[sqlite] File db to memory db and back

ry db back to file somehow. Second option is something I've been trying to avoid for some time, but as db grows things only get worse with current setup so I have to do something. Could anyone recommend some off the shelf, or close to it, solution for this? Any help/pointers are very much appr

Re: [sqlite] Why is VACUUM so slow?

ing it your self instead of letting VACUUM do all the work. If you do try it, it would be very interesting to hear about your experiences. I should say that I have no indexes in my db other then primary key. -- Nemanja Corlija &

[sqlite] Why is VACUUM so slow?

lready had uniqueness enforced. This was on Win2000, SQLite 3.3.7 via sqlite3.exe. Has anyone experienced similar performance difference? -- Nemanja Corlija <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Using SQLite to record Web log file data (a threading question)

to make more sense than above scenario) it will probably be much simpler to implement. -- Nemanja Corlija <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] sqlite_master table does not show all available tables....

in the latest opened file. Is there a way to see all the tables in all of the database files opened for the session ? Try this: ATTACH "atch.db" AS atch; SELECT * FROM atch.sqlite_master; -- Nemanja Corlija &

Re: [sqlite] version 3.3.4

th the one you need. Following that logic, precompiled DLL for 3.3.4 would be at: http://www.sqlite.org/sqlitedll-3_3_4.zip -- Nemanja Corlija <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] binding paramters for SELECT

e resulting statement. I get 0 back when I expected 1. Is this an invalid way to specify a placeholder for a variable that I will bind later? You don't need to enclose ? with any quotes. Try it like this: WHERE state='1' AND clientName=? -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] primary key information

e created as expected. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] primary key information

e_info() output is "pk". This column indicates weather or not the table column in question is part of primary key. Though that last column of table_info() pragma is missing from documentation at http://www.sqlite.org/pragma.html#schema -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] how to unsubscribe this mail list

On 8/2/06, jason zhang <[EMAIL PROTECTED]> wrote: Hi All, I don't find the method to unsubscribe this mail list from www.sqlite.org, could you please tell me how? Send an email to [EMAIL PROTECTED] -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] insert default values

On 7/28/06, Mario Frasca <[EMAIL PROTECTED]> wrote: On 2006-0728 16:07:47, Nemanja Corlija wrote: > You can insert default value like this: > insert into test (f) values (NULL); > > Inserting NULL into autoincrement field just increments it. While > omitting value for

Re: [sqlite] insert default values

any other field uses default for that field, if one is defined. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] count(*)

t/decrement row count in a separate table. Complete examples of such code were posted to list before. Look for it in archives. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] Using Sqlite 3.2.1 on linux

lication is linked against, execute this query from your app: SELECT sqlite_version(); -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] Performance query with many joins

g like: ORDER BY +S.SortID ASC + in front of column name prevents any index you might have on that column from being used. That sometimes can be faster then using an index. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] Windows DB manager?

reasonably up-to-date list of SQLite GUIs, and many other things, on SQLite wiki. http://www.sqlite.org/cvstrac/wiki?p=ManagementTools -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] Functions embedded in SQL statements

On 6/18/06, Bud Beacham <[EMAIL PROTECTED]> wrote: My apologies if I have overlooked it. I also had trouble finding them first few times, even though I knew they were there somewhere. Anyway, here's what you're looking for: http://www.sqlite.org/lang_expr.html -- Nemanja

Re: [sqlite] How do you unsubscribe?

On 6/1/06, Richard Battagline <[EMAIL PROTECTED]> wrote: How do you unsubscribe? Send an email to [EMAIL PROTECTED] -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] Line feeds

On 5/23/06, Andrew Ward <[EMAIL PROTECTED]> wrote: Hi, How can I perform an insert that contains linefeeds, such as INSERT INTO X VALUES (123, 'a'||chr(10)||'b'); You can insert it as a hex string: INSERT INTO t VALUES (123, 'a' || x'0A' || 'b'); -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] Can't access sqlite_master from VB6 via ODBC

you try "SELECT name FROM sqlite_temp_master"? Perhaps all your tables are temp tables? -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] Pragmas

e in it. Run the pragma before your first CREATE TABLE query. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] sqlite2 api question - updates

Something along the lines of sqlite_compile/sqlite_bind/sqlite_step/sqlite_reset/sqlite_finalize. IIRC comments in sqlite.h are only docs for that API. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] Adding colomns when the database/schema already exists

27; for strings. Is it possible to do something like that? Can you help me? Yes it is. See http://www.sqlite.org/faq.html#q13 for details. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] Cannot load sqlite3.dll

On 5/5/06, Robert Simpson <[EMAIL PROTECTED]> wrote: There's a lot more pros that cons to this approach, I'd be happy to enumerate them if you like. I'd be happy to see that list if its not a problem. Thanks -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] How to create a database without sqlite?

h here. If at all possible, go with sqlite3.dll and use the API as I've suggested in my previous post. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] How to create a database without sqlite?

te.org/capi3ref.html#sqlite3_open -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] Programmatical determination of sqlite version via SQL?

On 4/3/06, Alex Chudnovsky <[EMAIL PROTECTED]> wrote: > Is it possible (if so how) to programmatically determine version of > sqlite that is in use? SELECT sqlite_version(); -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] WAKEUP !!! SOMEBODY IS DESTROYING THE WIKI PAGES

in pages' history for crawlers to index. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] How to invert positional argument in ORDER BY

ay, there are other ways to get same results. This would come in handy just as a shortcut in _some_ cases. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] Re: How to invert positional argument in ORDER BY

On 3/26/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > Nemanja Corlija <[EMAIL PROTECTED]> wrote: > > I have a following query: > > SELECT date FROM chng ORDER BY -date; > > > > Is there a way to use positional argument (hopefully that's the

[sqlite] How to invert positional argument in ORDER BY

t of range - should be between 1 and 1" This is not a big deal obviously since I can "ORDER BY 1 DESC" here. I'm just trying to simplify my code since SQL is generated at runtime. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] Column names in a UNION

2 > 3|4 mysql> select * from (select 1 as a, 2 as b UNION ALL select 3 as e, 4 as b) as foo where b > 0; +---+---+ | a | b | +---+---+ | 1 | 2 | | 3 | 4 | +---+---+ postgres=# select * from (select 1 as a, 2 as b UNION ALL select 3 as e, 4 as b) as foo where b > 0; a | b ---+--- 1 | 2 3 | 4 (2 rows) Firebird doesn't seem to support SELECT w/o FROM. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] Column names in a UNION

On 3/25/06, Rob Lohman <[EMAIL PROTECTED]> wrote: > Microsoft SQL seems to use the column names from the > first select. So that would be "a, b" in your example. This seems to be the case for current stable versions of Firebird, Postgres and MySQL as well. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] Unrecognized token error

e already past the SQLite parser and single quotes in your string are not important anymore since SQLite parser will never see them. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] Missing files?

urce archive that contains all files needed to compile SQLite or build it your self with MINGW/MSYS. See http://www.sqlite.org/cvstrac/wiki?p=HowToCompile for more details. Preprocessed source: http://www.sqlite.org/sqlite-source-3_3_4.zip -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] Disable index?

uldn't hurt also. If you're using some wrapper it would be good to run that query from sqlite shell and see how fast that goes. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] testing Avg() function in other database engines

bird 1.5 3 3.33 -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] More benchmarks

ands from stdin so I'm pointing isql to read that same file from disk. I'll email you row files if you want. Its less 750KB bziped. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] More benchmarks

rformant one of the 3 available. > BTW, has anyone looked at adding SQLite support to any of the DBT > benchmarks? http://sourceforge.net/projects/osdldbt I just glanced over it, but I think they concentrate on heavy load testing while my focus is on single user environment for now. -- Ne

Re: [sqlite] More benchmarks

f SQLite is PRAGMA synchronous=FULL; while in case of MySQL it signifies usage of InnoDB engine. "nosync" is the opposite, of course synchronous=OFF; and MyISAM engine. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] More benchmarks

y to gather information about database sizes next time. But I don't know how can I reliably measure memory usage on windows. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] More benchmarks

db specific drivers should be very thin layer on top of PDO it self. Or did I get this thinness wrong? That might still happen in the future though. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] More benchmarks

On 2/7/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote: > On Tue, Feb 07, 2006 at 07:31:50AM +0100, Nemanja Corlija wrote: > > > Well, that certainly won't help things... at a minimum, on your machine, > > > you should change the following: > > > shared_buffer

Re: [sqlite] Indexing

st. Sometimes it even makes sense to create index, execute query and then drop the index. Though this won't save you any space since index will still be created on disk, if I'm not mistaken. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] More benchmarks

On 2/7/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote: > On Tue, Feb 07, 2006 at 07:06:26AM +0100, Nemanja Corlija wrote: > > On 2/7/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote: > > > For test 8 on PostgreSQL, what's EXPLAIN ANALYZE for one of those show? > > te

Re: [sqlite] More benchmarks

=1) Index Cond: ((b >= 0) AND (b < 100)) Total runtime: 0.510 ms (4 rows) > What changes have you made to the default postgresql.conf? None. -- Nemanja Corlija <[EMAIL PROTECTED]>

[sqlite] More benchmarks

I've posted some benchmarks between SQLite, PostgreSQL, MySQL and FirebirdSQL. Details at http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] New benchmark comparisons

ueries. Hopefully I'll be able to do that tomorrow. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] How can I sort a text field numerically?

You should be able to force numeric sorting by something like this ...order by value+0; -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] Importing Tab delimited data

nput file. There's a patch attached to http://www.sqlite.org/cvstrac/tktview?tn=1506 that adds 2 flags to .import. If you are on windows I can send you sqlite3.exe compiled with that patch if you need it. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] can ignore n lines when .import data file?

ng \t. Use this command before importing your \t delimited file and you can skip the sed step then. .separator "\t" -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] RSS code patch

headlines in Bloglines in order to go right to > an item. I don't know anything about Bloglines, but RSS support in CVSTrac is very basic ATM. However that is being worked on and it will be improved by the time next version of CVSTrac is released. When exactly will that be is impossible to tell, of course. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] CHECK constraints

> Does the check constraint fail or not? Or do different > database engines do different things? In Firebird 1.5 it does fail. Though I agree with Darren's remarks, so not failing it seems to be more flexible. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

On 11/2/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: >2.5|2.5 MySQL 5 and MS Access 2003 >2|2.5 PostgreSQL 8 and FireBird 1.5 -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] SQLITE Documentation

nd "make install", just run "make doc". Of course you'll need to run it from MSYS. Important thing here is to run "configure" script before the "make doc", but README will instruct you to do it like that anyway. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] create database file at runtime

oo (comparison for example). See http://www.sqlite.org/datatype3.html for more details. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] Command line interface SQLITE 2.8.16

le quotes, like this: sqlite mydbase.db "select * from table1;" -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] Need help with a query

like 'file%' group by fname) maxvers on >t1.fname = maxvers.fname and t1.vers = maxvers.maxvers > This works fine, well almost that is ;) SQLite was complaining about fname being ambigous so I changed first line to: select t1.fname, chng Now it works. Thanks John :) -- Nemanja Corlija <[EMAIL PROTECTED]>

[sqlite] Need help with a query

one after GROUP BY so it can't be used here. HAVING operates on the group but how do I put it to use here? This needs to work on SQLite 2. Thanks -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] SUM and NULL values

E clause' and 'all matching rows were NULL'. But it appears it's not very consistent with other DB engines. -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] Survey: NULLs and GROUP BY

INTO t1 SELECT * FROM t1; >SELECT a, b, sum(c) FROM t1 GROUP BY a, b ORDER BY 3; Postgres 8.0.3 and Firebird 1.5.2: a |b |sum 1 |2 |2 NULL|2 |4 1 |NULL|8 NULL|NULL|16 -- Nemanja Corlija <[EMAIL PROTECTED]>

Re: [sqlite] A late Christmas gift / early New Year's gift...

If somebody didn't get an Gmail invite from Joseph, I have 4 more to offer to SQLite community Cheers, Nemanja On Wed, 29 Dec 2004 07:02:29 -0500, Joseph Stewart <[EMAIL PROTECTED]> wrote: > I'm offering 4 gmail invitations to the first four people on this list > that ask for them. > Thanks again

Re: [sqlite] getpid() and linux threads in sqlite

Hello Dan, list Here are the results for Mandrake 10: Linux linux.local 2.4.25-2mdk #1 Tue Mar 2 07:39:08 CET 2004 i686 unknown unknown GNU/Linux pid is 2363 pid is 2363 pid is 2363 pid is 2363 pid is 2363 Linux linux.local 2.6.3-4mdk #1 Tue Mar 2 07:26:13 CET 2004 i686 unknown unknown GNU/Lin

[sqlite] problems with building tclsqlite on win32

Hi, I have a problem with compiling static version of tclsqlite on win32 with MinGW/MSYS? I've downloaded tcltk-8.4.1-1.exe from MinGW site and installed it in MinGW dirs. I've compiled both, static and shared, versions of SQLite from 2.8.13 sources and then I tried to build libtclsqlite.la targ

[sqlite] sqlite.org - cant open db

Is anyone having problems with dynamic pages on sqlite.org for last few days? When I try to open some page on sqlite.org that is using db I get following error message: Can't open database Unable to open the database named "sqlite.db". Reason: unable to open a temporary database file for storin