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
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 Corlija <[EMAIL
ame 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
resulting disk db is less then 50-100 MB.
--
Nema
r
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 <[EMAIL
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]
-
enario) it will probably
be much simpler to implement.
--
Nemanja Corlija <[EMAIL PROTECTED]>
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
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 &
number in it with
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]
-
t. 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]>
pected.
--
Nemanja Corlija <[EMAIL PROTECTED]>
o() 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]>
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]>
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
any other field uses default for that field, if one
is defined.
--
Nemanja Corlija <[EMAIL PROTECTED]>
rement 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]>
cation is linked
against, execute this query from your app:
SELECT sqlite_version();
--
Nemanja Corlija <[EMAIL PROTECTED]>
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]>
o-date list of SQLite GUIs, and
many other things, on SQLite wiki.
http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
--
Nemanja Corlija <[EMAIL PROTECTED]>
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 Corlija &
On 6/1/06, Richard Battagline <[EMAIL PROTECTED]> wrote:
How do you unsubscribe?
Send an email to [EMAIL PROTECTED]
--
Nemanja Corlija <[EMAIL PROTECTED]>
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]>
T name FROM sqlite_temp_master"?
Perhaps all your tables are temp tables?
--
Nemanja Corlija <[EMAIL PROTECTED]>
table in it. Run the
pragma before your first CREATE TABLE query.
--
Nemanja Corlija <[EMAIL PROTECTED]>
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]>
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]>
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]>
sqlite3.dll and use the API as I've suggested in
my previous post.
--
Nemanja Corlija <[EMAIL PROTECTED]>
g/capi3ref.html#sqlite3_open
--
Nemanja Corlija <[EMAIL PROTECTED]>
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]>
istory for crawlers to index.
--
Nemanja Corlija <[EMAIL PROTECTED]>
ways to get same results. This
would come in handy just as a shortcut in _some_ cases.
--
Nemanja Corlija <[EMAIL PROTECTED]>
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 righ
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]>
; 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]>
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]>
gle quotes in your string
are not important anymore since SQLite parser will never see them.
--
Nemanja Corlija <[EMAIL PROTECTED]>
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]>
o. 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]>
bird 1.5
3 3.33
--
Nemanja Corlija <[EMAIL PROTECTED]>
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]>
performant 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
s 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]>
ion about database sizes next time. But I
don't know how can I reliably measure memory usage on windows.
--
Nemanja Corlija <[EMAIL PROTECTED]>
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_buffers=100
s 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]>
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?
> > test=#
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]>
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]>
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]>
cluding \t.
Use this command before importing your \t delimited file and you can
skip the sed step then.
.separator "\t"
--
Nemanja Corlija <[EMAIL PROTECTED]>
> 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]>
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]>
uot;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]>
xample).
See http://www.sqlite.org/datatype3.html for more details.
--
Nemanja Corlija <[EMAIL PROTECTED]>
otes, like this:
sqlite mydbase.db "select * from table1;"
--
Nemanja Corlija <[EMAIL PROTECTED]>
?
This needs to work on SQLite 2.
Thanks
--
Nemanja Corlija <[EMAIL PROTECTED]>
se' and
'all matching rows were NULL'.
But it appears it's not very consistent with other DB engines.
--
Nemanja Corlija <[EMAIL PROTECTED]>
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]>
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
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
60 matches
Mail list logo