Hello I'm trying to debug SQLite (to understand the code). But e when I attach
the process sqlite3, the sqlite3 terminal hangs (ie would not accept any user
inputs) till I detach.
Can someone please tell me what I'm doing wrong
Thanks
Uma
Cory Nelson <[EMAIL PROTECTED]> wrote: On 9/7/07,
On 9/7/07, Yves Goergen <[EMAIL PROTECTED]> wrote:
> Hi,
>
> in a scenario when multiple operations need to be transactionally
> synchronised, I have a file that must be deleted when the database
> records are added successfully, but the database operations must be
> rolled back, if the file cannot
Hi,
in a scenario when multiple operations need to be transactionally
synchronised, I have a file that must be deleted when the database
records are added successfully, but the database operations must be
rolled back, if the file cannot be deleted.
I'm currently using a transaction for this on th
On Fri, 07 Sep 2007 17:16:39 +0800, Ragha wrote:
>Hi,
>
>Just to get more hands on Sqlite i want to
>write a custom operator. Pls suggest how i can do it.
>
>For example
>select * from tablex where column1 ~ '123';
>
>I want implement it similar to '='. Can anyone help me
>what all steps,files i
On 9/7/07, Brad Stiles <[EMAIL PROTECTED]> wrote:
>
> Anyway, if I understand what you're saying, I believe what you want is an
> OUTER JOIN.
>
> SELECTT1.COLUMN, T2.COLUMN
> FROM TABLE2 T2
> outer join TABLE1 T1 on T2.COLUMN = T1.COLUMN
>
> That will get all rows from T2, and mat
Its like a newbie exploration nothing more, for example if someone want to
write a linux kernel module there is some fixed guidelines,once a person is
accustomed to it,he/she would hv better understanding. So is there any guidline
ther than
tracing every line of code and then finding it out.
r
On 9/7/07, RaghavendraK 70574 <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> Its to get involved in the development of sqlite.If possible
> move to contrib section.a dream.
If that's the case, I think the first step is to post your proposal, and get
input from the SQLite community as to whether the modif
Wouldn't it be a lot easier to just create a custom function? What's the
advantage (other than pretty syntax) of using a custom operator?
Sam
---
We're Hiring! Seeking a passionate developer to join our team building
products. Position is in the Washing
Andre du Plessis wrote:
Sorry if this is actually a noob question, how do I do an ansi style
order by in sqlite
For example
A
b
a
B
Would be sorted as
A
B
a
b
but what you want is
a
A
b
B
I can do order by upper(column)
But then things like
__new__
> SELECTT1.COLUMN, T2.COLUMN
> FROM TABLE1 T1, TABLE2 T2
> WHERE T1.COLUMN *= T2.COLUMN
Sorry about the fist one. New web mail client...
Anyway, if I understand what you're saying, I believe what you want is an OUTER
JOIN.
SELECTT1.COLUMN, T2.COLUMN
FROM TABLE2 T2
> The SELECT I have is:
>
> SELECTT1.COLUMN, T2.COLUMN
> FROM TABLE1 T1, TABLE2 T2
> WHERE T1.COLUMN *= T2.COLUMN
>
> In SQL Server, the *= indicates a forced inner join which would cause
> a record to be generated regardless if it existed in the T1 table or
> not.
If I understand
I learned SQL before the SQL-92 standard was in place. The database
engines I used (SQL Server and Oracle) have their own proprietary
methods for indicating forced inner outer joins. I haven't looked at
this code in over 10 years, so I'm a little unclear about exactly what
the result set returned
On 9/6/07, Andre du Plessis <[EMAIL PROTECTED]> wrote:
> Im importing data
>
> The data has a unique value, call it MD5 for now that could be a unique
> value for the data.
>
>
>
> Each record that gets imported is converted to MD5, a lookup is done on
> the table for that MD5,
>
> if found it mu
Andre du Plessis wrote:
What is the difference between:
MYCOLUMN NUMERIC
Vs
MYCOLUMN INTEGER
See http://www.sqlite.org/datatype3.html for a complete description of
the difference.
Or does it really mean nothing,
I remember somewhere the default column type could be inte
Sorry if this is actually a noob question, how do I do an ansi style
order by in sqlite
For example
A
b
a
B
Would be sorted as
A
B
a
b
but what you want is
a
A
b
B
I can do order by upper(column)
But then things like
__new__
Goes to the bottom and should g
Yeah I have on many more than one occasion in MSAccess lost information
when the program is terminated, that is why so many people hate it and
don't want to go near it for any important data.
I have heard however that MSAccess from 2000 onwards is based on the SQL
server codebase so it is more sta
I don't think that this is particularly hard to do: search the CVS
history for the addition of the REGEXP operator for a simple example.
Or, I'll find the link for you. :P
http://www.sqlite.org/cvstrac/chngview?cn=2478
This does more than just add the regexp operator, but it's still
On 9/7/07, Andre du Plessis <[EMAIL PROTECTED]> wrote:
[..]
> What I don't understand is how Access, and other DB's are able to still
> operate much faster (maybe not as fast), and still flush file buffers to
> disk, is beyond me. Maybe it really still caches it, I would not be
> surprised if you p
May be,
first want to try with the same impl as any other operator like =.
If successful, then try providing some mech which make use of indexes
where they are actually not allowed for.
If u see one of my earlier post, related to pread,Made use of custom pread
to avoid disk access, now in 3.5 it
It still might be useful to explain what the ~ should do.
RBS
> Hi,
>
> Its to get involved in the development of sqlite.If possible
> move to contrib section.a dream.
>
> regards
> ragha
>
> **
> This email
Hi,
Its to get involved in the development of sqlite.If possible
move to contrib section.a dream.
regards
ragha
**
This email and its attachments contain confidential information from HUAWEI,
which is inten
Couldn't tell you as I don't know C, but what
will the ~ do? Can't the same be done with the
available operators?
RBS
>
> Hi,
>
> Just to get more hands on Sqlite i want to
> write a custom operator. Pls suggest how i can do it.
>
> For example
> select * from tablex where column1 ~ '123';
>
> I
Hi,
Just to get more hands on Sqlite i want to
write a custom operator. Pls suggest how i can do it.
For example
select * from tablex where column1 ~ '123';
I want implement it similar to '='. Can anyone help me
what all steps,files i need to change?
regards
ragha
***
Transactions are the main thing to speed this up
but there are others such as the various Pragma
settings. If you search in this group for slow
insert you will find them.
RBS
> The problem was transactions
>
> Thanks all
>
> -Message d'origine-
> De : Andre du Plessis [mailto:[EMAIL PROTE
The problem was transactions
Thanks all
-Message d'origine-
De : Andre du Plessis [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 7 septembre 2007 10:25
À : sqlite-users@sqlite.org
Objet : RE: [sqlite] SQLite or MS Access
Well here are my test results (im using Delphi for this one)
This is
Well here are my test results (im using Delphi for this one)
This is my insert statement:
INSERT INTO TEST (TEST_ID_NO_IDX, NO_INDEX, TEST_DATA, TEST_ID) values
(%d, %s, %s, %d)
This table deliberately has NO index.
1000 inserts took:
Inserting MS Access - 4,043.273 ms
Inserting SQLite - 249.32
have you try this on usb key ? i've very bad benchmark on this, try in
hard disk in this case
Sylko Zschiedrich a écrit :
Do all insert's in one transaction and it will be done in 1 second or less.
Begin transaction
1..1000 insert into table
Commit transaction
Ciao
Sylko
-Ursprüngliche
Do all insert's in one transaction and it will be done in 1 second or less.
Begin transaction
1..1000 insert into table
Commit transaction
Ciao
Sylko
-Ursprüngliche Nachricht-
Von: Michael Martin [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 7. September 2007 10:06
An: sqlite-users@sq
Hi All,
I've done some benchmarks tests and I wonder where I've made a mistake.
In C# code with SQLite.NET.2.0.1 wrapper with sqlite 3.0: 1000 inserts
in a table of two columns -> 168 seconds
In C# code with Jet.Oledb.4.0 with MS Access: 1000 inserts in a table
of two columns -> 1.14
29 matches
Mail list logo