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 w
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:
>
ID
> 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
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 stor
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 someo
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.
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 th
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://s
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.
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 fo
I've done it a long time ago before discovering that limit/offset was not
the way to go
http://www.codeproject.com/Articles/26938/AlphaView
Anyway, it worked quite well even on slow pda.
Best wishes
Noel
On 10 July 2014 15:19, - wrote:
> Hello Clemens,
>
> > Are you using a list view, or pagi
It should be painless if you omit geos, I think.
On 19 June 2014 09:00, Mohit Sindhwani 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 ?
&g
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
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 :).
>
>
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 cli
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. wrote:
> >Do you think it could be used with spatialite extension to build a
> multi-user spatial database ?
> >
&g
oups, sorry !
On 17 October 2013 16:36, Noel Frankinet wrote:
> 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:
>>
>>
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
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 q
/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.&qu
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 wrote:
> and it's already on year behind the official c sqlite. I wouldn't go
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 wrote:
> oh, yes everything in c# then, let's see the performance on an arm cpu !
>
>
> On 31 May 2013 13:23, Noel Frankinet wrote:
>
>> ah
oh, yes everything in c# then, let's see the performance on an arm cpu !
On 31 May 2013 13:23, Noel Frankinet 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
its probably an arm CPU. Good luck !
On 31 May 2013 13:16, Ali Dirik wrote:
> Thanks for answers.
>
> I use c# (VS2008)
> I am looking for c# sample source code.
>
>
> 2013/5/31 Noel Frankinet
>
> > I've used C++, do you want to use anything else. It's of
x27;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 wrote:
>
> > Hello 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?
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.
>
>
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/c3
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",
> &oDatabase, SQLITE_OPEN_CREATE, NULL);
> if (
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 >wrote:
>
> > no it sh
Is it your problem ?
On 5 April 2013 15:15, Noel Frankinet 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 wrote:
>
>> It's a very odd problem. At first I was worr
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 = sql
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
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
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
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 w
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
Access in the first place? But anyway...
On 10 December 2012 15:33, Gilles Ganault wrote:
> On Mon, 10 Dec 2012 15:07:05 +0100, Noel Frankinet
> wrote:
> >It's probably a good way to get something working, but you loose the
> >cross-platform
>
> I know, but Windows
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 fr
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
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
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
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
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
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.
>>
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
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
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
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
> di
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 sy
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@sqlit
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?
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]
>
>
>
Th
[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?
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://sqli
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!!!
__
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
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 plan
Christian Smith a écrit :
Gunnar Roth uttered:
Hello,
i want to use sqlite3 in a sub-project at work.
when compiling with warning level 4 with vc6 ( internal philosophy ) , i
get over 480 warnings. With warning level 3 there are still 119 left.
This leads to problems to convince the project lea
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
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
<.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
w
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]
--
COS a écrit :
Hi Tom,
- Original Message -
From: "T&B" <[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 lay
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
Hello all,
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 ??? cont
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 ,
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
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 progr
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:
Sent: Friday, September 15, 2006 8:02 PM
Subject: Re: [sqlite] Which API to use to get re
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
you don't call that callback , its called by sqlite...
In your case argc will b
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/2
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:
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
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 temp
[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'
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
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 d
en 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
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 t
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
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]
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 t
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
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 en
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
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 tha
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 Kost
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
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
wi
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 p
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]
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
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
[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 sugge
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
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 a
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 typical
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
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:
-
1 - 100 of 124 matches
Mail list logo
