Re: [sqlite] A hang in Sqlite

[Noel Frankinet]

Impressive and interesting !
Thank you.

On Mon, 6 Jan 2020 at 15:35, Simon Slavin  wrote:

> On 6 Jan 2020, at 2:27pm, Noel Frankinet  wrote:
>
> > What is fuzzer sql ? Is it some sort of random sql generator ?
>
> Yes.  A fuzzer is a program.  You feed it some SQL commands which obey
> syntax and work fine.  Then it mixes them and tries small changes to make
> many other SQL commands.  Almost all of these will work or generate syntax
> errors.  There are no problems with any of these.  But some of these new
> commands may reveal bugs, crashes or hangs in SQLite.
>
> The SQLite team has previously used a fuzzer on SQLite.  But there are
> billions of possible combinations of SQLite commands.  Two fuzzers which
> work in different ways will generate different commands.
>
> It is a technique used on many command-line programs.
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] A hang in Sqlite

[Noel Frankinet]

Hello everybody,
What is fuzzer sql ? Is it some sort of random sql generator ?
How do they create that non sensical yet syntactically correct SQL ?
Just curious.
Regards
Noël

On Mon, 6 Jan 2020 at 15:14, Dominique Devienne  wrote:

> On Mon, Jan 6, 2020 at 2:36 PM Jose Isaias Cabrera 
> wrote:
>
> > Dominique Devienne, on Monday, January 6, 2020 07:51 AM, wrote...
> > [...] it's "polluting" a bit this ML.
> >
> > This is why we are all so different.  I, actually enjoy the "pollution"
> > because I try to look at the code and, some times, learn from it. But,
> yes,
> > I am learning, so this is new to me.  Perhaps, if I were to have more SQL
> > knowledge, perhaps I would think the same.
>
>
> Sure. I get that. But learning from fuzzer SQL is probably not the best way
> to go about it, IMHO :)
> They go into dark corners and even nonsensical SQL to find bugs, so hardly
> newbie material.
>
> And you can also look at the bug tracker at
> https://www.sqlite.org/src/rptview?rn=1 for at least Mr Rigger's reports,
> and possibly soon Yongheng Chen's reports too, if you miss them from the
> ML. --DD
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] geopoly data input options

[Noel Frankinet]

Spatialite does to Sqlite what Postgis does to Postgres.
Same concepts.

Noël

On Sat, 20 Oct 2018 at 22:49, Jonathan Moules 
wrote:

> More specifically, in the "Simple Features for SQL" specification:
>
> http://www.opengeospatial.org/standards/sfs
>
> and if you have access (or gobs of money), there's the ISO spec (I'm
> guessing it's the same) -
> https://webstore.ansi.org/RecordDetail.aspx?sku=ISO+19125-1%3A2004
>
> I'd also suggest PostGIS (a PostGreSQL extension for spatial) given
> they're open-source you can take a gander at their code to get a feel
> for it.
>
> PostGIS also has a superset called "EWKB", though the docs are fairly
> poor on it (I'm not sure what the "E" is for - Enhanced"?) - "PostGIS
> EWKB/EWKT add 3dm,3dz,4d coordinates support and embedded SRID
> information" - probably beyond the scope of what you want in geopoly at
> this point.
>
> Cheers,
>
> Jonathan
>
>
> On 2018-10-19 21:56, Noel Frankinet wrote:
> > There a WKB and WKT (text) representation).
> > You can probably find everything : http://www.opengeospatial.org
> > Spatialite is also a good source
> > .
> >
> >
> > On Fri, 19 Oct 2018 at 22:47, Richard Hipp  wrote:
> >
> >> On 10/19/18, Thomas Kurz  wrote:
> >>>> Beginning with the next release, polygons will always be stored in the
> >>>> binary format.
> >>> Is the SQLite binary encoding identical to the Well-Known-Binary
> geometry
> >>> format?
> >> That might have happened, except the WKB format was not known to me...
> >> Where can I find information about WKB?
> >>
> >> --
> >> D. Richard Hipp
> >> d...@sqlite.org
> >> ___
> >> sqlite-users mailing list
> >> sqlite-users@mailinglists.sqlite.org
> >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >>
> >
>
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] geopoly data input options

[Noel Frankinet]

There a WKB and WKT (text) representation).
You can probably find everything : http://www.opengeospatial.org
Spatialite is also a good source
.


On Fri, 19 Oct 2018 at 22:47, Richard Hipp  wrote:

> On 10/19/18, Thomas Kurz  wrote:
> >> Beginning with the next release, polygons will always be stored in the
> >> binary format.
> >
> > Is the SQLite binary encoding identical to the Well-Known-Binary geometry
> > format?
>
> That might have happened, except the WKB format was not known to me...
> Where can I find information about WKB?
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] x64 binary

[Noel Frankinet]

Not really an answer, but it's easier to compile directly the source of
sqlite with your files. Only one .c file, no dependency, no 32 or 64 bit
problem, no installation problem.

Best wishes.
Noël

On 29 June 2016 at 01:05, BOSECKER Nancy  wrote:

> Hi,
>
> I have a very basic problem, maybe someone can help.
>
> I'm trying to use sqlite3.dll in an x64 application (VS 2008).
> So, I downloaded the x64 zip from the SQLite download page, unzipped it.
> I put the .dll, .lib, and .def files in my project's directory.
> I added the .lib to the Linker->Input -> Additional Dependencies in VS.
> I wrote a test snippet of code that calls sqlite3_close().
>
> When I compile, I get an unresolved external symbol on sqlite3_close().
>
> If I do the same thing with the x86 version of the binaries, and change my
> project target to Win32, it compiles as expected.
>
> What am I missing?
>
> Thx,
> Nancy
>
>
>
>
> This email and any attachments are intended solely for the use of the
> individual or entity to whom it is addressed and may be confidential and/or
> privileged.
>
> If you are not one of the named recipients or have received this email in
> error,
>
> (i) you should not read, disclose, or copy it,
>
> (ii) please notify sender of your receipt by reply email and delete this
> email and all attachments,
>
> (iii) Dassault Systemes does not accept or assume any liability or
> responsibility for any use of or reliance on this email.
>
> For other languages, go to http://www.3ds.com/terms/email-disclaimer
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sweet 16

[Noel Frankinet]

I ported sqlite to windowsCe in 2003, I didn't know I was so soon !
Congratulation to an incredible piece of code !

Best wishes.
Noël



On 30 May 2016 at 05:47, Darren Duncan  wrote:

> On 2016-05-29 10:28 AM, Richard Hipp wrote:
>
>> The first check-in of SQLite code occurred 16 years ago today.
>> https://www.sqlite.org/src/timeline?c=2000-05-29
>>
>
> Congratulations on that!  Thank you for all of that work.  Stay strong and
> keep moving on.
>
> Coincidentally, that first commit date is within a month or so of the
> first time I ever released open-source code to the public (on CPAN).
>
> -- Darren Duncan
>
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] CREATE TABLE parser

[Noel Frankinet]

Hello,

Great work, but why not generate it with bison/flex ? sql grammar is
available ?

Just a question ?

No?l


On 2 March 2016 at 14:47, Marco Bambini  wrote:

>
> > On 02 Mar 2016, at 13:32, Luca Ferrari  wrote:
> >
> > On Wed, Mar 2, 2016 at 1:10 PM, Marco Bambini  wrote:
> >> I developed the parser myself.
> >
> > Great job but...what is the aim?
> > Why one should use this instead of, let's say, Perl SQL::Parser
> > ?
>
> Probably because it can be easily embedded in C and is it also way faster
> and a lot requires less memory.
>
> --
> Marco Bambini
> http://www.sqlabs.com
> http://twitter.com/sqlabs
> http://instagram.com/sqlabs
>
> >
> > Luca
> > ___
> > sqlite-users mailing list
> > sqlite-users at mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
No?l Frankinet
Strategis sprl
0478/90.92.54

Re: [sqlite] sliteonline or sqlite in js

[Noel Frankinet]

Impressive !

On 12 November 2014 12:08, Kirill  wrote:

> Good day,
>
> Full line manager to work with sqlite directly
> from the browser on any platform:
> http://sqliteonline.com/
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] GUI INfo

[Noel Frankinet]

C++ or Python / Qt/PySide

On 10 September 2014 02:05, jose isaias cabrera 
wrote:

> "Warren Young" wrote...
>
>  On 9/10/2014 14:56, Maxine Nietz wrote:
>>
>>> I am an experienced Access VBA programmer. I know about the SQLite
>>> commands
>>> to create and manipulate data in tables and queries.
>>>
>>>
>>>
>>> What I want to know is where do I find info on creating a graphical user
>>> interface such as menus, forms and reports. What additional programs are
>>> required to do this?
>>>
>>
>> C#.
>>
> D.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Variable values in Views

[Noel Frankinet]

There a tcl binding to sqlite, maybe it could help you ?

Noël


On 30 July 2014 08:44, Sylvain Pointeau  wrote:

> It is called parameterized view in sqlserver.
> Actually it is extremely useful in order to have a good reusability in the
> code.
> I was actually missing it in Oracle, although I found a workaround of using
> the pipelined functions.
>
> Unfortunately, it is missing in sqlite, as well as the merge statement,
> also very useful (insert or replace has just to be avoided)
>
> What I used to make is to use a shell script, and to use sed to replace my
> variable before executing the script... Far from ideal but it worked ok, it
> is just annoying because we have to prepare the file first.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] R-Tree Storage Optimization for Points

[Noel Frankinet]

It should be painless if you omit geos, I think.


On 19 June 2014 09:00, Mohit Sindhwani <m...@onghu.com> wrote:

> Hi Noël,
>
> Thanks for our reply.
>
>
> On 19/6/2014 2:19 PM, Noel Frankinet wrote:
>
>> Hi Mohit,
>>
>> Maybe you should use the spatialite extension ?
>>
>> Noël
>>
>
> I have to see if indeed spatialite handles the data more efficiently since
> it also relies on the R-Tree for quite a bit of stuff.  That said, I do
> remember that once upon a time (admittedly 3 - 4 years ago), we had trouble
> getting Spatialite compiled for a Windows CE target.  Maybe, it is time to
> revisit that again.
>
>
> Best Regards,
>
> Mohit.
>
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] R-Tree Storage Optimization for Points

[Noel Frankinet]

Hi Mohit,

Maybe you should use the spatialite extension ?

Noël


On 19 June 2014 06:27, Mohit Sindhwani  wrote:

> Hello!  We are using SQLite3 for storing geographical points that can be
> queried using a bounding box (find everything that lies within this box).
>  Obviously, this query fits the capabilities of the RTree module very well
> and it is a simple 2 dimensional search using an R-Tree that has 5 columns.
>
> However, since these are points that are stored in the table, x1=x2 and
> y1=y2 when we do the insertion.  As a former embedded systems engineer,
> this feels like a waste since I can see that we are inserting exactly the
> same value into the table.
>
> INSERT into data_rtree(1000, 10, 5, 10, 5);
> INSERT into data_rtree(1000, 17, 1, 17, 1);
> and so on.
>
> Is there a way that we could optimize the module so that we don't need to
> store the same value twice?  We are using this on a system with constrained
> resources, so it helps to reduce the amount of storage space we need for
> our database.
>
> Thanks,
> Mohit.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Suggestion for shell .IMPORT improvement

[Noel Frankinet]

I propose Musqlar, the Mighty universal sql Archiver :-)


On 22 May 2014 15:22, Dominique Devienne  wrote:

> On Thu, May 22, 2014 at 1:51 PM, Richard Hipp  wrote:
> > How about "sqlar"  for "SQL Archive"?  http://www.sqlite.org/sqlar
>
> I like it! Sounds ominous when pronounced out loud :).
>
> Much better name IMHO, and no negative connotation in French that I
> know of. --DD
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Any interest for open source multi-user 'SQLite database server' application?

[Noel Frankinet]

so there is to client library to link to ? a simple layer that would mimic
the sqlite interface and do all the xml encoding/decoding and communication
could be handy ?


On 2 April 2014 16:09, Harmen de Jong - CoachR Group B.V.  wrote:

> >that would be interesting. Is the C interface from your client exactly
> like the C interface of sqlite ?
>
> Since it is a server application, this server application itself accesses
> SQLite directly via C-API (so this server application uses indeed the C
> library of SQLite).
>
> However the client needs some way to connect to and communicate with this
> SQLite server. In our case we have chosen to use XML messages over socket
> to communicate with the server. Please have a look at the first post to
> find some examples of how to send your SQL code and prepare statements to
> the SQLite server application.
>
> Best regards,
> Harmen
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Any interest for open source multi-user 'SQLite database server' application?

[Noel Frankinet]

that would be interesting. Is the C interface from your client exactly like
the C interface of sqlite ?


On 2 April 2014 14:44, Harmen de Jong - CoachR Group B.V. <har...@coachr.com
> wrote:

> >Do you think it could be used with spatialite extension to build a
> multi-user spatial database ?
> >
> >Noel Frankinet
>
> We don't have experience with Spatialite. However, we had a quick look at
> it and think it should not be too hard to support this from our SQLite
> database server app.
>
> Best regards,
> Harmen de Jong
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] select all fields of a column in one table that are not in a column in another table

[Noel Frankinet]

oups, sorry !


On 17 October 2013 16:36, Noel Frankinet <noel.franki...@gmail.com> wrote:

> L'accesoire indispensable :
>
> http://www.adafruit.com/products/1533
>
>
> On 17 October 2013 16:29, dean gwilliam <mgbg25...@blueyonder.co.uk>wrote:
>
>> On 17/10/2013 14:45, Igor Tandetnik wrote:
>>
>>> On 10/17/2013 3:35 AM, dean gwilliam wrote:
>>>
>>>> On 16/10/2013 22:04, Igor Tandetnik wrote:
>>>>
>>>>> On 10/16/2013 4:49 PM, dean gwilliam wrote:
>>>>>
>>>>>> if I have two tables
>>>>>> 1 aliases (std_name, raw_name)
>>>>>> 2 items (name..)
>>>>>> what would the query look like to select all "name" fields in "itms"
>>>>>> that match neither "std_name" or "raw_name" in "aliases"
>>>>>> and where the resulting list of "name"s contains no duplicates.
>>>>>>
>>>>>
>>>>> select distinct name from items
>>>>> where not exists (select 1 from aliases where std_name = name or
>>>>> raw_name = name);
>>>>>
>>>>>  Thank you very much Igor. Your answer is very much appreciated.
>>>> It seems that "std_name" would be better placed in another table eg
>>>> "std_names" and I'm not sure how you'd change the query to reflect the
>>>> extra table
>>>>
>>>
>>> select distinct name from items
>>> where name not in (select std_name from std_names)
>>> and name not in (select raw_name from aliases);
>>>
>>> -- or
>>>
>>> select distinct name from items
>>> where name not in (
>>>   select std_name from std_names
>>>   union all
>>>   select raw_name from aliases
>>> );
>>>
>>>  Igor.
>> Thank you very much indeed!
>>
>> __**_
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
>>
>
>
>
> --
> Noël Frankinet
> Strategis sprl
> 0478/90.92.54
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] select all fields of a column in one table that are not in a column in another table

[Noel Frankinet]

L'accesoire indispensable :

http://www.adafruit.com/products/1533


On 17 October 2013 16:29, dean gwilliam  wrote:

> On 17/10/2013 14:45, Igor Tandetnik wrote:
>
>> On 10/17/2013 3:35 AM, dean gwilliam wrote:
>>
>>> On 16/10/2013 22:04, Igor Tandetnik wrote:
>>>
 On 10/16/2013 4:49 PM, dean gwilliam wrote:

> if I have two tables
> 1 aliases (std_name, raw_name)
> 2 items (name..)
> what would the query look like to select all "name" fields in "itms"
> that match neither "std_name" or "raw_name" in "aliases"
> and where the resulting list of "name"s contains no duplicates.
>

 select distinct name from items
 where not exists (select 1 from aliases where std_name = name or
 raw_name = name);

  Thank you very much Igor. Your answer is very much appreciated.
>>> It seems that "std_name" would be better placed in another table eg
>>> "std_names" and I'm not sure how you'd change the query to reflect the
>>> extra table
>>>
>>
>> select distinct name from items
>> where name not in (select std_name from std_names)
>> and name not in (select raw_name from aliases);
>>
>> -- or
>>
>> select distinct name from items
>> where name not in (
>>   select std_name from std_names
>>   union all
>>   select raw_name from aliases
>> );
>>
>>  Igor.
> Thank you very much indeed!
>
> __**_
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] float to string conversion problem

[Noel Frankinet]

Hello,

The pda probably has no floating point support, you should check how sqlite
as been compiled.
Best wishes
Noël


On 14 June 2013 14:19, Arjen Markus  wrote:

> Hi Filipe,
>
>
> On Thu, 13 Jun 2013 15:59:35 +0100
>  Filipe Madureira 
> >
> wrote:
>
>> Hi,
>>
>> I have a problem executing a query on a WinCE6 ARM device.
>> I use SQlite for years and tested on all types of devices including
>> WinCE6 ARM and never had a problem.
>>
>> But I have one problem on particular device that has a Texas Instruments
>> ARM CPU with WinCE6.
>> A very simple way to reproduce my problem is:
>> Create Table t1(c1 DECIMAL(12,3))
>> Insert Into t1(c1) values(2.55)
>> Select c1 From t1
>>
>> I run this "Select" with sqlite3_get_table()
>> The value I get is "3.,+"
>>
>> It makes no sense, it is not even a number, and only happens if the
>> decimal values have a number higher than 5.
>> This seems to be a problem with this CPU/WinCE version.
>>
>> I don't know SQLite source code, and it is huge, so can someone tell me
>> where in the source code the float (or double, I don't know) value of 2.55
>> is being converted to a string to be outputed by sqlite3_get_table()?
>> Or any hint on how to track the problem?
>>
>> Note: I copied the database file to my PC and the value stored there is
>> 2.55, so the problem is retrieving the value on the device.
>>
>>
> I have no solution to offer and you probably thought of it
> yourseld too, but the + might be an attempt (rather
> superfluous and annoying) to indicate upward rounding
> took place.
>
> Does this happen with an ordinary C program too? The culprit
> would be the printf() family as implemented on the platform.
> Can scanf() read this type of numbers?
>
> Regards,
>
> Arjen
>
>
>
> DISCLAIMER: This message is intended exclusively for the addressee(s) and
> may contain confidential and privileged information. If you are not the
> intended recipient please notify the sender immediately and destroy this
> message. Unauthorized use, disclosure or copying of this message is
> strictly prohibited.
> The foundation 'Stichting Deltares', which has its seat at Delft, The
> Netherlands, Commercial Registration Number 41146461, is not liable in any
> way whatsoever for consequences and/or damages resulting from the improper,
> incomplete and untimely dispatch, receipt and/or content of this e-mail.
>
>
>
>
>
> __**_
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite Sample Source Codes For Windows CE/Mobile

[Noel Frankinet]

it's different (not the sqlite engine in c# but just the interface). The
interface is up to date, and maintained with the core engine.
But the binary is for x86 windows.


On 31 May 2013 14:30, Bernd Lehmkuhl <be...@web.de> wrote:

> This is not correct. It's up definitely up to date:
>
> https://system.data.sqlite.**org/downloads/1.0.86.0/sqlite-**
> netFx35-binary-PocketPC-ARM-**2008-1.0.86.0.zip<https://system.data.sqlite.org/downloads/1.0.86.0/sqlite-netFx35-binary-PocketPC-ARM-2008-1.0.86.0.zip>
>
> Available at:
> https://system.data.sqlite.**org/index.html/doc/trunk/www/**downloads.wiki<https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki>
>
> "This binary package contains all the binaries for the PocketPC version of
> the System.Data.SQLite 1.0.86.0 (3.7.17) package. The .NET Compact
> Framework 3.5 is required."
>
>
>
> Am 31.05.2013 13:28, schrieb Noel Frankinet:
>
>  and it's already on year behind the official c sqlite. I wouldn't go that
>> route
>>
>>
>> On 31 May 2013 13:26, Noel Frankinet <noel.franki...@gmail.com> wrote:
>>
>>  oh, yes everything in c# then, let's see the performance on an arm cpu !
>>>
>>>
>>> On 31 May 2013 13:23, Noel Frankinet <noel.franki...@gmail.com> wrote:
>>>
>>>  ah, sorry, I will never understand why everybody wants to add a virtual
>>>> machine on an already feeble machine. Then you will have to deal wil a
>>>> extra layer of complexity ( you need a assembly that will translate from
>>>> managed code to unmanaged). You will probably have to compile it
>>>> yourself,
>>>> since its probably an arm CPU. Good luck !
>>>>
>>>>
>>>> On 31 May 2013 13:16, Ali Dirik <explore...@gmail.com> wrote:
>>>>
>>>>  Thanks for answers.
>>>>>
>>>>> I use c# (VS2008)
>>>>> I am looking for c# sample source code.
>>>>>
>>>>>
>>>>> 2013/5/31 Noel Frankinet <noel.franki...@gmail.com>
>>>>>
>>>>>  I've used C++, do you want to use anything else. It's of course easier
>>>>>>
>>>>> in
>>>>>
>>>>>> C++ since sqlite is in C. You link statically, nothing to install.
>>>>>>
>>>>>>
>>>>>> On 31 May 2013 12:21, <fnoyan...@yahoo.com> wrote:
>>>>>>
>>>>>>  This is the first shot from google
>>>>>>> http://sqlite-wince.**sourceforge.net/index.html<http://sqlite-wince.sourceforge.net/index.html>
>>>>>>>
>>>>>>> If you'd like to use sqlitecin your app, I do not think it will be an
>>>>>>> issue for any playform once you have the proper C compiler. You may
>>>>>>>
>>>>>> try
>>>>>
>>>>>> to
>>>>>>
>>>>>>> statically compiling your application.
>>>>>>>
>>>>>>> On 31/05/2013, at 7:42 PM, Ali Dirik <explore...@gmail.com> wrote:
>>>>>>>
>>>>>>>  Hello Noel Frankinet,
>>>>>>>>
>>>>>>>> Thank you for your answer.
>>>>>>>> I using a hand-held terminal (
>>>>>>>> http://www.ute.com/products_**info.php?pc1=1=3=0&**pid=703<http://www.ute.com/products_info.php?pc1=1=3=0=703>
>>>>>>>> )
>>>>>>>>
>>>>>>> with
>>>>>
>>>>>> windows
>>>>>>>
>>>>>>>> mobile operating system.
>>>>>>>> We use this device for counting.
>>>>>>>> There is already an application that works with SQLCE (Microsoft
>>>>>>>>
>>>>>>> SQL
>>>>>
>>>>>> Compact Edition)
>>>>>>>> I want to use SQLite instead of SQL CE.
>>>>>>>> I found a sample source code on the Internet (
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>  http://www.codeproject.com/**Articles/22165/Using-SQLite-**
>>>>> in-your-C-Application<http://www.codeproject.com/Articles/22165/Using-SQLite-in-your-C-Application>
>>>>>
>>>>>> )
>>>>>>>> I've tried it, but did not succeed source code.
>>>>>>>> Do you have an

Re: [sqlite] Sqlite Sample Source Codes For Windows CE/Mobile

[Noel Frankinet]

one last consideration, on android and ios (about the same CPU power), they
use sqlite native, nota java translation.
Is you application requiring c# in any way ?


On 31 May 2013 13:28, Noel Frankinet <noel.franki...@gmail.com> wrote:

> and it's already on year behind the official c sqlite. I wouldn't go that
> route
>
>
> On 31 May 2013 13:26, Noel Frankinet <noel.franki...@gmail.com> wrote:
>
>> oh, yes everything in c# then, let's see the performance on an arm cpu !
>>
>>
>> On 31 May 2013 13:23, Noel Frankinet <noel.franki...@gmail.com> wrote:
>>
>>> ah, sorry, I will never understand why everybody wants to add a virtual
>>> machine on an already feeble machine. Then you will have to deal wil a
>>> extra layer of complexity ( you need a assembly that will translate from
>>> managed code to unmanaged). You will probably have to compile it yourself,
>>> since its probably an arm CPU. Good luck !
>>>
>>>
>>> On 31 May 2013 13:16, Ali Dirik <explore...@gmail.com> wrote:
>>>
>>>> Thanks for answers.
>>>>
>>>> I use c# (VS2008)
>>>> I am looking for c# sample source code.
>>>>
>>>>
>>>> 2013/5/31 Noel Frankinet <noel.franki...@gmail.com>
>>>>
>>>> > I've used C++, do you want to use anything else. It's of course
>>>> easier in
>>>> > C++ since sqlite is in C. You link statically, nothing to install.
>>>> >
>>>> >
>>>> > On 31 May 2013 12:21, <fnoyan...@yahoo.com> wrote:
>>>> >
>>>> > > This is the first shot from google
>>>> > > http://sqlite-wince.sourceforge.net/index.html
>>>> > >
>>>> > > If you'd like to use sqlitecin your app, I do not think it will be
>>>> an
>>>> > > issue for any playform once you have the proper C compiler. You may
>>>> try
>>>> > to
>>>> > > statically compiling your application.
>>>> > >
>>>> > > On 31/05/2013, at 7:42 PM, Ali Dirik <explore...@gmail.com> wrote:
>>>> > >
>>>> > > > Hello Noel Frankinet,
>>>> > > >
>>>> > > > Thank you for your answer.
>>>> > > > I using a hand-held terminal (
>>>> > > > http://www.ute.com/products_info.php?pc1=1=3=0=703)
>>>> with
>>>> > > windows
>>>> > > > mobile operating system.
>>>> > > > We use this device for counting.
>>>> > > > There is already an application that works with SQLCE (Microsoft
>>>> SQL
>>>> > > > Compact Edition)
>>>> > > > I want to use SQLite instead of SQL CE.
>>>> > > > I found a sample source code on the Internet (
>>>> > > >
>>>> > >
>>>> >
>>>> http://www.codeproject.com/Articles/22165/Using-SQLite-in-your-C-Application
>>>> > > > )
>>>> > > > I've tried it, but did not succeed source code.
>>>> > > > Do you have any idea about this?
>>>> > > >
>>>> > > > Best Regards
>>>> > > > Ali Dirik
>>>> > > >
>>>> > > >
>>>> > > > 2013/5/31 Ali Dirik <explore...@gmail.com>
>>>> > > >
>>>> > > >> Dear Friends,
>>>> > > >>
>>>> > > >> I want to develop a application that runs Windows CE or Mobile
>>>> > devices.
>>>> > > >> I want to use the Sqlite database.
>>>> > > >> May I find same sample source codes?
>>>> > > >>
>>>> > > >> Best Regards
>>>> > > >> Ali D
>>>> > > >> i
>>>> > > >> rik
>>>> > > >
>>>> > > >
>>>> > > >
>>>> > > > --
>>>> > > > İyi Çalışmalar
>>>> > > > Ali DİRİK
>>>> > > > ___
>>>> > > > sqlite-users mailing list
>>>> > > > sqlite-users@sqlite.org
>>>> > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>> > > ___
>>>> > > sqlite-users mailing list
>>>> > > sqlite-users@sqlite.org
>>>> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>> > >
>>>> >
>>>> >
>>>> >
>>>> > --
>>>> > Noël Frankinet
>>>> > Strategis sprl
>>>> > 0478/90.92.54
>>>> > ___
>>>> > sqlite-users mailing list
>>>> > sqlite-users@sqlite.org
>>>> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>> >
>>>>
>>>>
>>>>
>>>> --
>>>> İyi Çalışmalar
>>>> Ali DİRİK
>>>> ___
>>>> sqlite-users mailing list
>>>> sqlite-users@sqlite.org
>>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>>
>>>
>>>
>>>
>>> --
>>> Noël Frankinet
>>> Strategis sprl
>>> 0478/90.92.54
>>>
>>
>>
>>
>> --
>> Noël Frankinet
>> Strategis sprl
>> 0478/90.92.54
>>
>
>
>
> --
> Noël Frankinet
> Strategis sprl
> 0478/90.92.54
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite Sample Source Codes For Windows CE/Mobile

[Noel Frankinet]

and it's already on year behind the official c sqlite. I wouldn't go that
route


On 31 May 2013 13:26, Noel Frankinet <noel.franki...@gmail.com> wrote:

> oh, yes everything in c# then, let's see the performance on an arm cpu !
>
>
> On 31 May 2013 13:23, Noel Frankinet <noel.franki...@gmail.com> wrote:
>
>> ah, sorry, I will never understand why everybody wants to add a virtual
>> machine on an already feeble machine. Then you will have to deal wil a
>> extra layer of complexity ( you need a assembly that will translate from
>> managed code to unmanaged). You will probably have to compile it yourself,
>> since its probably an arm CPU. Good luck !
>>
>>
>> On 31 May 2013 13:16, Ali Dirik <explore...@gmail.com> wrote:
>>
>>> Thanks for answers.
>>>
>>> I use c# (VS2008)
>>> I am looking for c# sample source code.
>>>
>>>
>>> 2013/5/31 Noel Frankinet <noel.franki...@gmail.com>
>>>
>>> > I've used C++, do you want to use anything else. It's of course easier
>>> in
>>> > C++ since sqlite is in C. You link statically, nothing to install.
>>> >
>>> >
>>> > On 31 May 2013 12:21, <fnoyan...@yahoo.com> wrote:
>>> >
>>> > > This is the first shot from google
>>> > > http://sqlite-wince.sourceforge.net/index.html
>>> > >
>>> > > If you'd like to use sqlitecin your app, I do not think it will be an
>>> > > issue for any playform once you have the proper C compiler. You may
>>> try
>>> > to
>>> > > statically compiling your application.
>>> > >
>>> > > On 31/05/2013, at 7:42 PM, Ali Dirik <explore...@gmail.com> wrote:
>>> > >
>>> > > > Hello Noel Frankinet,
>>> > > >
>>> > > > Thank you for your answer.
>>> > > > I using a hand-held terminal (
>>> > > > http://www.ute.com/products_info.php?pc1=1=3=0=703)
>>> with
>>> > > windows
>>> > > > mobile operating system.
>>> > > > We use this device for counting.
>>> > > > There is already an application that works with SQLCE (Microsoft
>>> SQL
>>> > > > Compact Edition)
>>> > > > I want to use SQLite instead of SQL CE.
>>> > > > I found a sample source code on the Internet (
>>> > > >
>>> > >
>>> >
>>> http://www.codeproject.com/Articles/22165/Using-SQLite-in-your-C-Application
>>> > > > )
>>> > > > I've tried it, but did not succeed source code.
>>> > > > Do you have any idea about this?
>>> > > >
>>> > > > Best Regards
>>> > > > Ali Dirik
>>> > > >
>>> > > >
>>> > > > 2013/5/31 Ali Dirik <explore...@gmail.com>
>>> > > >
>>> > > >> Dear Friends,
>>> > > >>
>>> > > >> I want to develop a application that runs Windows CE or Mobile
>>> > devices.
>>> > > >> I want to use the Sqlite database.
>>> > > >> May I find same sample source codes?
>>> > > >>
>>> > > >> Best Regards
>>> > > >> Ali D
>>> > > >> i
>>> > > >> rik
>>> > > >
>>> > > >
>>> > > >
>>> > > > --
>>> > > > İyi Çalışmalar
>>> > > > Ali DİRİK
>>> > > > ___
>>> > > > sqlite-users mailing list
>>> > > > sqlite-users@sqlite.org
>>> > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>> > > ___
>>> > > sqlite-users mailing list
>>> > > sqlite-users@sqlite.org
>>> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>> > >
>>> >
>>> >
>>> >
>>> > --
>>> > Noël Frankinet
>>> > Strategis sprl
>>> > 0478/90.92.54
>>> > ___
>>> > sqlite-users mailing list
>>> > sqlite-users@sqlite.org
>>> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>> >
>>>
>>>
>>>
>>> --
>>> İyi Çalışmalar
>>> Ali DİRİK
>>> ___
>>> sqlite-users mailing list
>>> sqlite-users@sqlite.org
>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>
>>
>>
>>
>> --
>> Noël Frankinet
>> Strategis sprl
>> 0478/90.92.54
>>
>
>
>
> --
> Noël Frankinet
> Strategis sprl
> 0478/90.92.54
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite Sample Source Codes For Windows CE/Mobile

[Noel Frankinet]

oh, yes everything in c# then, let's see the performance on an arm cpu !


On 31 May 2013 13:23, Noel Frankinet <noel.franki...@gmail.com> wrote:

> ah, sorry, I will never understand why everybody wants to add a virtual
> machine on an already feeble machine. Then you will have to deal wil a
> extra layer of complexity ( you need a assembly that will translate from
> managed code to unmanaged). You will probably have to compile it yourself,
> since its probably an arm CPU. Good luck !
>
>
> On 31 May 2013 13:16, Ali Dirik <explore...@gmail.com> wrote:
>
>> Thanks for answers.
>>
>> I use c# (VS2008)
>> I am looking for c# sample source code.
>>
>>
>> 2013/5/31 Noel Frankinet <noel.franki...@gmail.com>
>>
>> > I've used C++, do you want to use anything else. It's of course easier
>> in
>> > C++ since sqlite is in C. You link statically, nothing to install.
>> >
>> >
>> > On 31 May 2013 12:21, <fnoyan...@yahoo.com> wrote:
>> >
>> > > This is the first shot from google
>> > > http://sqlite-wince.sourceforge.net/index.html
>> > >
>> > > If you'd like to use sqlitecin your app, I do not think it will be an
>> > > issue for any playform once you have the proper C compiler. You may
>> try
>> > to
>> > > statically compiling your application.
>> > >
>> > > On 31/05/2013, at 7:42 PM, Ali Dirik <explore...@gmail.com> wrote:
>> > >
>> > > > Hello Noel Frankinet,
>> > > >
>> > > > Thank you for your answer.
>> > > > I using a hand-held terminal (
>> > > > http://www.ute.com/products_info.php?pc1=1=3=0=703)
>> with
>> > > windows
>> > > > mobile operating system.
>> > > > We use this device for counting.
>> > > > There is already an application that works with SQLCE (Microsoft SQL
>> > > > Compact Edition)
>> > > > I want to use SQLite instead of SQL CE.
>> > > > I found a sample source code on the Internet (
>> > > >
>> > >
>> >
>> http://www.codeproject.com/Articles/22165/Using-SQLite-in-your-C-Application
>> > > > )
>> > > > I've tried it, but did not succeed source code.
>> > > > Do you have any idea about this?
>> > > >
>> > > > Best Regards
>> > > > Ali Dirik
>> > > >
>> > > >
>> > > > 2013/5/31 Ali Dirik <explore...@gmail.com>
>> > > >
>> > > >> Dear Friends,
>> > > >>
>> > > >> I want to develop a application that runs Windows CE or Mobile
>> > devices.
>> > > >> I want to use the Sqlite database.
>> > > >> May I find same sample source codes?
>> > > >>
>> > > >> Best Regards
>> > > >> Ali D
>> > > >> i
>> > > >> rik
>> > > >
>> > > >
>> > > >
>> > > > --
>> > > > İyi Çalışmalar
>> > > > Ali DİRİK
>> > > > ___
>> > > > sqlite-users mailing list
>> > > > sqlite-users@sqlite.org
>> > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>> > > ___
>> > > sqlite-users mailing list
>> > > sqlite-users@sqlite.org
>> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>> > >
>> >
>> >
>> >
>> > --
>> > Noël Frankinet
>> > Strategis sprl
>> > 0478/90.92.54
>> > ___
>> > sqlite-users mailing list
>> > sqlite-users@sqlite.org
>> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>> >
>>
>>
>>
>> --
>> İyi Çalışmalar
>> Ali DİRİK
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
>
> --
> Noël Frankinet
> Strategis sprl
> 0478/90.92.54
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite Sample Source Codes For Windows CE/Mobile

[Noel Frankinet]

ah, sorry, I will never understand why everybody wants to add a virtual
machine on an already feeble machine. Then you will have to deal wil a
extra layer of complexity ( you need a assembly that will translate from
managed code to unmanaged). You will probably have to compile it yourself,
since its probably an arm CPU. Good luck !


On 31 May 2013 13:16, Ali Dirik <explore...@gmail.com> wrote:

> Thanks for answers.
>
> I use c# (VS2008)
> I am looking for c# sample source code.
>
>
> 2013/5/31 Noel Frankinet <noel.franki...@gmail.com>
>
> > I've used C++, do you want to use anything else. It's of course easier in
> > C++ since sqlite is in C. You link statically, nothing to install.
> >
> >
> > On 31 May 2013 12:21, <fnoyan...@yahoo.com> wrote:
> >
> > > This is the first shot from google
> > > http://sqlite-wince.sourceforge.net/index.html
> > >
> > > If you'd like to use sqlitecin your app, I do not think it will be an
> > > issue for any playform once you have the proper C compiler. You may try
> > to
> > > statically compiling your application.
> > >
> > > On 31/05/2013, at 7:42 PM, Ali Dirik <explore...@gmail.com> wrote:
> > >
> > > > Hello Noel Frankinet,
> > > >
> > > > Thank you for your answer.
> > > > I using a hand-held terminal (
> > > > http://www.ute.com/products_info.php?pc1=1=3=0=703) with
> > > windows
> > > > mobile operating system.
> > > > We use this device for counting.
> > > > There is already an application that works with SQLCE (Microsoft SQL
> > > > Compact Edition)
> > > > I want to use SQLite instead of SQL CE.
> > > > I found a sample source code on the Internet (
> > > >
> > >
> >
> http://www.codeproject.com/Articles/22165/Using-SQLite-in-your-C-Application
> > > > )
> > > > I've tried it, but did not succeed source code.
> > > > Do you have any idea about this?
> > > >
> > > > Best Regards
> > > > Ali Dirik
> > > >
> > > >
> > > > 2013/5/31 Ali Dirik <explore...@gmail.com>
> > > >
> > > >> Dear Friends,
> > > >>
> > > >> I want to develop a application that runs Windows CE or Mobile
> > devices.
> > > >> I want to use the Sqlite database.
> > > >> May I find same sample source codes?
> > > >>
> > > >> Best Regards
> > > >> Ali D
> > > >> i
> > > >> rik
> > > >
> > > >
> > > >
> > > > --
> > > > İyi Çalışmalar
> > > > Ali DİRİK
> > > > ___
> > > > sqlite-users mailing list
> > > > sqlite-users@sqlite.org
> > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > > ___
> > > sqlite-users mailing list
> > > sqlite-users@sqlite.org
> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > >
> >
> >
> >
> > --
> > Noël Frankinet
> > Strategis sprl
> > 0478/90.92.54
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> --
> İyi Çalışmalar
> Ali DİRİK
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite Sample Source Codes For Windows CE/Mobile

[Noel Frankinet]

I've used C++, do you want to use anything else. It's of course easier in
C++ since sqlite is in C. You link statically, nothing to install.


On 31 May 2013 12:21, <fnoyan...@yahoo.com> wrote:

> This is the first shot from google
> http://sqlite-wince.sourceforge.net/index.html
>
> If you'd like to use sqlitecin your app, I do not think it will be an
> issue for any playform once you have the proper C compiler. You may try to
> statically compiling your application.
>
> On 31/05/2013, at 7:42 PM, Ali Dirik <explore...@gmail.com> wrote:
>
> > Hello Noel Frankinet,
> >
> > Thank you for your answer.
> > I using a hand-held terminal (
> > http://www.ute.com/products_info.php?pc1=1=3=0=703) with
> windows
> > mobile operating system.
> > We use this device for counting.
> > There is already an application that works with SQLCE (Microsoft SQL
> > Compact Edition)
> > I want to use SQLite instead of SQL CE.
> > I found a sample source code on the Internet (
> >
> http://www.codeproject.com/Articles/22165/Using-SQLite-in-your-C-Application
> > )
> > I've tried it, but did not succeed source code.
> > Do you have any idea about this?
> >
> > Best Regards
> > Ali Dirik
> >
> >
> > 2013/5/31 Ali Dirik <explore...@gmail.com>
> >
> >> Dear Friends,
> >>
> >> I want to develop a application that runs Windows CE or Mobile devices.
> >> I want to use the Sqlite database.
> >> May I find same sample source codes?
> >>
> >> Best Regards
> >> Ali D
> >> i
> >> rik
> >
> >
> >
> > --
> > İyi Çalışmalar
> > Ali DİRİK
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite Sample Source Codes For Windows CE/Mobile

[Noel Frankinet]

Hello Ali,

I've done years ago, it's pretty much standard use. What do you want to do ?


On 31 May 2013 10:19, Ali Dirik  wrote:

> Dear Friends,
>
> I want to develop a application that runs Windows CE or Mobile devices.
> I want to use the Sqlite database.
> May I find same sample source codes?
>
> Best Regards
>
> Ali D
> i
> rik
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL Logic error or missing database

[Noel Frankinet]

yes that's the setup I use too, so I suspect something more complicated at
work (mismatch between h and c file ? check your include path ??)


On 5 April 2013 16:29, Michael Black  wrote:

> This works for me under Visual Studio 2010.  I couldn't seem to get a file
> uri to work at all either.
>
> #include 
> #include "sqlite3.h"
>
> main()
> {
>   sqlite3 *oDatabase;
>   int returnValue;
>   returnValue = sqlite3_open_v2("D:/SQlite/testing.db", ,
> SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, NULL);
>   if (returnValue != SQLITE_OK )
>   {
> printf("%d: %s\n",returnValue,sqlite3_errmsg(oDatabase));
>   }
>   else {
> printf("Got it\n");
>   }
> }
>
> -Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rob Collie
> Sent: Friday, April 05, 2013 9:25 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] SQL Logic error or missing database
>
> Same problem, I'm afraid. I've tried just about every combination suggested
> in http://www.sqlite.org/c3ref/open.html
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL Logic error or missing database

[Noel Frankinet]

it's time to check your compiler setting, anything weird ? Are you sure you
have the source code of sqlite for windows ? 32 or 64 bits settings ??


On 5 April 2013 16:24, Rob Collie  wrote:

> Same problem, I'm afraid. I've tried just about every combination suggested
> in http://www.sqlite.org/c3ref/open.html
>
>
> On Fri, Apr 5, 2013 at 4:18 PM, Kevin Benson  >wrote:
>
> > On Fri, Apr 5, 2013 at 10:08 AM, Rob Collie 
> wrote:
> >
> > > Yeap, I'm on Visual Studio 2012. I've created a console app:
> > >
> > >
> > >  sqlite3 *oDatabase;
> > >  int returnValue;
> > >  returnValue = sqlite3_open_v2("file://C:/Newfolder/testing.db",
> > > & oDatabase, SQLITE_OPEN_CREATE, NULL);
> > >  if (returnValue != SQLITE_OK )
> > >  {
> > >   //sqlite3_close(oDatabase);
> > >   return returnValue ;
> > >  }
> > >  int anyKey;
> > >  return 0;
> > >
> > > It returns 21. Checking the other project, the open actually does
> return
> > 21
> > > too.
> > >
> >
> >
> > Three(3) forward slashes for the Internet path style in Windows, maybe?
> >
> > file:///C:/Newfolder/testing.db
> > --
> >--
> >   --
> >  --Ô¿Ô--
> > K e V i N
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL Logic error or missing database

[Noel Frankinet]

I would remove the "file://"


On 5 April 2013 16:08, Rob Collie  wrote:

> Yeap, I'm on Visual Studio 2012. I've created a console app:
>
>
>  sqlite3 *oDatabase;
>  int returnValue;
>  returnValue = sqlite3_open_v2("file://C:/Newfolder/testing.db",
> , SQLITE_OPEN_CREATE, NULL);
>  if (returnValue != SQLITE_OK )
>  {
>   //sqlite3_close(oDatabase);
>   return returnValue ;
>  }
>  int anyKey;
>  return 0;
>
> It returns 21. Checking the other project, the open actually does return 21
> too.
>
>
> On Fri, Apr 5, 2013 at 3:36 PM, Michael Black  wrote:
>
> > Also change the last arg of open to NULL instead of "".
> >
> >
> > -Original Message-
> > From: sqlite-users-boun...@sqlite.org
> > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rob Collie
> > Sent: Friday, April 05, 2013 7:54 AM
> > To: sqlite-users@sqlite.org
> > Subject: [sqlite] SQL Logic error or missing database
> >
> > Hello there,
> >
> > For my sins, I'm trying to create a library allowing our legacy fortran
> > code to work with SQL.
> >
> > Calling this from fortran...
> >
> > CALL EXECUTESQL('dbTest'//CHAR(0), cQuery, iReturnValue)
> > ...runs the following code, and yet the error returned is 'SQL Logic
> error
> > or missing database'. No file is ever created. Is there something dumb
> I'm
> > missing here?
> >
> >
> > extern "C"
> > {
> >
> >  void EXECUTESQL(char *dataBase, char *query, int returnValue)
> >  {
> >
> >   // Checking the incoming data from FORTRAN
> >   CStringW wName(dataBase);
> >   MessageBoxW( NULL, wName, L"Name: ", MB_OK );
> >
> >   // Create the object
> >   sqlite3 *oDatabase;
> >
> >   // Create the error objects
> >   char *sErrorMessage;
> >   // Open/create the table, if required
> >   returnValue = sqlite3_open_v2(dataBase, ,
> > SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, "");
> >   if (returnValue != SQLITE_OK )
> >   {
> >sqlite3_close(oDatabase);
> >MessageBoxA(NULL, sqlite3_errstr(returnValue), "SQL Open Error",
> MB_OK);
> >return;
> >   }
> >
> >
> > Rob.
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL Logic error or missing database

[Noel Frankinet]

something odd, check you compilation setup, are you on windows with visual
studio ? create a small console sample


On 5 April 2013 15:27, Rob Collie <rob.col...@gmail.com> wrote:

> Yeap. I've tested on the desktop, running as an admin user. I've tried the
> full path, with no luck.
>
> Should SQLITE_OPEN_READWRITE not be used with SQLITE_OPEN_CREATE? If I
> remove the SQLITE_OPEN_READWRITE flag, I get 'library routine called out of
> sequence' instead.
>
>
> Rob.
>
>
> On Fri, Apr 5, 2013 at 3:15 PM, Noel Frankinet <noel.franki...@gmail.com
> >wrote:
>
> > no it should be ok, check the place where testing.db should be created,
> do
> > you have write right ?
> >
> >
> > On 5 April 2013 15:12, Rob Collie <rob.col...@gmail.com> wrote:
> >
> > > It's a very odd problem. At first I was worried about character
> > > translations between fortran and C, but the following also fails:
> > >
> > >  returnValue = sqlite3_open_v2("testing.db", ,
> > > SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, "");
> > >
> > > I guess this rules out encoding too?
> > >
> > > Perhaps it's something to do with how the library is being created? I'm
> > > pretty much just including sqlite3.h, sqlite3ext.h, sqlite3.c in a C++
> > > project and compiling it as a static lib.
> > >
> > >
> > > Rob.
> > >
> > >
> > > On Fri, Apr 5, 2013 at 3:03 PM, Richard Hipp <d...@sqlite.org> wrote:
> > >
> > > > On Fri, Apr 5, 2013 at 9:02 AM, Richard Hipp <d...@sqlite.org> wrote:
> > > >
> > > > >
> > > > >
> > > > > On Fri, Apr 5, 2013 at 8:54 AM, Rob Collie <rob.col...@gmail.com>
> > > wrote:
> > > > >
> > > > >> Hello there,
> > > > >>
> > > > >> For my sins, I'm trying to create a library allowing our legacy
> > > fortran
> > > > >> code to work with SQL.
> > > > >>
> > > > >> Calling this from fortran...
> > > > >>
> > > > >> CALL EXECUTESQL('dbTest'//CHAR(0), cQuery, iReturnValue)
> > > > >> ...runs the following code, and yet the error returned is 'SQL
> Logic
> > > > error
> > > > >> or missing database'. No file is ever created. Is there something
> > dumb
> > > > I'm
> > > > >> missing here?
> > > > >>
> > > > >>
> > > > >> extern "C"
> > > > >> {
> > > > >>
> > > > >>  void EXECUTESQL(char *dataBase, char *query, int returnValue)
> > > > >>  {
> > > > >>
> > > > >>   // Checking the incoming data from FORTRAN
> > > > >>   CStringW wName(dataBase);
> > > > >>   MessageBoxW( NULL, wName, L"Name: ", MB_OK );
> > > > >>
> > > > >>   // Create the object
> > > > >>   sqlite3 *oDatabase;
> > > > >>
> > > > >>   // Create the error objects
> > > > >>   char *sErrorMessage;
> > > > >>   // Open/create the table, if required
> > > > >>   returnValue = sqlite3_open_v2(dataBase, ,
> > > > >>
> > > > >
> > > > > I think you want just "oDatabase", without the "&" prefix operator.
> > > > >
> > > >
> > > > No.  Scratch that.  I misread the code.  Ignore what I said.  I'm
> going
> > > to
> > > > get coffee now.
> > > >
> > > >
> > > > >
> > > > >
> > > > >> SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, "");
> > > > >>   if (returnValue != SQLITE_OK )
> > > > >>   {
> > > > >>sqlite3_close(oDatabase);
> > > > >>MessageBoxA(NULL, sqlite3_errstr(returnValue), "SQL Open
> Error",
> > > > >> MB_OK);
> > > > >>return;
> > > > >>   }
> > > > >>
> > > > >>
> > > > >> Rob.
> > > > >> ___
> > > > >> sqlite-users mailing list
> > > > >> sqlite-users@sqlite.org
> > > > >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > > > >>
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > D. Richard Hipp
> > > > > d...@sqlite.org
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > D. Richard Hipp
> > > > d...@sqlite.org
> > > > ___
> > > > sqlite-users mailing list
> > > > sqlite-users@sqlite.org
> > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > > >
> > > ___
> > > sqlite-users mailing list
> > > sqlite-users@sqlite.org
> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > >
> >
> >
> >
> > --
> > Noël Frankinet
> > Strategis sprl
> > 0478/90.92.54
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL Logic error or missing database

[Noel Frankinet]

SQLITE_OPEN_READWRITE<http://sqlite.org/capi3ref.html#SQLITE_OPEN_AUTOPROXY>
The database is opened for reading and writing if possible, or reading only
if the file is write protected by the operating system. In either case the
database must already exist, otherwise an error is returned.
Is it your problem ?


On 5 April 2013 15:15, Noel Frankinet <noel.franki...@gmail.com> wrote:

> no it should be ok, check the place where testing.db should be created, do
> you have write right ?
>
>
> On 5 April 2013 15:12, Rob Collie <rob.col...@gmail.com> wrote:
>
>> It's a very odd problem. At first I was worried about character
>> translations between fortran and C, but the following also fails:
>>
>>  returnValue = sqlite3_open_v2("testing.db", ,
>> SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, "");
>>
>> I guess this rules out encoding too?
>>
>> Perhaps it's something to do with how the library is being created? I'm
>> pretty much just including sqlite3.h, sqlite3ext.h, sqlite3.c in a C++
>> project and compiling it as a static lib.
>>
>>
>> Rob.
>>
>>
>> On Fri, Apr 5, 2013 at 3:03 PM, Richard Hipp <d...@sqlite.org> wrote:
>>
>> > On Fri, Apr 5, 2013 at 9:02 AM, Richard Hipp <d...@sqlite.org> wrote:
>> >
>> > >
>> > >
>> > > On Fri, Apr 5, 2013 at 8:54 AM, Rob Collie <rob.col...@gmail.com>
>> wrote:
>> > >
>> > >> Hello there,
>> > >>
>> > >> For my sins, I'm trying to create a library allowing our legacy
>> fortran
>> > >> code to work with SQL.
>> > >>
>> > >> Calling this from fortran...
>> > >>
>> > >> CALL EXECUTESQL('dbTest'//CHAR(0), cQuery, iReturnValue)
>> > >> ...runs the following code, and yet the error returned is 'SQL Logic
>> > error
>> > >> or missing database'. No file is ever created. Is there something
>> dumb
>> > I'm
>> > >> missing here?
>> > >>
>> > >>
>> > >> extern "C"
>> > >> {
>> > >>
>> > >>  void EXECUTESQL(char *dataBase, char *query, int returnValue)
>> > >>  {
>> > >>
>> > >>   // Checking the incoming data from FORTRAN
>> > >>   CStringW wName(dataBase);
>> > >>   MessageBoxW( NULL, wName, L"Name: ", MB_OK );
>> > >>
>> > >>   // Create the object
>> > >>   sqlite3 *oDatabase;
>> > >>
>> > >>   // Create the error objects
>> > >>   char *sErrorMessage;
>> > >>   // Open/create the table, if required
>> > >>   returnValue = sqlite3_open_v2(dataBase, ,
>> > >>
>> > >
>> > > I think you want just "oDatabase", without the "&" prefix operator.
>> > >
>> >
>> > No.  Scratch that.  I misread the code.  Ignore what I said.  I'm going
>> to
>> > get coffee now.
>> >
>> >
>> > >
>> > >
>> > >> SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, "");
>> > >>   if (returnValue != SQLITE_OK )
>> > >>   {
>> > >>sqlite3_close(oDatabase);
>> > >>MessageBoxA(NULL, sqlite3_errstr(returnValue), "SQL Open Error",
>> > >> MB_OK);
>> > >>return;
>> > >>   }
>> > >>
>> > >>
>> > >> Rob.
>> > >> ___
>> > >> sqlite-users mailing list
>> > >> sqlite-users@sqlite.org
>> > >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>> > >>
>> > >
>> > >
>> > >
>> > > --
>> > > D. Richard Hipp
>> > > d...@sqlite.org
>> >
>> >
>> >
>> >
>> > --
>> > D. Richard Hipp
>> > d...@sqlite.org
>> > ___
>> > sqlite-users mailing list
>> > sqlite-users@sqlite.org
>> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>> >
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
>
> --
> Noël Frankinet
> Strategis sprl
> 0478/90.92.54
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL Logic error or missing database

[Noel Frankinet]

no it should be ok, check the place where testing.db should be created, do
you have write right ?


On 5 April 2013 15:12, Rob Collie  wrote:

> It's a very odd problem. At first I was worried about character
> translations between fortran and C, but the following also fails:
>
>  returnValue = sqlite3_open_v2("testing.db", ,
> SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, "");
>
> I guess this rules out encoding too?
>
> Perhaps it's something to do with how the library is being created? I'm
> pretty much just including sqlite3.h, sqlite3ext.h, sqlite3.c in a C++
> project and compiling it as a static lib.
>
>
> Rob.
>
>
> On Fri, Apr 5, 2013 at 3:03 PM, Richard Hipp  wrote:
>
> > On Fri, Apr 5, 2013 at 9:02 AM, Richard Hipp  wrote:
> >
> > >
> > >
> > > On Fri, Apr 5, 2013 at 8:54 AM, Rob Collie 
> wrote:
> > >
> > >> Hello there,
> > >>
> > >> For my sins, I'm trying to create a library allowing our legacy
> fortran
> > >> code to work with SQL.
> > >>
> > >> Calling this from fortran...
> > >>
> > >> CALL EXECUTESQL('dbTest'//CHAR(0), cQuery, iReturnValue)
> > >> ...runs the following code, and yet the error returned is 'SQL Logic
> > error
> > >> or missing database'. No file is ever created. Is there something dumb
> > I'm
> > >> missing here?
> > >>
> > >>
> > >> extern "C"
> > >> {
> > >>
> > >>  void EXECUTESQL(char *dataBase, char *query, int returnValue)
> > >>  {
> > >>
> > >>   // Checking the incoming data from FORTRAN
> > >>   CStringW wName(dataBase);
> > >>   MessageBoxW( NULL, wName, L"Name: ", MB_OK );
> > >>
> > >>   // Create the object
> > >>   sqlite3 *oDatabase;
> > >>
> > >>   // Create the error objects
> > >>   char *sErrorMessage;
> > >>   // Open/create the table, if required
> > >>   returnValue = sqlite3_open_v2(dataBase, ,
> > >>
> > >
> > > I think you want just "oDatabase", without the "&" prefix operator.
> > >
> >
> > No.  Scratch that.  I misread the code.  Ignore what I said.  I'm going
> to
> > get coffee now.
> >
> >
> > >
> > >
> > >> SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, "");
> > >>   if (returnValue != SQLITE_OK )
> > >>   {
> > >>sqlite3_close(oDatabase);
> > >>MessageBoxA(NULL, sqlite3_errstr(returnValue), "SQL Open Error",
> > >> MB_OK);
> > >>return;
> > >>   }
> > >>
> > >>
> > >> Rob.
> > >> ___
> > >> sqlite-users mailing list
> > >> sqlite-users@sqlite.org
> > >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > >>
> > >
> > >
> > >
> > > --
> > > D. Richard Hipp
> > > d...@sqlite.org
> >
> >
> >
> >
> > --
> > D. Richard Hipp
> > d...@sqlite.org
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL Logic error or missing database

[Noel Frankinet]

Is your filename UTF8 ?


On 5 April 2013 15:02, Richard Hipp  wrote:

> On Fri, Apr 5, 2013 at 8:54 AM, Rob Collie  wrote:
>
> > Hello there,
> >
> > For my sins, I'm trying to create a library allowing our legacy fortran
> > code to work with SQL.
> >
> > Calling this from fortran...
> >
> > CALL EXECUTESQL('dbTest'//CHAR(0), cQuery, iReturnValue)
> > ...runs the following code, and yet the error returned is 'SQL Logic
> error
> > or missing database'. No file is ever created. Is there something dumb
> I'm
> > missing here?
> >
> >
> > extern "C"
> > {
> >
> >  void EXECUTESQL(char *dataBase, char *query, int returnValue)
> >  {
> >
> >   // Checking the incoming data from FORTRAN
> >   CStringW wName(dataBase);
> >   MessageBoxW( NULL, wName, L"Name: ", MB_OK );
> >
> >   // Create the object
> >   sqlite3 *oDatabase;
> >
> >   // Create the error objects
> >   char *sErrorMessage;
> >   // Open/create the table, if required
> >   returnValue = sqlite3_open_v2(dataBase, ,
> >
>
> I think you want just "oDatabase", without the "&" prefix operator.
>
>
> > SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, "");
> >   if (returnValue != SQLITE_OK )
> >   {
> >sqlite3_close(oDatabase);
> >MessageBoxA(NULL, sqlite3_errstr(returnValue), "SQL Open Error",
> MB_OK);
> >return;
> >   }
> >
> >
> > Rob.
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to write store-procedure in SQLite.net

[Noel Frankinet]

Hello,
I think that sqlite does not support stored procedure, but it does support
triggers.

Noël


On 25 March 2013 07:05, Moumita Banerjee  wrote:

> Hi,
>
> I am trying to write a store-procedure in SQLite.net , but I am unable to
> do so. Please help me solve this problem.
>
> Thanks,
> Moumita
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Wanted - simple DATA editor for sqlite tables

[Noel Frankinet]

Back in the old time there was dbase.I'm always dreaming of a sqlite based
dbase. One can be done with tcl + tk sqlite, but I find tcl and tk way too
big today.


On 25 March 2013 14:17, Simon Slavin  wrote:

>
> On 25 Mar 2013, at 11:35am, c...@isbd.net wrote:
>
> > I don't want to load/use a DBMS *when I'm editing the data*.  Of course
> > a database management program is an excellent tool for managing the
> > database, but they're generally rubbish at making it easy to enter data
> > into the database.
>
> Yeah, there seems to be that problem with database editors.  They start
> off as little data editing utilities.  Then the authors add more features
> and them more features, until you have to pick 'editing' and an editing
> mode before you can do what the application was originally for.  Which is
> what you're trying to avoid.
>
> I ended up writing my own in JavaScript/PHP.  But you need to be a
> programmer to do that.  And my own editor is custom-designed for the way my
> databases work so it's not suitable for wide publication.
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Wanted - simple DATA editor for sqlite tables

[Noel Frankinet]

I once developped a simple table viewer using WTL and windows ListView.
Very lighweight and very speedy.
Of course it was windows only and read only.
I suppose that a modern editable version using Qt would be even easier to
develop ?

Noël


On 25 March 2013 12:41,  wrote:

> Stephen Chrzanowski  wrote:
> > Reading further on, I see that you're looking at end-user.  This changes
> > things a bit.  Now you're looking at trying to make things user-proof,
> > maintain data integrity (Who said 1<>one?), validate data, so on and so
> > on.  You're probably looking at custom code now.
> >
> Yes, though the end-user is mostly me so I'm not so fussed about data
> integrity.  It's very simple data, a date, a couple of columns with
> numbers in and a text column.  If it gets confused because I've
> mis-formatted a date I can simply correct the entry, it doesn't need
> heavyweight validation.
>
>
> > But, if you can trust the user(s), I'd STILL say don't reinvent, but just
> > use a something that is already written.
> >
> That's exactly where I'm coming from, I'm desperately trying not to
> re-invent the wheel but all I can find is complete bicycles!  :-)
>
> I want a simple application with low overheads (i.e. fast to load *and*
> with no DBMS extras not needed for data entry) and there really don't
> seem to be any out there.
>
> --
> Chris Green
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Which C++ data structures might one use to cache a sqlite query result?

[Noel Frankinet]

a two dimensional array, a vector of vectors ?


On 24 January 2013 16:46, Cory Nelson  wrote:

> On Thu, Jan 24, 2013 at 9:31 AM, Frank Chang 
> wrote:
> > Could anyone suggest which C++ data structure to use to cache a sqlite
> > query result? Thank you for your help
>
> This is too vague, you'll need to provide more information. What have
> you tried so far?
>
> --
> Cory Nelson
> http://int64.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

[Noel Frankinet]

Lets agree to disagree, sqlite is completely cross-plaform. You could
develop a cross plate-form solution  in the same time (Qt or Tcl/tk). The
95% market does not hold if you think smart-phone and tablet (a good target
for a simple data entry application). If you only want windows, why not
uuse Access in the first place? But anyway...


On 10 December 2012 15:33, Gilles Ganault <gilles.gana...@free.fr> wrote:

> On Mon, 10 Dec 2012 15:07:05 +0100, Noel Frankinet
> <noel.franki...@gmail.com> wrote:
> >It's probably a good way to get something working, but you loose the
> >cross-platform
>
> I know, but Windows is 95% of the market for end-users, cross-platform
> is a pain to write, they take longer to load and always look/act funny
> anyway :-)
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

[Noel Frankinet]

It's probably a good way to get something working, but you loose the
cross-platform


On 10 December 2012 14:47, Gilles Ganault  wrote:

> On Mon, 10 Dec 2012 11:49:31 +, Simon Slavin
>  wrote:
> >There are lots of people who manipulate data that way, but they tend to
> export
> > their data from the SQLite database into their favourite spreadsheet app,
> > do the manipulation there, then reimport to SQLite.
> > This prevents them from having to use an app which doesn't have
> > all the facilities they expect from their spreadsheet app.
> >
> >The SQLite shell tool (free) makes the export and import processes easy
> (can be done in one command).
>
> I'll see if there's a good datagrid + SQLite connector for .Net so I
> can combine the two and see how it goes.
>
> Thanks all.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] VC++ and SQLite

[Noel Frankinet]

why would you need stdafx.h for sqlite ? what is the added benefit ?


On 13 November 2012 14:57, Michael Schlenker  wrote:

> Am 13.11.2012 14:33, schrieb Arbol One:
> > I would also keep this feature, however, in the case of SQLite3
> > amalgamation, I am really confused. You know how we have to #include
> > the 'stdafx.h' in every declaration file (making it non-portable
> > code), i.e. .c, .cpp, etc., well, I tried doing the same thing with
> > sqlite.c, but VS10 complains about it.
>
> You can do that without making it non portable by adding /FI to your
> compile line:
> http://msdn.microsoft.com/en-us/library/8c5ztk84%28v=vs.71%29.aspx
>
> Try /FI "stdafx.h"
>
> Michael
>
> >
> > What a nightmare Visual Studio is >:(
> >
> > Genius might have limitations, but stupidity is no handicap Eat
> > Kosher
> >
> > -Original Message- From: sqlite-users-boun...@sqlite.org
> > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of John Drescher
> > Sent: Monday, November 12, 2012 7:44 PM To: General Discussion of
> > SQLite Database Subject: Re: [sqlite] VC++ and SQLite
> >
> > On Mon, Nov 12, 2012 at 1:52 PM, Doug Nebeker 
> > wrote:
> >> You might be surprised at the speed increase you see in compile
> >> time if you've got large projects.  The time isn't lost to CPU as
> >> much, but disk I/O time adds up when hitting many hundreds of small
> >> (header) files (even with an SSD).
> >>
> >
> > This is why I use PCH. Building some of my projects take a long time
> > even on a 12 threaded processor with multiple SSDs.
> >
> >
> > -- John M. Drescher ___
> > sqlite-users mailing list sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> > ___ sqlite-users mailing
> > list sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
> --
> Michael Schlenker
> Software Architect
>
> CONTACT Software GmbH   Tel.:   +49 (421) 20153-80
> Wiener Straße 1-3   Fax:+49 (421) 20153-41
> 28359 Bremen
> http://www.contact.de/  E-Mail: m...@contact.de
>
> Sitz der Gesellschaft: Bremen
> Geschäftsführer: Karl Heinz Zachries, Ralf Holtgrefe
> Eingetragen im Handelsregister des Amtsgerichts Bremen unter HRB 13215
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] VC++ and SQLite

[Noel Frankinet]

Never use stdafx stuff on open source project. Don't use precompiled header.


On 13 November 2012 14:33, Arbol One  wrote:

> I would also keep this feature, however, in the case of SQLite3
> amalgamation, I am really confused. You know how we have to #include the
> 'stdafx.h' in every declaration file (making it non-portable code), i.e.
> .c, .cpp, etc., well, I tried doing the same thing with sqlite.c, but VS10
> complains about it.
>
> What a nightmare Visual Studio is >:(
>
> Genius might have limitations, but stupidity is no handicap
> Eat Kosher
>
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:
> sqlite-users-boun...@sqlite.org] On Behalf Of John Drescher
> Sent: Monday, November 12, 2012 7:44 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] VC++ and SQLite
>
> On Mon, Nov 12, 2012 at 1:52 PM, Doug Nebeker 
> wrote:
> > You might be surprised at the speed increase you see in compile time
> > if you've got large projects.  The time isn't lost to CPU as much, but
> > disk I/O time adds up when hitting many hundreds of small (header)
> > files (even with an SSD).
> >
>
> This is why I use PCH. Building some of my projects take a long time even
> on a 12 threaded processor with multiple SSDs.
>
>
> --
> John M. Drescher
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] VC++ and SQLite

[Noel Frankinet]

Remove "use precompiled header" from your configuration.



On 10 November 2012 14:11, Arbol One  wrote:

> I know this question is not a SQLite question, but I am hoping that
> someone here has had a similar experience and/or can point me to the right
> place to ask this question.
>
> After years or using Code::Blocks and Dev-Cpp, I have recently installed
> Visual Studio 10 Express; it is the first time I am using it, in my Windows
> 7 machine.
>
> I have written, with the help of this mailing list a wrapper class for the
> latest SQLite3 library using C::B as my development platform, now that I
> want to switch to VS10, there were a lot of gcc specific code that I had to
> repair and after clearing all the C++ discrepancies between MinGW's g++ and
> MS's VC++ I have been left with this error message:
>
> fatal error C1853: 'Debug\sql.pch' precompiled header file is from a
> previous version of the compiler, or the precompiled header is C++ and you
> are using it from C (or vice versa
>
>
>
> Does anyone know how to resolve this issue or perhaps a VS10 specific
> mailing list to address this question?
>
>
>
> TIA.
>
>
>
> This e-mail is for the sole use of the intended recipient and may contain
> confidential or privileged information. Unauthorized use of its contents is
> prohibited. If you have received this e-mail in error, please notify sender
> immediately via return e-mail and then delete the original e-mail.
>
>
>
> Let there come out of you a group of people inviting to all that is good,
> enjoining what is right, and to strive against what is wrong: They are the
> ones to attain respect and admiration, i.e. FSF, GTK+, *NIX, SQLite... etc.
>
> Eat Kosher <
> http://www.hanefesh.com/edu/kosher_Food_Symbols.htm#USAD:DocumentsDownloadedInstallations>
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is the absence of msvcrt.dll a known issue with SQLite Windows 2000

[noel frankinet]

Roger Binns a écrit :
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 06/05/2010 08:20 AM, noel frankinet wrote:
>   
>>> I see windows 2000 as the finest os that redmont has produced. You'd 
>>> better not develop on the latest ms os if you want to have some 
>>> installed base.
>>>   
>
> Your opinion is fine, but someone has to bear the burden of supporting
> increasingly outdated operating systems.  For example I have a Mac running
> OSX 10.3.  The open source software I use (eg Firefox and Emacs) do not run
> on it anymore because they were not willing to bear that burden.  And pretty
> much no one supports Windows 98 these days for the same reason.
>   
Yes, but its a pity(windows 98 is another problem).
I still use windows 2000 as my base point. I test on xp after that (but 
I progress, before it was watcom c++ and dos extender).
>   
>>> I did not know that mingw was using msvcrt.dll. But anyway, its there, 
>>> in system directory, so it should run fine.
>>>   
>
> The thing you missed is that there is no one msvcrt.dll.  There was one
> version shipped with the operating system, then updated versions with new
> functionality and bug fixes shipped with Microsoft compilers, service packs
> and other updates.  On install applications were placing whatever versions
> they wanted into the system directory and not necessarily doing that right.
>  This is why it is possible for SQLite3.dll to work just fine on one system
> but not another.
>   
Yes I understand that.
> With XP the dll became a protected system file and Windows went to great
> lengths to ensure that any installer futzing with it would have the actions
> reversed.  Microsoft also started numbering the dll shipped with the C
> compiler, and said applications should install the dll in their program
> directory (which is searched first before system directories).  They also
> introduced sxs where the system managed multiple versions of dlls and that
> whole mess.
>
>   
Yes I've seen that, and also exe that don't run because of double 
dependency
>   http://en.wikipedia.org/wiki/Side-by-side_assembly
>
> Consequently XP and later systems are far less likely to have problems with
> incorrect msvcrt.dll.
>   
My experience is the reverse, but luck maybe.
Anyway thank you for your info, I wish you would have been there when I 
was pulling my hair with side by side assembly issue

Noël
> Roger
>
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.4.10 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>
> iEYEARECAAYFAkwKhmIACgkQmOOfHg372QSszgCg4m6GBuZlfb6kVx4u32WHibAU
> GcAAniDiHqlOfkDRrJGEuecucH73Umja
> =2OwY
> -END PGP SIGNATURE-
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>   

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is the absence of msvcrt.dll a known issue with SQLite Windows 2000

[noel frankinet]

Roger Binns a écrit :
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 06/05/2010 04:21 AM, noel frankinet wrote:
>   
>> But in fact sqlite runs perfectly fine on windows2000 
>> 
>
> Exactly as my second paragraph says.  But in the Windows 2000 time frame
> applications used to install their own copies of msvcrt.dll in the system
> directories which means one broken application is all it takes to screw that 
> up.
>
> But when the operating system vendor no longer supports a platform it is
> increasingly pointless for a software person to continue support.  At some
> point you have to call it quits.  (For example see who still supports
> Windows 95, MacOS 7 or Redhat Linux 3.)
>   
I see windows 2000 as the finest os that redmont has produced. You'd 
better not develop on the latest ms os if you want to have some 
installed base.
>   
>> and is compilable 
>> with any free compiler (mingw for instance)
>> 
>
> You are mixing multiple things up.  There are two different issues: source
> compatibility and binary compatibility.  SQLite does compile with pretty
> much any C compiler out there (source compatibility).
>
> Binary compatibility is a bit more tricky.  The compiler links SQLite
> against system libraries that provide underlying functionality such as file
> access, memory allocation etc.  What happens is compiler and platform
> specific.  In general the resulting SQLite works with that version of the
> operating system and any version going forward but not older ones.  In the
> case of Microsoft, they have been distributing the C libraries with the
> compilers not the operating system and been numbering the C library as part
> of the file name.  Additionally various data structures (eg stdio) have
> changed between library versions and having multiple versions of the C
> library used in the same process is a recipe for problems.  Applications
> should be putting the C libraries in their own directories and not system
> locations.  msvcrt.dll (with no numbers) is a special case and is in system
> directories and in theory is for the use of operating system applications
> only.  Because of that pervasiveness MinGW targets it as the C library.  In
> fact they claim to support no other version, although their compiled DLLs do
> work with other versions in my experience.
>   
I did not know that mingw was using msvcrt.dll. But anyway, its there, 
in system directory, so it should run fine.
> BTW I believe the distributed SQLite Windows DLL is actually produced by a
> gcc cross compiler on Linux, which you could label MinGW as well.
>   
Yes I think so too.

Best regards
Noël
> Roger
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.4.10 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>
> iEYEARECAAYFAkwKZMsACgkQmOOfHg372QRYyQCgsOpimyfGUtV83mEbqgEhS1+7
> nAoAnR7r+vi6qb2WgiY1Z4zGfQbo2ZSK
> =DImh
> -END PGP SIGNATURE-
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>   

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is the absence of msvcrt.dll a known issue with SQLite Windows 2000

[noel frankinet]

Roger Binns a écrit :

But in fact sqlite runs perfectly fine on windows2000 and is compilable 
with any free compiler (mingw for instance)

Best regards
Noël Frankinet
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 06/05/2010 12:01 AM, Frank Church wrote:
>   
>> and Windows 2000.
>> 
>
> Mainstream support ended 5 years ago, and all support ends in just over
> a month, no matter how much money anyone is prepared to throw at them:
>
>   http://support.microsoft.com/lifecycle/?LN=en-us=7=6=3071
>
> You haven't said how it fails.  A correctly installed and maintained
> system should be just fine.  A system with other 3rd party software on
> it is especially likely to have experienced the dll being overwritten.
>
> http://en.wikipedia.org/wiki/Microsoft_Windows_library_files#Msvcrt.dll
>
>   
>> I don't have my own Windows 2000 system to test it with.
>> 
>
> It is generally a good idea to have an MSDN subscription as you then
> have access to the operating systems for development and testing.
>
> http://msdn.microsoft.com/en-us/subscriptions/subscriptionschart.aspx
>
> Roger
>
>
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.4.10 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>
> iEYEARECAAYFAkwKAqYACgkQmOOfHg372QQAbwCfb1fdVgPFt0fO96KmjgVk1xzr
> RbMAnRZVgil2oHZAXemL2JgxsebuAi2z
> =LCfX
> -END PGP SIGNATURE-
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>   

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Question about using SQLite3 on Windows Mobile 6+

[noel frankinet]

Anthony Papillion a écrit :
Hello Anthony,

Your windows Mobile device has a Arm processor, you will need to 
recompile sqlite.dll for that processor (with evc3+evc4 or visual studio 
2005/2008)
Best wishes
Noël Frankinet

> Hello Everyone,
>
> I'm totally new to SQLite and am trying to use it in a new Windows Mobile 
> application. I've downloaded the SQLite3.dll and went to my project and 
> tried to add a reference to the dll. For some reason, when I try to add the 
> reference, I am told "A reference to sqlite3.dll could not be added" with no 
> further information.
>
> I've been searching Google for a while and can't find a resolution so I'm 
> hoping someone can help me out.
>
> Thanks a lot!
> Anthony Papillion
> OpenEMR HQ, Inc.
> www.openemrhq.com 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>   

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite compile error

[noel frankinet]

Gary Zigmann a écrit :

Hello,

Since sqlite is a library, could you show us your main program, in order 
to help you ?
Best wishes

Noël Frankinet
>  Good Afternoon,
>
>  Today I downloaded sqlite-amalgamation-3_6_22.zip from the  
>  sqlite.org website because I was looking for a SQL database to  
>  replace MS Access on my machine. I compiled sqlite3.c using a c  
>  compiler and came up with this error:
>
> [Linker error] undefined reference to `winm...@16'
>
>  Can you help me?
>
> Thanks,
>
>   
>> Gary Zigmann, MBA
>> Clinical Data Analyst
>> Gifford Medical Center
>> gzigm...@giffordmed.org
>>
>> This information is confidential. If you are not the intended recipient, 
>> delete this e-mail and any attachments without forwarding it or retaining a 
>> copy. To try to obtain permission to use this transmission or to notify the 
>> sender of the error, call (802) 728-2135 or e-mail gzigm...@giffordmed.org.
>>
>>
>> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>   

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Need help understanding the basic of C++/sqlite

[noel frankinet]

Fabrice NA a écrit :

Hi,

In sqlite3_exec, you pass a function pointer (callback).
Sqlite call that function with each row of data

Best wishes

Noël
> Hi all,
>
>
>
> I am trying to understand Sqlite and to make thing worse I am also learning
> C++. You will not be surprised that I find it really hard to understand the
> C++ example on the web. Can someone guide me to digest this? If you can
> explain please do so by extrapolating since I am a total newbie.
>
>
>
> I have managed to compile the code example into a file called testdb.exe and
> have created a database named Cars.db containing 7 rows. (notice that I have
> removed some part of that code that I don't need help for)
>
>
>
> #include 
>
> #include 
>
>
>
> static int callback(void *NotUsed, int argc, char **argv, char **azColName){
>
>   int i;
>
>   for(i=0; i
> printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
>
>   }
>
>   printf("\n");
>
>   return 0;
>
> }
>
>
>
> int main(int argc, char **argv){
>
>   sqlite3 *db;
>
>   char *zErrMsg = 0;
>
>   int rc;
>
>
>
>   if( argc!=3 ){
>
> fprintf(stderr, "Usage: %s DATABASE SQL-STATEMENT\n", argv[0]);
>
> exit(1);
>
>   }
>
>   rc = sqlite3_open(argv[1], );
>
>
>
>   rc = sqlite3_exec(db, argv[2], callback, 0, );
>
>
>
>   sqlite3_close(db);
>
>
>
>   return 0;
>
> }
>
>
>
> Now in command line when I execute testdb.exe cars.db "select * from cars"
> (the table is called cars too) everything works fine and I get an output
> with all my seven rows. But how come this work? Is this some kind of magic?
>
>
>
> Even after reading the doc again and again I don't understand (probably
> because I am still learning some basic C++ concepts). Here my questions;
>
>
>
> 1)   What is the purpose of doing "sqlite3  *db"  are we just creating a
> pointer of type sqlite3 named db here?
>
>
>
> 2)   At first I though that for the main function the first
> parameter  "cars.db"
> was represented by the variable argc and the second "select * from cars" by
> argv. Well at the end, it looks like that "cars.db" is argv[1] and that the
> select statement is argv[2]. What is argc then?  Seems like it's the number
> of rows returned by the query (when looking at function callback) but how
> the program find this out? How come we have a line "  if( argc!=3 )" and see
> this same argc variable in the callback function?
>
>
>
> 3)   I don't understand the third argument from the query " rc =
> sqlite3_exec(db, argv[2], callback, 0, );" my problem is
> understanding the callback function inside the sqlite3_exec function.
> Reading this link http://www.sqlite.org/c3ref/exec.html didn't help too much
> even though it has been written in plain English.
>
>
>
> 4)   I am using VC++ Express from Microsoft  on WinXP and would like to
> know if it's possible to pass parameter when debugging i.e. tell the
> debugger to use cars.db for file and use "select * from cars" as a statement
> (this would allow me to see what's hapening witout replacing variables by
> their real values).
>
>
>
> 5)   It's really hard to find some simple example on internet about C++
> working with sqlite. Can any of you provide with simple sample codes that
> shows how you can do and what you can do with sqlite and C++?
>
>
>
> I hope I didn't offended anyone with my lack of knowledge and I thank in
> advance the courageous ones who managed to read this email until the end and
> probably got answers to my questions.
>
>
>
> Fabou
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>   

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Quick question:

[noel frankinet]

S B a écrit :

Pocket PC use a arm/xscale processor, not a x86.The os is also differnet 
(windowsCE vs win32). A recompile is needed with the right tool (evc3, 
evc4 of visual studio 2005/2007).

Best wishes
Noël
> Jason,
>
> Chances are you will have to compile it for CE.  I imagine it uses a
> different compiler/SDK than standard XP.  Use the amalgamated version of the
> source - it's very easy.
>
> SB
>
> On Mon, Jan 5, 2009 at 1:28 PM, jason young  wrote:
>
>   
>> Quick question:
>> Can anyone tell me what is involved with getting a WinCE 5.0 executable
>> that I can do some testing and development with. I tried to take the Windows
>> executable on the download page and run it on CE but it failed claiming that
>> it could not SQLite3 (or one of its components). FYI, I can get the same
>> executable to run on my XP machine.
>>
>> Please help me understand what I'm doing wrong.
>>
>>
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>   

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [newbie] Compiling for Windows CE

[noel frankinet]

David Stephenson a écrit :
> Hi,
>
> I'm trying to compile 3.5.9 to Windows CE using embedded C++ 4.0 and I get
> the following error:
>   
Hello David,
You probably should compile for a console project ( or a dll it depends)
Noël
> corelibc.lib(pegwmain.obj) : error LNK2019: unresolved external symbol
> _WinMain referenced in function _WinMainCRTStartup
> How can I resolve this?
>
> David
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>   

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] wtl list view article on codeproject

[noel frankinet]

Hello,

I've written a small article to show how to connect sqlite to a wtl 
listview on windows.

http://www.codeproject.com/KB/list/alphaview.aspx

I hope it will help somebody

Best wishes
Noël Frankinet
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] rtree extension - Windows Binary?

[noel frankinet]

Griggs, Donald a écrit :
> Hi Andrew,
>
> Maybe this goes without saying, but I guess you've already worked on the
> "usual suspects" such as:
>
> -- An index for Lat and another for Lon.
> -- Larger cache
> -- EXPLAIN QUERY PLAN prefix to ensure that index used
> -- One-time VACUUM has any effect?
> -- ANALYZE
>  
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Brampton
> Sent: Friday, June 13, 2008 11:52 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] rtree extension - Windows Binary?
>
> Hi,
> I've recently created a database with latitude/longitude points in it,
> and now I need to search for points without a given rectangle. With
> 60,000 points I'm able to retrieve a rectangle of 50 points in ~1
> second. This is way too slow, so I wanted to try out the rtree
> extension.
>
> However at the moment I'm unable to compile it, so I was wondering if
> anyone had a DLL for windows which I could use. I am using PHP 5.x to
> access my SQLite database, so the extension must be compatible with the
> sqlite included with that.
>   
What do you use to compile, I just added rtree.c to my vc6 project and 
it compiled right away.
I've not tested it yet, however :-{

Best wishes
Noël
> Would anyone be able to give me such a DLL? Also is there a good write
> up on how to use this extension? I've been following the mailing list,
> but another source would be helpful.
>
> thanks
> Andrew 
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
> This email and any attachments have been scanned for known viruses using 
> multiple scanners. We believe that this email and any attachments are virus 
> free, however the recipient must take full responsibility for virus checking. 
> This email message is intended for the named recipient only. It may be 
> privileged and/or confidential. If you are not the named recipient of this 
> email please notify us immediately and do not copy it or use it for any 
> purpose, nor disclose its contents to any other person.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>   

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Thank you

[noel frankinet]

D. Richard Hipp a écrit :
> I'd like to take credit for the new r-tree module because it is a fine  
> piece of work.  But in truth the new r-tree module was written  
> entirely by Dan Kennedy.  http://www.sqlite.org/crew.html  Good job,  
> Dan!
>
> D. Richard Hipp
> [EMAIL PROTECTED]
>
>
>   
Thank you to Dan and Richard then,
Very fine work indeed, thanks a lot, it complete the spatialite project 
quite nicely.
Noël Frankinet
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Please test lastest CVS using WinCE

[noel frankinet]

[EMAIL PROTECTED] a écrit :
> Can somebody with the ability to compile and test for wince
> please test check-in [4802] for me.
>
>http://www.sqlite.org/cvstrac/chngview?cn=4802
>
> For that matter, is there anybody out there who would like
> to become the official wince maintainer for SQLite?  If you
> are able to compile, test, and debug SQLite for wince and
> would like to take on this task, we will be happy to welcome
> you to the official SQLite development team.  Benefits include:
>
>*  CVS check-in privileges
>*  Access to the private SQLite developers chatroom
>*  A prestigious [EMAIL PROTECTED] email alias
>*  Praise and admiration from your peers
>
> --
> D. Richard Hipp <[EMAIL PROTECTED]>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>   

Hello,

I am ready to help if you want.
I develop a GIS package on pocketPC and windows, It use sqlite quite well.

Best regards
Noël Frankinet

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] what platforms does SQLite run on?

[noel frankinet]

Sam Carleton a écrit :
> I see that SQLite runs on Windows, OSX, and *NIX, will it run on
> Windows Mobile (CE) or any embedded OS's?
>   

It runs on any CE that I know

Noel
> Sam
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>   

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQlite in PDA with Windows CE

[noel frankinet]

Jorge Rodríguez Pedrianes a écrit :

Hello, Anybody  Knowk to use sqlite embeden in a PDA??, I saw that i can 
download a .dll to windows, but can I use this dll in PDA? I saw the 
documentation but don't find anything about this.
 
Anybody can I help me??
 
 
Thanks!!!

_
Tecnología, moda, motor, viajes,…suscríbete a nuestros boletines para estar 
siempre a la última
http://newsletters.msn.com/hm/maintenanceeses.asp?L=ES=ES=WCMaintenance=WL=http%3a%2f%2fmail.live.com
  



No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.503 / Virus Database: 269.17.4/1189 - Release Date: 18/12/2007 21:40
  

Hello,

No you cannot use sqlite3.dll on a pda, you need to recompile with a arm 
compiler. (evc3 or evc4 are free for instance).


Best wishes.
Noël

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

Re: [sqlite] Script Language

[Noel Frankinet]

Cesar Rodas a écrit :

Your help will be welcome.

On 09/03/07, Noel Frankinet <[EMAIL PROTECTED]> wrote:


Cesar Rodas a écrit :
> I am planning to develop a interpreted language with LEMON && FLEX.
> The main
> goal is to provide a easy way to script commons actions, and to teach
> algorithm in my University (National University of Asuncion - 
Paraguay).

>
> The language have syntax as PHP and Python
>
> I am planning to create a SQLite support in the core, for teach SQL 
too.

>
> Is any one instresting to help in this project?
>
> Thanks to all.
>
> PD: The language doesn't have a name jet, and will be Public Domain.
>
> 


>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.446 / Virus Database: 268.18.8/714 - Release Date:
8/03/2007 10:58
>
Hello Cesar,

I am interested in the inner working of LEMON, so I am ready to help (I
know tcl and Lua, but I never have devlopped an interpretor).

Best regards

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net



- 


To unsubscribe, send email to [EMAIL PROTECTED]

- 









No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.8/714 - Release Date: 8/03/2007 10:58
  

Just tell me what you expect from me.
Do you have a description of the language ( a grammar ?), is it object 
based, object orientated or just procedural.
Do you want to implement it in pure C or a mixture of C and C++. Is SQL 
a part of the language ?


--
Noël Frankinet
Gistek Software SA
http://www.gistek.net


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

Re: [sqlite] Script Language

[Noel Frankinet]

Cesar Rodas a écrit :
I am planning to develop a interpreted language with LEMON && FLEX. 
The main

goal is to provide a easy way to script commons actions, and to teach
algorithm in my University (National University of Asuncion - Paraguay).

The language have syntax as PHP and Python

I am planning to create a SQLite support in the core, for teach SQL too.

Is any one instresting to help in this project?

Thanks to all.

PD: The language doesn't have a name jet, and will be Public Domain.



No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.8/714 - Release Date: 8/03/2007 10:58
  

Hello Cesar,

I am interested in the inner working of LEMON, so I am ready to help (I 
know tcl and Lua, but I never have devlopped an interpretor).


Best regards

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net


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

Re: [sqlite] SQLite GUI app that offers layouts

[Noel Frankinet]

Rob Sciuk a écrit :

On Wed, 18 Oct 2006, Rich Shepard wrote:
  

Rob,

   And, ... there's pysqlite2 which is a teriffic implementation of the
python database API.

   I'm using python, wxPython, and pysqlite2 in our approximate reasoning
models. It's a nice system.

Rich



So many scripting languages, and so little time.  Noel is making a valiant
case for Lua/IUP widgets, though I'm only vaguely aware of that language.
What was that link again?
  

htpp://www.lua.org
http://luaforge.net/projects/iup/


thinking about it, storing xml (or generating xml on the fly from a 
registered sqlite command) seems better than generating tcl/python/lua 
whatever code ? Its also easy to send/receive remotely.
My NGUI controls accept xml directly, so you can feed them from sqlite 
without additional step.

Anyway, there's always some tradeoff (size, speed, portability)...

Best wishes.


--
Noël Frankinet
Gistek Software SA
http://www.gistek.net


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

Re: [sqlite] SQLite GUI app that offers layouts

[Noel Frankinet]

Rich Shepard a écrit :

On Wed, 18 Oct 2006, Rob Sciuk wrote:


Interesting, but I'm wondering why not use the tcl/tk binding to simply
generate the forms using the well crafted tcl binding which comes 
with the

SQLite language?  Tcl/TK is a very simple scripting language which is
portable to all major platforms, has a very useful GUI widget set, and
while it might not be the prettiest interface in the world, getting very
useable forms up and running using sqlite/tk is trivial. 


  Alternative #3: write your application in python and use the wxPython
widget set. This combination is portable across OSes and uses the native
widgets so the "look and feel" is consistent.

Rich


Alternative #4 : write your application in lua and use IUP widgets set.
This combination is portable across OSes and uses the native
widgets so the "look and feel" is consistent but the size is 10 time 
smaller.


--
Noël Frankinet
Gistek Software SA
http://www.gistek.net


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

Re: [sqlite] SQLite GUI app that offers layouts

[Noel Frankinet]

<.02$>
Interesting, but I'm wondering why not use the tcl/tk binding to simply
generate the forms using the well crafted tcl binding which comes with the
SQLite language?  Tcl/TK is a very simple scripting language which is
portable to all major platforms, has a very useful GUI widget set, and
while it might not be the prettiest interface in the world, getting very
useable forms up and running using sqlite/tk is trivial.


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



  


yes, tcl/tk is another option, I used to use it a lot.
However tcl/tk is a little bit fat(6Mb), you need zillion of extension 
to get a good looking gui and there is no object support in the core. 
Lua is less than 300k, ngui also, so we are not playing in the same 
category.



--
Noël Frankinet
Gistek Software SA
http://www.gistek.net


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

Re: [sqlite] SQLite GUI app that offers layouts

[Noel Frankinet]

Sorry, the correct url is :

http://www.gistek.net/gui.html

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net


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

Re: [sqlite] SQLite GUI app that offers layouts

[Noel Frankinet]

COS a écrit :

Hi Tom,

- Original Message - 
From: "T" <[EMAIL PROTECTED]>

To: 
Sent: Tuesday, October 17, 2006 9:47 PM
Subject: [sqlite] SQLite GUI app that offers layouts


  

Hi all,

There seem to be several SQLite GUI apps around. But I haven't seen
any that offer building of layouts, ie positioning test frames for
fields on a page for form data entry or printing. This feature is
typical of proprietary apps such as FileMaker, AppleWorks, 4D etc.

Anyone know of a GUI app that offers layouts (ie form creation),
especially on a Mac (but even other platforms)?



DBManager Enterprise Edition (http://www.dbtools.com.br/EN/dbmanagerpro) can
do that. It has a form designer which allows to create and execute forms
like MSAccess does. This manager is for windows only and there is a TRIAL
Edition which you can test and see how it works.

  

Is there a conventional way to store the layout information in the
SQLite database itself, so it can be moved from one SQLite GUI app to
another, and retain compatible forms?



I doubt you will find something like. Usually the form is handled only by
the GUI which created it. For example, you can't execute MSAcess forms on
any other GUI. Because of that it doesn't matter if the form is saved in the
SQLite DB or not, since most GUI's will not know what to do with it.

Hope that helps,

COS


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



  

Hello Tom,

With my NGUI (http://www.gistek.net/ngui.htm) framework, I define a form 
layout in XML and the form behavior (on events) in lua.
That info can be stored in a sqlite table and a registered sqlite 
command could create the form on the fly, populate it and wait for user 
input.


My framework in win32/windowsCE (pda) only, but I suppose the same could 
be done with gtk or Qt.


Lua fits well with sqlite because its very compact

Best regards

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net


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

Re: [sqlite] "contains" function

[Noel Frankinet]

Dennis Cote a écrit :

Noel Frankinet wrote:


I would like to create a user function to know if a record is 
contained in a rectangle ?

If have looked to sqlite_create_function
I know that my record has for column (xmin,ymin,xmax,ymax)
I would like to use the new function to write something like
select * from table where ??? contains  (how I pass the selecting 
rectangle)


Is it possible ?
How do I do that ?
Thank you


Noel,

You need to create a predicate function that returns a boolean or 
integer (0 or 1) value based on 6 input values. Conceptually it would 
look like this:


   int point_in_rect(px, py, rxl, rxh, ryl, ryh)

Where px and py are the location of a point, rxl and rxh are the low 
and high limits of the rectangle's x dimension, and ryl and ryh are 
the low and high limits of the rectangle's y dimension.


You would use this function like this:

   create table points(x int, y int, data text);

   select * from points where point_in_rect(x, y, 10, 100, 25, 75);

This should give you an idea of how to implement it using the sqlite 
APIs.


   /* implement point in rect predicate function */

   void point_in_rect(sqlite3_context* ctx, int argc, sqlite3_value** 
argv)

   {
   int p, rl, rh, in = 0;

   /* check x values first */
   p = sqlite3_value_int(argv[0]);
   rl = sqlite3_value_int(argv[2]);
   rh = sqlite3_value_int(argv[3]);
   if (p >= rl && p <=rh) {
   /* now check y values */
   p = sqlite3_value_int(argv[1]);
   rl = sqlite3_value_int(argv[4]);
   rh = sqlite3_value_int(argv[5]);
   if (p >= rl && p <= rh)
   in = 1;
   }
 sqlite3_result_int(ctx, in);
   }


   /* register point in rect predicate */

   sqlite3* db;
   rc = sqlite3_create_function(db, "point_in_rect", 6,
   SQLITE_UTF8, NULL, point_in_rect, NULL, NULL);


HTH
Dennis Cote


- 


To unsubscribe, send email to [EMAIL PROTECTED]
- 






Very good Denis,
That' what I was looking for; but had some problem wrapping my head 
around it.


Thanks a lot
Regards

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net


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

Re: [sqlite] Wish to store a C structure in sqlite column

[Noel Frankinet]

Narendran a écrit :

thanks a lot,

 I believe i can store a structure now, but there is still a cache . I am in
the process on creating a Independant API,I can store a structure in SQLite
thro the above specified ways. what if some one else wants to use my API's
which i used to create the DBI's ,and the destination Database engine
doesn't support the blob datatypes. My question may be silly, but this is a
serious issues for me.

I am unable to resolve the problem for 3 days,hat's off to everyone.

Thanking you ,
B.Narendran
  

you can always encode it in text then

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net


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

Re: [sqlite] Wish to store a C structure in sqlite column

[Noel Frankinet]

Narendran a écrit :


Noel Frankinet wrote:
  

Narendran a écrit :


Dear Friends,


  I am in the process of forming a Generic API,(sql oriented and
BerkelyDB
and sister databases). In the process of integration ,i like to store a
Structure in Sqlite. 


 as far as my knowledge SQLITE allows me to declare the column types
suppoted by the programming languare or say i am using blob . My
requirement
is i wish to store a structure in the SQLite column.

  I am unable to form a sql statement to store the structure ,i am also
not
clear with whether i can have a strucure as column type.

suggestions will be really helpful.

 Thanking you,
 B.Narendran
  
  

You will need to turn your c struct into a blob and store that blob.
When retrieving the blob, you need a way to turn it back into your struct.
Its releatively easy if your struct does not contains pointers.

Best wishes

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net


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






Dear Frankinet,

  Thanks for ur reply,

  I am unable to understand what u have said. I am having a structure and I
am converting in to a blob. This means i am supposed to remove the '\0' in
between the strucure and put a final '\0' (NULL) character . Blob need only
on e null character to terminate it.
   I tried to memcopy the structure elements and store them ,I can store but
i am unable to find a way to retrieve it back. 


 typedef  struct ethernetcard1
{
  char port[10];
  char ipaddress[20];
  char mask[20];
  int bandwidth;
  }

what i tried is 


 char *buffer;
  int bufferlen;buffersize;
bufferlen = strlen(port)+strlen(ipaddress)+strlen(mask)+sizeof(int)+1;

memcpy(buffer,user.port,strlen(user.port);
buffersize = strlen(user.port);

memcpy(buffer,user.ipaddress,strlen(user.ipaddress));
buffersize += strlen(user.ipaddress);

and finally i included a NULL character to the buffer to make it as string
and i can insert in to a text field in sqlite column . I am unable to figure
out a way to retrieve it back if i am storing in this way or a blob type  I
think blob will be similar to this . 
 
 expecting ur valuable suggestion.


Thanking you,
Narendran 
  

hello Narendran,

Unfortunately, I'm still using 2.xx, so I encode the blob in character 
using sqlite_encode and I decode it back when I get it from sqlite.
You are on the right track, but for string you should have a way to 
store the length.
I have written some encoding function (like write_string and 
read_string) to help encoding and decoding from the buffer (and avoi all 
those mesy memcpy).

I hope this help
Best wishes

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net


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

Re: [sqlite] Wish to store a C structure in sqlite column

[Noel Frankinet]

Narendran a écrit :

Dear Friends,


  I am in the process of forming a Generic API,(sql oriented and BerkelyDB
and sister databases). In the process of integration ,i like to store a
Structure in Sqlite. 


 as far as my knowledge SQLITE allows me to declare the column types
suppoted by the programming languare or say i am using blob . My requirement
is i wish to store a structure in the SQLite column.

  I am unable to form a sql statement to store the structure ,i am also not
clear with whether i can have a strucure as column type.

suggestions will be really helpful.

 Thanking you,
 B.Narendran
  

You will need to turn your c struct into a blob and store that blob.
When retrieving the blob, you need a way to turn it back into your struct.
Its releatively easy if your struct does not contains pointers.

Best wishes

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net


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

Re: [sqlite] Which API to use to get resultant of query

[Noel Frankinet]

sandhya a écrit :

You mean there is no need for me to take care of this function calls ..Its
just enough having definition there.
But by doing that i am not getting any kind of output ie my OID.

  


No you should write the callback and do whatever you want with the 
passed data.

You the pass the call_back name to the relevant sqlite function.
sqlite will call it for every row selected by your query.



- Original Message - 
From: "Noel Frankinet" <[EMAIL PROTECTED]>

To: <sqlite-users@sqlite.org>
Sent: Friday, September 15, 2006 8:02 PM
Subject: Re: [sqlite] Which API to use to get resultant of query


  

sandhya a écrit :


Thanks  a lot for your response
Actually there is one function call in some sample found like,

static int callback(void *NotUsed, int argc, char **argv, char
  

**azColName)
  

{
  int i;
  for(i=0; i<argc; i++){
printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
  }
  printf("\n");
  return 0;
}

  

you don't call that callback , its called by sqlite...
In your case argc will be 1, argv[0] will contains the oid and
azColNames[0] will be "oid"



I reffered Shell.c also where in they also has the same function,If i am
  

not
  

passing my arguments through command prompt...
What i should pass as 2 and 3 arguments in the above function call ie
  

argc
  

and argv.Is there any API which directly gives the result.
Actually my query is returing only one data ie OID of the fileIn
  

this
  

case what i can do to get that data.Where it will get stored?
Please help me...in doing this

Thank you
Sandhya
- Original Message - 
From: "Jay Sprenkle" <[EMAIL PROTECTED]>

To: <sqlite-users@sqlite.org>
Sent: Friday, September 15, 2006 7:38 PM
Subject: Re: [sqlite] Which API to use to get resultant of query



  

On 9/15/06, sandhya <[EMAIL PROTECTED]> wrote:



sprintf(szQuery,"select oid from %s where filename =

  

'%s'",sampletbl,test.htm);

  

there's an example program here:
http://sqlite.org/quickstart.html
and a more involved one here
http://www.reddawn.net/~jsprenkl/Sqlite

--
--
SqliteImporter and SqliteReplicator: Command line utilities for Sqlite
http://www.reddawn.net/~jsprenkl/Sqlite

Cthulhu Bucks!
http://www.cthulhubucks.com



-
  

-
  

---

  

To unsubscribe, send email to [EMAIL PROTECTED]


-
  

-
  

---




  

--


---
  

To unsubscribe, send email to [EMAIL PROTECTED]
  

--


---
  



  

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net


--


---
  

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


---
  




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



  



--
Noël Frankinet
Gistek Software SA
http://www.gistek.net


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

Re: [sqlite] Which API to use to get resultant of query

[Noel Frankinet]

sandhya a écrit :

Thanks  a lot for your response
Actually there is one function call in some sample found like,

static int callback(void *NotUsed, int argc, char **argv, char **azColName)
{
  int i;
  for(i=0; i

To: 
Sent: Friday, September 15, 2006 7:38 PM
Subject: Re: [sqlite] Which API to use to get resultant of query


  

On 9/15/06, sandhya <[EMAIL PROTECTED]> wrote:


sprintf(szQuery,"select oid from %s where filename =
  

'%s'",sampletbl,test.htm);
  

there's an example program here:
http://sqlite.org/quickstart.html
and a more involved one here
http://www.reddawn.net/~jsprenkl/Sqlite

--
--
SqliteImporter and SqliteReplicator: Command line utilities for Sqlite
http://www.reddawn.net/~jsprenkl/Sqlite

Cthulhu Bucks!
http://www.cthulhubucks.com

--


---
  

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


---
  




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



  



--
Noël Frankinet
Gistek Software SA
http://www.gistek.net


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

Re: [sqlite] converting a sqlite table to dbf

[Noel Frankinet]

P Kishor a écrit :

Thanks, so the answer is there is no straight-forward way of doing
this. I will export to CSV, and then rebuild a dbf using Perl.

In case folks wonder why I am going back to the abacus, my data start
and end as .dbf. I use SQLite in between to do magic tricks with it.


On 8/29/06, Fred Williams <[EMAIL PROTECTED]> wrote:

Kind'a like chucking your Pentium 5 and going back to scratching on the
cave wall with a rock, Eh?

I'd export the tables to a CVS files using something like
SQLiteAdmin.exe.   Open the CVS files with Excel and save the resulting
spreadsheets as .DBF files (My Excel has a choice of DBASE II through
DBASE IV.)  Or you could use that block buster database, "Access", to do
the same.

Fred

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of P
> Kishor
> Sent: Monday, August 28, 2006 11:23 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] converting a sqlite table to dbf
>
>
> is there any straightforward way for converting a SQLite
> table to dbf format?
>





Hello,

I use shapelib (a libary to read and write gis shape files), the 
attributes files are dbf files, its in c and it easyling bound to sqlite.

Best wishes.

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net


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

Re: [sqlite] VB.Net DataSet & DataGrid with ADO.Net Provider

[Noel Frankinet]

John Newby wrote:


Hi, I don't know if you can remember but I was asking for advice on
displaying info to the user using a dataset/datagrid, and you said you 
used

a virtual listview.  I am currently having loads of trouble using the
dataset/datagrid so I was wondering if you could let me know more 
about your

virtual listview please.

Also would the virtual listview allow for 
amendments/deletion/insertion of

data and recognise the change and update the database accordingly.

Many thanks

John

On 10/05/06, Noel Frankinet <[EMAIL PROTECTED]> wrote:



John Newby wrote:

>Hi, I am trying to access a SQLite database using the ADO.Net provider
and
>bring all the data back in a tabular form, I can bring back the data
using a
>datareader but I don't know if I can put the data into a datset or a
>datagrid.
>
>Does anyone know if you can do this?
>
>Many thanks.
>
>John.
>
>
>
> 


>
>No virus found in this incoming message.
>Checked by AVG Free Edition.
>Version: 7.1.392 / Virus Database: 268.5.5/335 - Release Date: 
9/05/2006

>
>
Hello,
I use a virtual listview directly on top of sqlite3, its in c++ but it
works very well (even on PDA). It could easily be turned in an activeX
(its ATL/WTL, no MFC).

Best wishes.


--
Noël Frankinet
Gistek Software SA
http://www.gistek.net






No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.8.4/364 - Release Date: 14/06/2006
 


Hello,
My virtual list is WTL C++ code, it runs on top of a Cdataview class 
that does all the work.
It works on PC and PDA, and yes, beiing virtual, it reflects insert and 
deletes quite well (a trigger does the Window Updating).
I can send you that code (3 .h files) but it won't be free of dependency 
from other part of my project.
I hope to one day make it into a separated project but I don't have the 
time right now,

Are you interested ?

Best wishes

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] external indexing

[Noel Frankinet]

Rusty Conover wrote:



Using a temporary table seems to be the best way when you have lots  
of keys.  Of course there is a tradeoff point, such as for 1 or 2  
rows a temporary table is overkill.  Also it depends on if you're  
temporary table is being stored in memory or on the disk, check the  
relevant PRAGMA documentation to specify how you want them stored.


CREATE TEMP TABLE search_keys(oid INTEGER NOT NULL PRIMARY KEY);

Next, insert all of the records you're searching for into search_keys  
table.


You might want to do an "ANALYZE" here on the temporary table, so the  
planner can pick the most efficient way to do the upcoming join  
depending on the number of rows you're searching for, and the number  
of rows you're searching in.


Do the actual select:

SELECT ... from search_keys, target where search_keys.oid = bar.oid

I believe the ordering of the tables in the from clause may be  
important as the planner may use it in determining which table to  
process first, but if there are statistics about all of the tables it  
may reorder them.  drh, would know actual behavior for sure.


Finally don't forget to:

DROP TABLE search_keys

Cheers,

Rusty
--
Rusty Conover
InfoGears Inc.
Web: http://www.infogears.com



Hello Rusty,
Exactly what I was looking for
I've seen the PRAGMA TEMP_STORE to create a memory table.
Do you think I can join a memory table and a disk based one ?

Anyway, thank a lot
Best wishes


--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

[sqlite] external indexing

[Noel Frankinet]

Hello All,

since nobody has answered my last question, I'll try to rephrase it :
How do you select record you have the keys (and I mean a lot of keys)
I know
SELECT .. WHERE rowid=
SELECT .. WHERE rowid IN (something like that)
SELECT ... WHARE rowid BETWEEN ...

Is there another way, does a temporary table helps ?

Thank you

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] SQLite as R data store and spatial data maybe ?

[Noel Frankinet]

[EMAIL PROTECTED] wrote:


Noel Frankinet <[EMAIL PROTECTED]> wrote:
 

You might want to take a look at DRH's proposal, 
http://www.sqlite.org/cvstrac/wiki?p=VirtualTables
which looks like it would make it easier for the R community to 
implement the sort of interface you're talking about.
 


I've read the proposed virtualTable schema.
Mr Hipp could you elaborate on how you envision spatial indexing ?
   



I've not thought about it.  The VirtualTable proposal was
developped to support full-text search and as something to
replace the (goofy) pragmas currently used to find schema
information.  I would imagine that virtualtables would also
be useful for spatial indexing, but I have not looked closely
into the matter.
--
D. Richard Hipp   <[EMAIL PROTECTED]>



 


Thank you for your reply,
I suppose that whatever indexing technique, it boils down to " I have 
that bunch of keys please return the corresponding records".
I can then use IN or BETWEEN statement, but I suspect that a UNION 
between a TABLE(query_quadtree(interesting_window)) (is this a virtual 
table?) and my target table would do better.

Am I right ? maybe a little bit confused ?

Best regards




--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] SQLite as R data store and spatial data maybe ?

[Noel Frankinet]

Eric Bohlman wrote:


Andrew Piskorski wrote:


As an R user, I'm happy to see the project below, it could become a
very handy use of SQLite. 
I suspect it's well out of scope for that project, but it would be

particularly cool to eventually see some of the integration go the
other way, and allow use of SQLite's SQL engine to manipulate R data
frames (which are tables, basically) from within R, as that would be
much more powerful than R's rather limited set of data frame
manipulation functions.



You might want to take a look at DRH's proposal, 
http://www.sqlite.org/cvstrac/wiki?p=VirtualTables
which looks like it would make it easier for the R community to 
implement the sort of interface you're talking about.





Hello all,

I've read the proposed virtualTable schema.
Mr Hipp could you elaborate on how you envision spatial indexing ?
I now construct a in memory quadtree of my spatial structure, so that I 
get a set of key when I do a "window query".
I suppose now that I need to create a temporary table of thoses key and 
then do a kind of union between this table and my target 
geometry+attributes table. How would  a virtual table help that process ?


Thank you

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] Re: AW: AW: Re: spatial sqlite anyone ?

[Noel Frankinet]

George Ionescu wrote:


Hello Noel,
 



Hello George


I'm reposting this message because I have the feeling that you missed the
original one.

 

I don't plan to replace the normal indexing, I plan to have a set of 
function to create a (memory ?) index. But how do I retrieve the data 
without doing a select where rowid = xxx ?
   



If you're going to create a memory index, than this will be no sqlite
spatial index extension: I'm already doing this now by selecting records
from a table and creating an in-memory spatial index.
 

the question is how to select in a table when you have a set of keys, I 
think that I have a path now, but I have to check that



I don't know whether by coincidence or not, dr. Hipp has just published a
wiki page regarding Virtual Tables which might do the trick, and although
it's in very incipient stage (e.g. proposal) it sounds interesting. Go check
it out at http://www.sqlite.org/cvstrac/wiki?p=VirtualTables.
 

yes we need temporary table for that, that was the missing link, I'll 
check what virtual table is, but I suppose that it has to do with the 
TABLE() sql statement.



I must confess that I'm a little tired right now and I cannot see the
Virtual Table's application in Spatial Indexes :-) Perhaps tomorrow morning
my luck will change and I'll be enlightened.

And another think, regarding your second wannado:

 


2 - to be able to load and exchange data from WKT (well know text
format) and binary (shape file for instance)
   



I don't know / think whether this extension should / must be able to read an
ESRI shape. You should design your extension carefully with a pluggable way
of doing readers/writers. This way, if anyone needs to work with a special
format he/she could write it if it doesn't exist.
 

I was saying that because I already do it, using shapelib, and shape 
files are a de facto standard.



I'm saying that because, for example, I've chosen to use an SVG-style
notation for storing my gis elements.

George.


 




--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: AW: AW: [sqlite] Re: spatial sqlite anyone ?

[Noel Frankinet]

Martin Pfeifle wrote:


Hello Noel,
I think you can find more information on the computation of the upper hull values in 
[FFS00] "Implementing Geospatial Operations in an Object-Relational Database 
System".
 


Yes I'm already reading that.


For testing, we used oracle, where we had transient tables.
I am not sure whether we have transient memory tables in SQLite. If yes, you 
can use them.
 


I think sqlite has it



The simple box elimination always goes along with a full table scan. Assume you 
have the polygons of complete Europe in your database and you do a selective 
spatial query, you still have to evaluate all bounding boxes of all polygons. 
In that case a hierarchical organization of the data, e.g. by the Relational 
Quadtree or the Relational R-tree, is certainly much more efficient. If you 
always select let's say more than 10% of all polygons, then the box filtering 
might be enough.
 


I'm going to use the quadtree approach, will see if its already usable
Do you already have working code on sqlite ?

Best regards


Best Martin



- Ursprüngliche Mail 
Von: Noel Frankinet <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Gesendet: Freitag, den 19. Mai 2006, 09:38:13 Uhr
Betreff: Re: AW: [sqlite] Re: spatial sqlite anyone ?


Martin Pfeifle wrote:

 


Hi,
I think the simplest solution would be to put a spatial index on top of the 
B-tree, that's what e.g. Oracle does in their Spatial Cartridge.
Basically you store the index data in relations and index these relations by 
B-trees.
In this case, you do not have to change the core code of SQLite. You can 
already do this now.
Nevertheless, it would be nice, if SQlite supports somehow the "extensible indexing 
interface".
So, you ask a spatial query and in the background the system uses the index 
data stored in relations.
We have done a lot of research on that topic. To get acquainted to the basic 
idea, you might have a look at
"The Paradigm of Relational Indexing: A Survey".

In my opinion, a direct integration of a spatial index is of course preferable, 
but who is going to do that?

Best Martin



   


Hello Martin, hello All,

Thank you for the above link, it is very useful.
I definitely want to go the spatial index map to btree index way.
I especially like the quad-tree select because I understand it and I 
already have most of the building blocks :

SELECT DISTINCT idx.id
FROM polygons_quadtree idx,
  TABLE(ZDecompose(BOX()) titles,
 Table(ZupperHull(tiles.zval)) uh
WHERE (idx.zval BETWEEN tiles.zval AND ZHi(tiles.zval))
OR (idx.zval = uh.zval);
Well almost, I know how to make ZDecompose, I still not sure about ZHi, 
ZUpperHul, do you have any more pointers ?


I didn't konw the TABLE statement to return a pseudo table, 
unfortunately, it seems not available in sqlite, can it be emulated by a 
transient memory table ?
Do you think that such a complex statement has any chance to be speedier 
than a simple bbox elimination ?



Thanks again,
Best regards


 




--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: AW: [sqlite] Re: spatial sqlite anyone ?

[Noel Frankinet]

Martin Pfeifle wrote:


Hi,
I think the simplest solution would be to put a spatial index on top of the 
B-tree, that's what e.g. Oracle does in their Spatial Cartridge.
Basically you store the index data in relations and index these relations by 
B-trees.
In this case, you do not have to change the core code of SQLite. You can 
already do this now.
Nevertheless, it would be nice, if SQlite supports somehow the "extensible indexing 
interface".
So, you ask a spatial query and in the background the system uses the index 
data stored in relations.
We have done a lot of research on that topic. To get acquainted to the basic 
idea, you might have a look at
"The Paradigm of Relational Indexing: A Survey".

In my opinion, a direct integration of a spatial index is of course preferable, 
but who is going to do that?

Best Martin

 


Hello Martin, hello All,

Thank you for the above link, it is very useful.
I definitely want to go the spatial index map to btree index way.
I especially like the quad-tree select because I understand it and I 
already have most of the building blocks :

SELECT DISTINCT idx.id
FROM polygons_quadtree idx,
  TABLE(ZDecompose(BOX()) titles,
 Table(ZupperHull(tiles.zval)) uh
WHERE (idx.zval BETWEEN tiles.zval AND ZHi(tiles.zval))
OR (idx.zval = uh.zval);
Well almost, I know how to make ZDecompose, I still not sure about ZHi, 
ZUpperHul, do you have any more pointers ?


I didn't konw the TABLE statement to return a pseudo table, 
unfortunately, it seems not available in sqlite, can it be emulated by a 
transient memory table ?
Do you think that such a complex statement has any chance to be speedier 
than a simple bbox elimination ?



Thanks again,
Best regards


--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

[sqlite] external indexing

[Noel Frankinet]

Hello All,

Still trying to figure out the best way to index on top of sqlite (for 
spatial indeex).
Lets say the the external index gives me a bunch of rowid, what would be 
the correct way to send that to sqlite ?

(My sql levelis rather low)
Should I bypass the sqlparser or is there an efficent way to do that in 
SQL?


Best regards

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: AW: AW: [sqlite] Re: spatial sqlite anyone ?

[Noel Frankinet]

Martin Pfeifle wrote:


Hi,
the baisc idea of the Relational R-tree is to map the hierarchical relationship 
between the R-tree nodes to a (father, son) relation where a b-tree is on 
father. You can the traverse the relation preferable using recursive SQL, if 
not available, you have to do it on your own.
The Idea of the Relational Quadtree is to select the Quad numbers according to 
a space filling curve,e.g. z-values.
 



that's what I had in mind, mapping a quadtree key to an integer key (I 
have seen something about morton code).
However I still get a key set, what kind of sql may I use to avoid one 
by one select ?

Do you have any pointer for that ?


Then again you can use ordinary SQL.

- Ursprüngliche Mail 
Von: Noel Frankinet <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Gesendet: Donnerstag, den 18. Mai 2006, 09:50:56 Uhr
Betreff: Re: AW: [sqlite] Re: spatial sqlite anyone ?


Martin Pfeifle wrote:

 


Hi,
I think the simplest solution would be to put a spatial index on top of the 
B-tree, that's what e.g. Oracle does in their Spatial Cartridge.
Basically you store the index data in relations and index these relations by 
B-trees.
In this case, you do not have to change the core code of SQLite. You can 
already do this now.
Nevertheless, it would be nice, if SQlite supports somehow the "extensible indexing 
interface".
So, you ask a spatial query and in the background the system uses the index 
data stored in relations.
We have done a lot of research on that topic. To get acquainted to the basic 
idea, you might have a look at
"The Paradigm of Relational Indexing: A Survey".

In my opinion, a direct integration of a spatial index is of course preferable, 
but who is going to do that?

Best Martin



   


Not me,

Thank you for the article,
If I get the key from the quadtree/rtree index, what is the way to get 
the data while staying "on top" of sqlite ?
If can see the following schema: select data according to normal sql 
rule (all the non spatial rules) then filter it spatailly (that's what I 
do now, simple bbox filtering, no indice).
I would prefer the other way around, use spatial index, get a subset (a 
key set ?) then apply sql alphanumerical filter.

Do you know a way to do that in sqlite ?

Best regards

 


- Ursprüngliche Mail 
Von: George Ionescu <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Gesendet: Donnerstag, den 18. Mai 2006, 08:28:39 Uhr
Betreff: [sqlite] Re: spatial sqlite anyone ?


Hello dear Noel,
hello all sqlite users,

a spatial extension for sqlite would be nice, although I think that
replacing the indexing scheme (e.g. replace the current b-tree with a
quad-tree or another spatial index) is alot of work.

Just some questions / thoughts:

1. How would you handle indexing? Would you replace completely the btree
with a spatial index (the hardest thing to do)? And if so, btree indexing
would still be available or not?

2. Go for GEOS's STRTree. It's the fastest spatial index I could find (I did
some research awhile ago on open-source solutions regarding spatial
indexes).

3. You might want to take a look at SpatialIndex
(http://u-foria.org/marioh/spatialindex/). The library is pretty clever
designed and it supports RSTAR-tree, MVR-tree and TPR-tree. The problem I
found with this library was that it was slower than GEOS at the time I last
checked. One of the features I like is that it allows persisting the index.
This might be an intermediate solution: you could store the index as a blob
in the database. It would not be very efficient (as efficient as replacing
indexing) but it would be a place to start.

4. Another nice library who might do the job is CGAL (http://www.cgal.org/).
I didn't benchmarked it mostly because GEOS suited my needs just fine, but
how knows, it might be better than the ones I mentioned.

George.




   




 




--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: AW: [sqlite] Re: spatial sqlite anyone ?

[Noel Frankinet]

Martin Pfeifle wrote:


Hi,
I think the simplest solution would be to put a spatial index on top of the 
B-tree, that's what e.g. Oracle does in their Spatial Cartridge.
Basically you store the index data in relations and index these relations by 
B-trees.
In this case, you do not have to change the core code of SQLite. You can 
already do this now.
Nevertheless, it would be nice, if SQlite supports somehow the "extensible indexing 
interface".
So, you ask a spatial query and in the background the system uses the index 
data stored in relations.
We have done a lot of research on that topic. To get acquainted to the basic 
idea, you might have a look at
"The Paradigm of Relational Indexing: A Survey".

In my opinion, a direct integration of a spatial index is of course preferable, 
but who is going to do that?

Best Martin

 


Not me,

Thank you for the article,
If I get the key from the quadtree/rtree index, what is the way to get 
the data while staying "on top" of sqlite ?
If can see the following schema: select data according to normal sql 
rule (all the non spatial rules) then filter it spatailly (that's what I 
do now, simple bbox filtering, no indice).
I would prefer the other way around, use spatial index, get a subset (a 
key set ?) then apply sql alphanumerical filter.

Do you know a way to do that in sqlite ?

Best regards


- Ursprüngliche Mail 
Von: George Ionescu <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Gesendet: Donnerstag, den 18. Mai 2006, 08:28:39 Uhr
Betreff: [sqlite] Re: spatial sqlite anyone ?


Hello dear Noel,
hello all sqlite users,

a spatial extension for sqlite would be nice, although I think that
replacing the indexing scheme (e.g. replace the current b-tree with a
quad-tree or another spatial index) is alot of work.

Just some questions / thoughts:

1. How would you handle indexing? Would you replace completely the btree
with a spatial index (the hardest thing to do)? And if so, btree indexing
would still be available or not?

2. Go for GEOS's STRTree. It's the fastest spatial index I could find (I did
some research awhile ago on open-source solutions regarding spatial
indexes).

3. You might want to take a look at SpatialIndex
(http://u-foria.org/marioh/spatialindex/). The library is pretty clever
designed and it supports RSTAR-tree, MVR-tree and TPR-tree. The problem I
found with this library was that it was slower than GEOS at the time I last
checked. One of the features I like is that it allows persisting the index.
This might be an intermediate solution: you could store the index as a blob
in the database. It would not be very efficient (as efficient as replacing
indexing) but it would be a place to start.

4. Another nice library who might do the job is CGAL (http://www.cgal.org/).
I didn't benchmarked it mostly because GEOS suited my needs just fine, but
how knows, it might be better than the ones I mentioned.

George.


 




--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] Re: spatial sqlite anyone ?

[Noel Frankinet]

George Ionescu wrote:


Hello dear Noel,
hello all sqlite users,

a spatial extension for sqlite would be nice, although I think that
replacing the indexing scheme (e.g. replace the current b-tree with a
quad-tree or another spatial index) is alot of work.

Just some questions / thoughts:

1. How would you handle indexing? Would you replace completely the btree
with a spatial index (the hardest thing to do)? And if so, btree indexing
would still be available or not?

2. Go for GEOS's STRTree. It's the fastest spatial index I could find (I did
some research awhile ago on open-source solutions regarding spatial
indexes).

3. You might want to take a look at SpatialIndex
(http://u-foria.org/marioh/spatialindex/). The library is pretty clever
designed and it supports RSTAR-tree, MVR-tree and TPR-tree. The problem I
found with this library was that it was slower than GEOS at the time I last
checked. One of the features I like is that it allows persisting the index.
This might be an intermediate solution: you could store the index as a blob
in the database. It would not be very efficient (as efficient as replacing
indexing) but it would be a place to start.

4. Another nice library who might do the job is CGAL (http://www.cgal.org/).
I didn't benchmarked it mostly because GEOS suited my needs just fine, but
how knows, it might be better than the ones I mentioned.

George.

 

 


Hello George,

Thanks a lot for your input,

I don't plan to replace the normal indexing, I plan to have a set of 
function to create a (memory ?) index. But how do I retrieve the data 
without doing a select where rowid = xxx ?


Best regards


--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: AW: [sqlite] spatial sqlite anyone ?

[Noel Frankinet]

Martin Pfeifle wrote:


I am very interested.
We are working on spatial sqlite for almost one year.
We plan to include sqlite into an embedded spatial application.
You mention that there are open-source code for library 3 and 4.
Can you give me a hint where to find it?
I will contact you at the end of the week providing more information about our 
"spatial sqlite"
and the requirements of our application.
Best Martin

 



Hello Martin


I also have some working code. I use it on a pda application.
for point 3 and 4 I was thinking to the rtree library (i don't have a 
link right now, but google knows it), and the geos lib (from posgis).
I wait for your mail, I hope that we will find contributor, a spatial 
sqlite would be a "killer" app I think.


Best wishes


--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

[sqlite] spatial sqlite anyone ?

[Noel Frankinet]

Hello all,

I would like to set up a project to "spatialise" sqlite.
1 - to be able to create geometry colum that would store 
points,multipoints,lines,multilines,polygones and multi-polygones (Ogis 
"simple features")
2 - to be able to load and exchange data from WKT (well know text 
format) and binary (shape file for instance)
3 - to create a spatial index on geometry data (either an quadtree or a 
more advanced Rtree).

4 - to do spatial operation (join, disjoin, near, ...) on those data.

I'm ready to contribute code for 1 and 2, there are open-source c or c++ 
library for 3 and 4.


Ideally source should be on sqlite.org.

What do you think ? Any interest ?

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] VB.Net DataSet & DataGrid with ADO.Net Provider

[Noel Frankinet]

John Newby wrote:


Hi, I am trying to access a SQLite database using the ADO.Net provider and
bring all the data back in a tabular form, I can bring back the data using a
datareader but I don't know if I can put the data into a datset or a
datagrid.

Does anyone know if you can do this?

Many thanks.

John.

 




No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.5/335 - Release Date: 9/05/2006
 


Hello,
I use a virtual listview directly on top of sqlite3, its in c++ but it 
works very well (even on PDA). It could easily be turned in an activeX 
(its ATL/WTL, no MFC).


Best wishes.


--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] extensible indexing

[Noel Frankinet]

Martin Pfeifle wrote:


Dear all,
is it somehow possible to add an own index-structure,
e.g. M-tree, R-tree, Quadtree...to SQLite?
Has anyone ever done that?
Best Martin







___ 
Telefonate ohne weitere Kosten vom PC zum PC: http://messenger.yahoo.de



 


Hello Martin,
Apparently nobody,
I'm also very interested in R-Tree,
I do build and use a Quadtree, but in memory.
I also load gis data from sqlite, but without index.
Does somebody knows how to complete the process ? (loading gis data with 
spatial index).
I have read somewhere that a quadtree index can be encoded in an integer 
key, that would be enough for me.

Does somebody has a pointer ?

Best wishes



--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] Sqlite and Java

[Noel Frankinet]

Kervin L. Pierre wrote:



Cloudscape, which was given to Apache foundation
and is now the Apache Derby Project.
http://db.apache.org/derby/



Yes this is it !

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] Sqlite and Java

[Noel Frankinet]

Nilo Paim wrote:




Hi Noel,

Maybe slower, maybe memory hungry... but not less portable in my 
opinion. Java is machine independent, unless when using native code. 
On that scenario ( native code ) Java is not portable.


My point is: I would like to have access to sqlite databases from java 
without worrying me about native code, dll's, .so'es, etc..., just 
using only pure java code, without lossing the normal access to the 
same databases, using the "normal" way, via C, C++ or any other 
compiled language.


Thanks for your quick response.

Cheers,

Nilo
Porto Alegre - Brasil


Hello Nilo,

I think there a IBM open source sql engine in pure Java. But I don't 
rember the name right now.

May be you could use that ?

Regards

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] Sqlite and Java

[Noel Frankinet]

Nilo Paim wrote:


Hi all,

Does anybody here knows something about a port of sqlite to java?

Please, note that I'm not talking about java calling sqlite via JNI, but
about a real rewrite of sqlite using java. Obviously, a second step
would be the writing of a JDBC driver.

Would be useful that port?

Comments? Suggestions?

Thanks to all.

Nilo
Porto Alegre - Brasil



Hello Nilo,

What would be the point ?
A slower, memory hungry, less portable sqlite ?

Cheers,

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] Final Year Project/Dissertation help required!!!!

[Noel Frankinet]

John Newby wrote:


No, I'm not asking the community to do my homework for me, I need to do a
user analysis phase for my dissertation, and as I don't know anyone who uses
SQLite this is the only place I can get my questions answered.

Many thanks.

John.

On 13/12/05, juan perez <[EMAIL PROTECTED]> wrote:
 


So in a nutshell you are asking the community to do your homework. What
a shame.

Start by analyzing the sqlite3 command line interface, make a GUI that
replicates that (and more, heck its a GUI), contribute it to the sqlite
project, THEN talk about your dissertation.

jp.

John Stanton wrote:
   


john.newby wrote:

 


Hi, I am doing my final year project/dissertation on "Creating a GUI to
SQLite"

I am after help for my analysis phase and would like any comments/help
from
members or if you could put me in the right direction as to where I
   


could
   


find out this information.

I would like information regarding SQLite for the following if at all
possible:-

Why users use SQLite instead of other SQL databases?
   


SQLite has two fine features.  Firstly it is simple, lives in one file
and doesn't require a server process.  Secondly it implements all the
important elements of SQL.

 


Would a GUI detract users from using SQLite?
   


There is a wagon load of GUIs to SQLite already.  They neither add nor
detract from the DBMS.

 


Regarding a GUI to SQLite:-

What features a GUI MUST have?
What features you would LIKE a GUI to have?
What features you would NOT LIKE to have?
   


This is like asking what features are needed in a coat without
specifying its intended usage.

 


Any help on these questions or any other information you may feel
would help
me on my journey would be greatfully appreciated.

You can contact me at my University email address on
   


[EMAIL PROTECTED]
   


Many thanks for your help.

John.





This e-mail is intended solely for the addressee. It may contain
private and
confidential information. If you are not the intended addressee,
please take
no action based on it nor show a copy to anyone. Please reply to this
e-mail
to highlight the error. You should also be aware that all electronic
   


mail
   


from, to, or within Northumbria University may be the subject of a
request
under the Freedom of Information Act 2000 and related legislation, and
therefore may be required to be disclosed to third parties.
This e-mail and attachments have been scanned for viruses prior to
leaving
Northumbria University. Northumbria University will not be liable for
   


any
   


losses as a result of any viruses being passed on.


   



 

   



 




No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.13.13/198 - Release Date: 12/12/2005

 


Hello,

I would propose :

Creates a stand alone explorer like utility.
Left pane a tree view showing table, views and indexes.
Right pane, a tab control where each opened table will be displayed.

In the tree view, a context menu to open a table, create a new table, 
create an index, a view, drop a table and so on.

In the right pane use a virtual ListView control to show the data.
A shell like control to enter direct sql commands.
A form editor to defines editing mask (saved in xml of course and in a 
"system table").

A small scripting language (lua ?) to create user defined commands.

There must be dialog boxes or wizard to help the creation of table, and 
data query.

There must be facilities to import and export data in various format.

Utility must be stand alone, does not depends on any runtime besides sqlite.
Must be cross platform, so use wxwindows, or qt, and run on a PDA.
Must be open source, BSD licensed or public domain so that I can steal it.

Anything else ?

Regards

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] Trying to compile under VC.NET

[Noel Frankinet]

Henning Folger wrote:


Hello,

I am happy to find sqlite. This backend fully matches my need regarding
to a projekt of mine.
But i have to make some changes to fit into my project.

So i tried to recompile the sources under VC.NET. On the web page i
found a howto to do it, but i have no luck with it.
I always get the error C1010, unexpected end of file while looking for
precompiled headers.

Is there anyone out who can help me or can send me an an howto or maybe
a dsw-File?

Thanks for your help

Henning



 


turn off precompiled header ?

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] Probably not simple question

[Noel Frankinet]

erw2 wrote:


I have follow your advice and had a look at CppSQLite. setBinary and
getBinary functions work only on unsigned char, and size of intDouble is
(on my PC) 8 bytes, so much more than unsigned char (1 byte).
The question is how to correctly store such structure in db, and how to
restore it later?

Regards
WojciechW



 



Hello,
when storing, create a blob from your structure and store it.
When retrieving, validate the blob (by its size, by a magic number at 
the end or something like that) then feed the blob into malloced memory 
and you get your object back (even if its a collection of objects)


Best wishes,

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] Probably not simple question

[Noel Frankinet]

[EMAIL PROTECTED] wrote:


Hello,
I have a following problem.
In my program I have a vector of elements let say defined as follow:

struct intDouble {
 int x;
 int y; 
};


Now, I would like to put the contents of this vector into sqlite table, to
be able than read it back. Mayby someone can suggest some solution how to do
it in C++??



Regards
WojciechW.

 




No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.13.12/193 - Release Date: 6/12/2005
 

I use a blob, your class have to be able to output and be constructed by 
the same blob.


Best wishes

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] SQLite for CAD database

[Noel Frankinet]

Rajan, Vivek K wrote:

Hello- 




Has anyone used SQLite database for storing CAD database: especially
netlist and physical connectivity/topology? If so, what kind of
performance have you been able to get? 




Rajan




 




No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.8/183 - Release Date: 25/11/2005
 


Hi,

I use sqlite for gis data (polygone, polylines, points). No connectivity 
yet but topological layer (surface connected to line connected to point) 
are on my road map. Up to now, speed is very good even for hundred of 
thousands of objects. I use a quadtree indexing scheme that seems good 
enough.

Best regards

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] functions that return tables

[Noel Frankinet]

Nathan Kurz wrote:


Perhaps related to the recent questions about converting rows to
columns, I'm finding the need for user defined aggregate functions
that can return multiple values, or ideally multiple rows of values. 


Assume you to determine the highest N values from column.  You'd want
a aggregate function like max_n(col, n) that makes one pass through
the table, saving the highest values it sees, and then returning them.

SELECT max_n(col, 3) FROM test;
max
---
10
9
8

My current workaround is to have my function return a comma separated
list of values ("10,9,8"), parse this string in my application, and
generate a new query, but ideally I'd like to do this in one step.

Is there any reasonable way to accomplish this?  Or am I left with
defining a new function type that returns a handle to a temp table,
and new parsing logic to wrap the right OP codes around that function?

Thanks!

Nathan Kurz
[EMAIL PROTECTED]


 


Hello Nathan,
why not a vector of values ?
Regards,

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] uSQLiteServer Source code available

[Noel Frankinet]

Doug Nebeker wrote:


I have a simple C++ HTTP server that I wrote (all in a single .cpp and
.h file).  Multi-threaded, has a session concept (via cookies), can
parse POST and GET variables.  It is a C++ class that you can derive
from and then override the LoadFile method (which is where I typically
put my command/transaction processing).  The default just serves files
from a defined directory.  Implemented on Windows with the Win32 API, so
there would be some porting to get it onto other platforms.

I'd be happy to put out somewhere if anyone is interested (and I'd love
to receive feedback--always happy to learn from anyone).

By the way, it is my personal work and not owned in any way by my
employer (<-- decided to put that there for my own sake...)

Doug

-Original Message-
From: David Fletcher [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, November 15, 2005 7:59 AM

To: sqlite-users@sqlite.org
Subject: RE: [sqlite] uSQLiteServer Source code available


 


"r" == roger  <[EMAIL PROTECTED]> writes:
   



r> HTTP would be the logical choice, telnet is often firewalled. BTW, 
r> you can of course allready telnet into the server anyway.


r> I will try doing something like this, but I have never implemented 
r> the server side of a HTML connection. Do you know where I can find a 
r> quick guide to making a simple HTTP server? Better still, what about 
r> a small simple ready made HTTP server of the sort that can be 
r> embedded into the application and has hooks to callback into user 
r> code?


I know that Qt has something like this, but I can't recall if this is
only available in the enterprise (commercial) edition or not.  Check
http://www.trolltech.com for more.  See
http://doc.trolltech.com/4.0/qhttp.html, for example.

http://www.sourceforge.net has some http clients and servers, too.  A
search there should turn up some results.

HTH

 


Hello Doug,
I am *very* interested, I'm searching something like that for quite some 
time.
I have a sax like xml parser (not validating) in one .h file (C++) if 
somebody is interested !

Best regards



--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] sqlite and spatial extension

[Noel Frankinet]

Rajan, Vivek K wrote:

Hello- 


Are there spatial extensions available for sqlite? And/or is there any
add-on library/shareware/freeware which can enable spatial
extensions/queries with SQLite? 


Rajan



 


Hello,

None that I'm aware of also I do use sqlite to store geagraphical info, 
but as a blob.
I have a crude spatial indexing but I would like to find a better 
solution. Any idea ?


--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] Question about SQLite and spatial data

[Noel Frankinet]

Rajan, Vivek K wrote:


I have a need to store spatial and connectivity data (think verilog
netlist with x, y coordinate information) in a persistence on-disk file.
I am looking at different SQL-based databases and am wondering if anyone
has recommendations/opinions on how good SQLite is for:

 - Storing spatial data. An examples, documentation and support links

 - Performing spatial queries and indexing for very large hierarchical
data set



Please advice.



Rajan


 




No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.18/91 - Release Date: 6/09/2005
 


Hello,

I do it. I have a collection of graphical classes (line, polylines, 
) than can be saved and retrieved from sqlite. I use the 2.8. The 
shape are saved as blob encoded in text. When drawing or selecting, 
shapes are pulled from the Geometry column via sqlite call-back mechanism.
Shape class have a static factory method that takes the blob pulled from 
db as parameter and return a well formed object.


The table schema is made from a primary key , 4 int for a bounding box, 
a the geometry blob.
I try now to make a spatial index (quadtree or rtree) but I already have 
good performance by selecting bounding box.


Best wishes

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] Have ever anybody port SQLite to WinCE

[Noel Frankinet]

jason zhang wrote:


Hi,
  Thank you.
  How about the performance of this library? 
  
- Original Message - 
From: "Noel Frankinet" <[EMAIL PROTECTED]>

To: <sqlite-users@sqlite.org>
Sent: Tuesday, August 16, 2005 2:57 PM
Subject: Re: [sqlite] Have ever anybody port SQLite to WinCE


 


jason zhang wrote:

   


Hi,
 Thank you.I just found that there is a project named "SQLite for wince" in 
sourceforge.net,
Do you use that version?
 

- Original Message - 
From: "Noel Frankinet" <[EMAIL PROTECTED]>

To: <sqlite-users@sqlite.org>
Sent: Tuesday, August 16, 2005 2:49 PM
Subject: Re: [sqlite] Have ever anybody port SQLite to WinCE




 


jason zhang wrote:

  

   


Hi all,
I am going to use SQLite on WinCE platform.Have ever anybody has experience 
with it?
I encounter some problem when I port SQLite to WinCE.




No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.9/72 - Release Date: 14/08/2005




 


Hello,
yes, I use sqlite on winCE for two years now.
Regards

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net


  

   




 

yes, I had made the first crude port to ce than I switched to that much 
better port.


--
Noël Frankinet
Gistek Software SA
http://www.gistek.net


   




 


very good, I even use it for graphic display (GIS).

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] Have ever anybody port SQLite to WinCE

[Noel Frankinet]

jason zhang wrote:


Hi,
  Thank you.I just found that there is a project named "SQLite for wince" in 
sourceforge.net,
Do you use that version?
  

- Original Message - 
From: "Noel Frankinet" <[EMAIL PROTECTED]>

To: <sqlite-users@sqlite.org>
Sent: Tuesday, August 16, 2005 2:49 PM
Subject: Re: [sqlite] Have ever anybody port SQLite to WinCE


 


jason zhang wrote:

   


Hi all,
 I am going to use SQLite on WinCE platform.Have ever anybody has experience 
with it?
I encounter some problem when I port SQLite to WinCE.




No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.9/72 - Release Date: 14/08/2005


 


Hello,
yes, I use sqlite on winCE for two years now.
Regards

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net


   




 

yes, I had made the first crude port to ce than I switched to that much 
better port.


--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] Have ever anybody port SQLite to WinCE

[Noel Frankinet]

jason zhang wrote:


Hi all,
  I am going to use SQLite on WinCE platform.Have ever anybody has experience 
with it?
I encounter some problem when I port SQLite to WinCE.
 




No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.9/72 - Release Date: 14/08/2005
 


Hello,
yes, I use sqlite on winCE for two years now.
Regards

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net