Re: [sqlite] Non-amalgamized version

[Ludvig Strigeus]

Right, but I was asking for the preprocessed versions, because I don't have
the tools needed to do the preprocessing steps readily available.

/Ludvig

On 4/15/07, John Stanton <[EMAIL PROTECTED]> wrote:


Just pick up the regular distribution.  The link is
http://www.sqlite.org/sqlite-3.3.15.tar.gz

Everything you need to build Sqlite on a variety of platforms is there.
  Well commented open source makes it simple to extend or modify.

Ludvig Strigeus wrote:
> Hi,
>
> I want a non-amalgamized version. I.e. I want to have the file structure
> intact, and not everything in the same file.
>
> Thanks,
> Ludvig
>
> On 4/15/07, Jens Miltner <[EMAIL PROTECTED]> wrote:
>
>>
>>
>> Am 15.4.07 um 14:00 schrieb Ludvig Strigeus:
>>
>> > Hi,
>> >
>> > Is it still possible to find a non-amalgamized zip file suitable
>> > for use to
>> > build sqlite on windows? (I.e. I need the "preprocessed" files
>> > where the
>> > unix tools have already been run). I would like the non-amalgamized
>> > files
>> > because I would like to modify it more easily.
>> >
>> > Can I just split the amalgamized .c file whenever I find the file
>> > separator
>> > comments (*** Begin file  ***) etc, and will that give the same
>> > result
>> > as the package that used to exist on the webpage?
>>
>> I'm not sure I understand your question correctly, but what's wrong
>> with < http://sqlite.org/sqlite-source-3_3_15.zip>?
>> You can find this link on the sqlite download page > download.html>...
>>
>> HTH,
>> 
>>
>>
>>
>>
>>
-
>>
>> To unsubscribe, send email to [EMAIL PROTECTED]
>>
-
>>
>>
>>
>>
>



-
To unsubscribe, send email to [EMAIL PROTECTED]

-

Re: [sqlite] Fortran 95 Language Bindings

[Gary Scott]

Liam Healy wrote:

I am very interested in this for a project of increasing urgency.  A few
months ago
I found the two links that the other emails mentioned, but found both of
them
inadequate and not well documented.  I think a  complete, documented
F95 API would be very useful.  I am willing to help and critique as time
allows;
I would be using gfortran on linux/amd64 if that makes a difference.


I like Arjen's project as it mirrors my design thoughts somewhat.  I am 
however unsure how it can be done in a compiler independent manner (I 
see no such markup in Arjen's work, however, so what am I missing?). 
The Fortran standard does not guarantee any particular argument passing 
mechanism.  It might use pass by reference or value or register at its 
own choosing depending on many factors, including optimization settings. 
 There is no standard way for the application programmer to choose. 
Each compiler vendor provides it's own unique method of adjusting 
calling mechanisms  and many do not by default match C.  Some compiler's 
are now beginning to support standard conforming mechanisms (which may 
not cover all cases still), but that will be rare for a year or two. 
I'll be out of town for the next week, hoping for approval to use SQLite 
in my project.  Without that approval, my incenstive will be less.  I do 
see this as an important need however.




On 4/14/07, Gary Scott <[EMAIL PROTECTED]> wrote:



Hi, this is my first post, so please excuse any etiquette goofs.  I'm
researching incorporation of SQLite into a project.  It would appear
relatively straightforward to develop an F95 language binding, however
it is likely to be compiler specific (extensions required to adapt
calling syntax to C).  Is this a suitable place to ask basic C-oriented
questions relative to the existing API?  Also, it would be my desire to
not only map the existing API exactly (as public), but to also create a
small additional layer atop the existing API with a slightly higher
abstraction level to hide some of the low levelness of the API
(pointers, handle passing, etc.).  Would anybody be interested in
helping or critiquing as I progress?  (I haven't decided to do this yet,
I'm awaiting corporate approval to use public domain software in my
project, which they have refused in the past.  This part of the project
would be on my own time so as to not involve company ownership issues).

--

Gary Scott
mailto:[EMAIL PROTECTED] dot net

Fortran Library:  http://www.fortranlib.com

Support the Original G95 Project:  http://www.g95.org
-OR-
Support the GNU GFortran Project:  http://gcc.gnu.org/fortran/index.html

If you want to do the impossible, don't hire an expert because he knows
it can't be done.

-- Henry Ford



- 


To unsubscribe, send email to [EMAIL PROTECTED]

- 









--

Gary Scott
mailto:[EMAIL PROTECTED] dot net

Fortran Library:  http://www.fortranlib.com

Support the Original G95 Project:  http://www.g95.org
-OR-
Support the GNU GFortran Project:  http://gcc.gnu.org/fortran/index.html

If you want to do the impossible, don't hire an expert because he knows 
it can't be done.


-- Henry Ford

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Re: SQLite and nested transactions

[Gerry Snyder]

[EMAIL PROTECTED] wrote:

Gerry,
I took a look at this and I don't see how it works.


Sorry. I was just thinking about inserts.

Gerry

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Non-amalgamized version

[John Stanton]

Just pick up the regular distribution.  The link is 
http://www.sqlite.org/sqlite-3.3.15.tar.gz


Everything you need to build Sqlite on a variety of platforms is there. 
 Well commented open source makes it simple to extend or modify.


Ludvig Strigeus wrote:

Hi,

I want a non-amalgamized version. I.e. I want to have the file structure
intact, and not everything in the same file.

Thanks,
Ludvig

On 4/15/07, Jens Miltner <[EMAIL PROTECTED]> wrote:




Am 15.4.07 um 14:00 schrieb Ludvig Strigeus:

> Hi,
>
> Is it still possible to find a non-amalgamized zip file suitable
> for use to
> build sqlite on windows? (I.e. I need the "preprocessed" files
> where the
> unix tools have already been run). I would like the non-amalgamized
> files
> because I would like to modify it more easily.
>
> Can I just split the amalgamized .c file whenever I find the file
> separator
> comments (*** Begin file  ***) etc, and will that give the same
> result
> as the package that used to exist on the webpage?

I'm not sure I understand your question correctly, but what's wrong
with < http://sqlite.org/sqlite-source-3_3_15.zip>?
You can find this link on the sqlite download page ...

HTH,





- 


To unsubscribe, send email to [EMAIL PROTECTED]
- 










-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Fortran 95 Language Bindings

[Liam Healy]

I am very interested in this for a project of increasing urgency.  A few
months ago
I found the two links that the other emails mentioned, but found both of
them
inadequate and not well documented.  I think a  complete, documented
F95 API would be very useful.  I am willing to help and critique as time
allows;
I would be using gfortran on linux/amd64 if that makes a difference.

On 4/14/07, Gary Scott <[EMAIL PROTECTED]> wrote:


Hi, this is my first post, so please excuse any etiquette goofs.  I'm
researching incorporation of SQLite into a project.  It would appear
relatively straightforward to develop an F95 language binding, however
it is likely to be compiler specific (extensions required to adapt
calling syntax to C).  Is this a suitable place to ask basic C-oriented
questions relative to the existing API?  Also, it would be my desire to
not only map the existing API exactly (as public), but to also create a
small additional layer atop the existing API with a slightly higher
abstraction level to hide some of the low levelness of the API
(pointers, handle passing, etc.).  Would anybody be interested in
helping or critiquing as I progress?  (I haven't decided to do this yet,
I'm awaiting corporate approval to use public domain software in my
project, which they have refused in the past.  This part of the project
would be on my own time so as to not involve company ownership issues).

--

Gary Scott
mailto:[EMAIL PROTECTED] dot net

Fortran Library:  http://www.fortranlib.com

Support the Original G95 Project:  http://www.g95.org
-OR-
Support the GNU GFortran Project:  http://gcc.gnu.org/fortran/index.html

If you want to do the impossible, don't hire an expert because he knows
it can't be done.

-- Henry Ford



-
To unsubscribe, send email to [EMAIL PROTECTED]

-

Re: [sqlite] Non-amalgamized version

[Ludvig Strigeus]

Hi,

I want a non-amalgamized version. I.e. I want to have the file structure
intact, and not everything in the same file.

Thanks,
Ludvig

On 4/15/07, Jens Miltner <[EMAIL PROTECTED]> wrote:



Am 15.4.07 um 14:00 schrieb Ludvig Strigeus:

> Hi,
>
> Is it still possible to find a non-amalgamized zip file suitable
> for use to
> build sqlite on windows? (I.e. I need the "preprocessed" files
> where the
> unix tools have already been run). I would like the non-amalgamized
> files
> because I would like to modify it more easily.
>
> Can I just split the amalgamized .c file whenever I find the file
> separator
> comments (*** Begin file  ***) etc, and will that give the same
> result
> as the package that used to exist on the webpage?

I'm not sure I understand your question correctly, but what's wrong
with < http://sqlite.org/sqlite-source-3_3_15.zip>?
You can find this link on the sqlite download page ...

HTH,





-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Database performance

[Joe Wilson]

--- "Andrey A. Lapin" <[EMAIL PROTECTED]> wrote:
> I develop database in which information on the traffic (headings of packets
> MAC, TCP/IP) is stored.
> Processing of queries occurs slowly.
> For example, quantity of records in a database of 17 million lines and its
> size 3 Gb.
> How to increase performance?

No one will be able to help you unless you post the table schema and
provide some working SQL expressions that you wish to speed up.

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Non-amalgamized version

[Ludvig Strigeus]

Hi,

Is it still possible to find a non-amalgamized zip file suitable for use to
build sqlite on windows? (I.e. I need the "preprocessed" files where the
unix tools have already been run). I would like the non-amalgamized files
because I would like to modify it more easily.

Can I just split the amalgamized .c file whenever I find the file separator
comments (*** Begin file  ***) etc, and will that give the same result
as the package that used to exist on the webpage?

Thanks,
Ludvig

[sqlite] Database performance

[Andrey A. Lapin]

Excuse for my English.
I develop database in which information on the traffic (headings of packets
MAC, TCP/IP) is stored.
Processing of queries occurs slowly.
For example, quantity of records in a database of 17 million lines and its
size 3 Gb.
How to increase performance?


--

--
Andrey A. Lapin
E-mail: [EMAIL PROTECTED]

Re: [sqlite] Fortran 95 Language Bindings

[Arjen Markus]

> Hi, this is my first post, so please excuse any etiquette goofs.  I'm
> researching incorporation of SQLite into a project.  It would appear
> relatively straightforward to develop an F95 language binding, however
> it is likely to be compiler specific (extensions required to adapt
> calling syntax to C).  Is this a suitable place to ask basic C-oriented
> questions relative to the existing API?  Also, it would be my desire to
> not only map the existing API exactly (as public), but to also create a
> small additional layer atop the existing API with a slightly higher
> abstraction level to hide some of the low levelness of the API
> (pointers, handle passing, etc.).  Would anybody be interested in
> helping or critiquing as I progress?  (I haven't decided to do this yet,
> I'm awaiting corporate approval to use public domain software in my
> project, which they have refused in the past.  This part of the project
> would be on my own time so as to not involve company ownership issues).
>

Hello Gary,

have a look at the sqlite section of http://flibs.sf.net
It is not well documented, I am afraid, and it has a few quirks,
but it could be a nice start.

Regards,

Arjen

-
To unsubscribe, send email to [EMAIL PROTECTED]
-