> -Original Message-
> From: RohitPatel [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 16, 2006 1:58 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] SQLite Vs VistaDB - Comparison ???
Getting back on track ...
> VistaDB
> HomePage : www.vistadb.com
> More Features : www.vistad
Let's say I have two tables A and B, each of which has an integer ID
column. I want to find ID values that occur in A but not B. The
first query I came up with was:
SELECT ID FROM A WHERE NOT EXISTS (SELECT * FROM B WHERE B.ID = A.ID);
but I get a syntax error. My next try,
SELECT ID FROM
Friday, June 16, 2006, 5:32:32 PM, Andrew Piskorski wrote:
> Would using a non-overwriting MVCC storage layer a la PostgreSQL (but
> still using client SQLite processes only, no client/server
> arrangement) make any of the above easier or better?
See http://www.sqlite.org/cvstrac/wiki?p=BlueSky t
On Fri, Jun 16, 2006 at 12:35:33PM -0400, [EMAIL PROTECTED] wrote:
> > Out of curiosity why won't flock() work?
>
> Process A wants to modify the database, so it flock()s
> the rows it needs to changes and starts changing them.
> But half way in the middle of the change, somebody sends
> process
"P?ter Szab?" <[EMAIL PROTECTED]> wrote:
> Dear SQLite Developers,
>
> I am seeking help for optimizing my SQLite SQL query, which seems to
> be running unreasonably slow. The query is:
>
> SELECT col2 FROM t WHERE col1='foobar' AND
> col4='foobarfoobarfoobarfoob';
>
> My schema is the follo
In message <[EMAIL PROTECTED]>,
Jay Sprenkle wrote:
> > Hi All,
> >
> > I'm creating a database which will look a little like:
> > create table main (f1 TEXT, f2 TEXT, f3 TEXT, t1 TEXT, t2 TEXT, tn TEXT);
> >
> > f1, f2 and f3 will always be present. Any or all of the ts might be NULL.
> >
> > I'd
Dear SQLite Developers,
I am seeking help for optimizing my SQLite SQL query, which seems to
be running unreasonably slow. The query is:
SELECT col2 FROM t WHERE col1='foobar' AND
col4='foobarfoobarfoobarfoob';
My schema is the following:
CREATE TABLE t (
col1 text NOT NULL,
col2 in
I suggest we don't pick Access/Jet MDB as our shining example of
SQLite's future
Borland's old, dead, and gone Paradox was Access' main reason to come
into existence. Inspire of outliving Paradox, only because of marketing
reasons, Access has never been able to leapfrog or even measure up to
old
Christian Smith wrote:
Bogus�aw Brandys uttered:
[EMAIL PROTECTED] wrote:
Mikey C <[EMAIL PROTECTED]> wrote:
Please implement table and row level locking. :-)
People commonly believe that doing so must be easy. I
certainly get a lot of requests for it from people who
think they know how.
RohitPatel wrote:
> FoxPro supports row level locking. Ofcourse FoxPro creates one file for each
> table. There must be some way to implement row level locking. Probable by
> locking region in a file or somehow.
>
> Just thinking curiously...how MS could have implemented row level locking in
>
"Jay Sprenkle" <[EMAIL PROTECTED]> wrote:
> On 6/16/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > Mikey C <[EMAIL PROTECTED]> wrote:
> > >
> > > Please implement table and row level locking. :-)
> >
> >
> > If you think you know a way to implement row-level
> > locking that does not impose o
On 6/16/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Mikey C <[EMAIL PROTECTED]> wrote:
>
> Please implement table and row level locking. :-)
If you think you know a way to implement row-level
locking that does not impose one of the above
limitations, then please tell me and I will look
int
Okay I know very little about these things, but the fact that Access/JET MDB
files are serverless (it's just a bunch of Windows dll's) in the same way as
SQLite, and that JET implements row and table level locking means I guess it
is possible.
If it meant losing ACID compliance, then no, forget a
Bogus�aw Brandys uttered:
[EMAIL PROTECTED] wrote:
Mikey C <[EMAIL PROTECTED]> wrote:
Please implement table and row level locking. :-)
People commonly believe that doing so must be easy. I
certainly get a lot of requests for it from people who
think they know how. But in fact, row-level l
Bogus³aw Brandys said:
> In fact that is as I fairy know how it's implemented in Firebird Classic
> Server (where each server process has separate lock manager I suppose)
> This classic server processes are spawn by xinetd deamon.
> I see sqlite in very similar manner : sqlite library is attache
[EMAIL PROTECTED] wrote:
Mikey C <[EMAIL PROTECTED]> wrote:
Please implement table and row level locking. :-)
People commonly believe that doing so must be easy. I
certainly get a lot of requests for it from people who
think they know how. But in fact, row-level locking
is extraordinarily di
Mikey C <[EMAIL PROTECTED]> wrote:
>
> Please implement table and row level locking. :-)
People commonly believe that doing so must be easy. I
certainly get a lot of requests for it from people who
think they know how. But in fact, row-level locking
is extraordinarily difficult. To my knowledg
On 6/15/06, John Stanton <[EMAIL PROTECTED]> wrote:
I have implemented just such a system as an RPC. It accesses an HTTP
server using CGI and returns the table or view requested in XML.
How do you ensure non malicious code is sent to RPC?
--
SqliteImporter and SqliteReplicator: Command line u
On 6/16/06, René Tegel <[EMAIL PROTECTED]> wrote:
i found MS-Access a very reasonable
flat-file database. It may lack fancy features like encrytion, but has
it advantages as well
Pro's: any windows client has the driver installed (no need to install
office), accessable by odbc, reasonable sql (ve
MS Access (MDB files) use the Jet engine. Not every PC has the correct
drivers, since jet has changed many times as Access evolved from version 2.0
thru 95, XP and 2003.
Access is NOT ACID compliant, is limited in maximum database size, is
limited to 255 connections.
http://www.somacon.com/p369
FoxPro supports row level locking. Ofcourse FoxPro creates one file for each
table. There must be some way to implement row level locking. Probable by
locking region in a file or somehow.
Just thinking curiously...how MS could have implemented row level locking in
FoxPro.
Rohit
--
View this mes
FoxPro has Row Level locking. There must be some way with which it must have
been implemented.
Just curious...how MS would have implemented row level locking ???
Rohit
--
View this message in context:
http://www.nabble.com/Row-Locking-t69657.html#a4898759
Sent from the SQLite forum at Nabble.co
RohitPatel schreef:
Please put forward your views, ideas, thoughts, comparisons (if any) ??? I
might have missed many points of comparison/similarity.
At the risk of playing the devils advocate, if your target is ms windows
(seen your interest for vistadb), i found MS-Access a very reason
Hello
I was just comparing embedded SQL database engines (SQLite Vs VistaDB) for
my knowledge. Itmight be of help for someone.
In case, someone might be interested to know and/or add more feature
comparisons.
SQLite
HomePage : www.sqlite.org
More Features : www.sqlite.org, www.sqlite.org/docs.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= *
Multiple instances of application can be started at the same time *
* For example two instances of application are running *
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= An
Win32 Ap
25 matches
Mail list logo