Re: [sqlite] A hang in Sqlite

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

Re: [sqlite] A hang in Sqlite

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: >

Re: [sqlite] geopoly data input options

obably 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.o

Re: [sqlite] geopoly data input options

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

Re: [sqlite] x64 binary

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

Re: [sqlite] Sweet 16

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

[sqlite] CREATE TABLE parser

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

Re: [sqlite] sliteonline or sqlite in js

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 >

Re: [sqlite] GUI INfo

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

Re: [sqlite] Variable values in Views

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

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

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 sp

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

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,

Re: [sqlite] Suggestion for shell .IMPORT improvement

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

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

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

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

patial 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 > ___

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

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

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

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: >>>

Re: [sqlite] float to string conversion problem

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 >

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

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: >>

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

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

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

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 <noe

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

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

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

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

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

> 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: > > > Hel

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

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

Re: [sqlite] SQL Logic error or missing database

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

Re: [sqlite] SQL Logic error or missing database

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

Re: [sqlite] SQL Logic error or missing database

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,

Re: [sqlite] SQL Logic error or missing database

. > > 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.

Re: [sqlite] SQL Logic error or missing database

turned. 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: > &g

Re: [sqlite] SQL Logic error or missing database

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:

Re: [sqlite] SQL Logic error or missing database

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. > > > >

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

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

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

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

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

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: >

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

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

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

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 loo

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

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

Re: [sqlite] VC++ and SQLite

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

Re: [sqlite] VC++ and SQLite

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'

Re: [sqlite] VC++ and SQLite

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

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

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

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

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 20

Re: [sqlite] Is the absence of msvcrt.dll a known issue with SQLite 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. >>

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

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

Re: [sqlite] sqlite compile error

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

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

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

Re: [sqlite] Quick question:

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 >

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

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

[sqlite] wtl list view article on codeproject

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

Re: [sqlite] rtree extension - Windows Binary?

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

Re: [sqlite] Thank you

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] > > >

Re: [sqlite] Please test lastest CVS using WinCE

[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?

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

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 >

Re: [sqlite] SQlite in PDA with Windows CE

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!!!

Re: [sqlite] Script Language

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, a

Re: [sqlite] Script Language

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

Re: [sqlite] SQLite GUI app that offers layouts

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

Re: [sqlite] SQLite GUI app that offers layouts

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

Re: [sqlite] SQLite GUI app that offers layouts

<.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

Re: [sqlite] SQLite GUI app that offers layouts

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

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

Re: [sqlite] "contains" function

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

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

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

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

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

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

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

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

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: [sq

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

Re: [sqlite] converting a sqlite table to dbf

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

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

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: >

Re: [sqlite] external indexing

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

[sqlite] external indexing

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

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

[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

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

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

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

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

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

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: Frei

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

[sqlite] external indexing

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

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

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: s

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

Re: [sqlite] Re: spatial sqlite anyone ?

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

Re: AW: [sqlite] spatial sqlite anyone ?

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

[sqlite] spatial sqlite anyone ?

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

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

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

Re: [sqlite] extensible indexing

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

Re: [sqlite] Sqlite and Java

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

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

Re: [sqlite] Sqlite and Java

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

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

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

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

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

Re: [sqlite] Probably not simple question

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

Re: [sqlite] Probably not simple question

[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

Re: [sqlite] SQLite for CAD database

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

Re: [sqlite] functions that return tables

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

Re: [sqlite] uSQLiteServer Source code available

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

Re: [sqlite] sqlite and spatial extension

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

Re: [sqlite] Question about SQLite and spatial data

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: -

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

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 anybod

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:

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

  1   2   >