announcement: June 2021 mid term update

[Alessandro Furieri]

Hi List,

during last weeks SpatiaLite was interested by several major

changes, and consequently a community testing phase seems to

be appropriate.

NOTE: this does not corresponds to any Release Candidate;

it's simply an intermediate experimental snapshot for

testing purposes.

you'll find an exhaustive description of all changes on

the following Wiki Page (including the instructions for

downloading the pre-built binaries for Windows):

https://www.gaia-gis.it/fossil/libspatialite/wiki?name=June+2021+update&p

short summary of the coolest things worth to be tested:

1. SpatiaLite now supports FreeXL 2.0, so it has acquired 

   the capability to directly access modern spreadsheets

   based on the .xlsx format (MS Excel) or on the .ods

   format (Libre/Open Office Calc)

   

2. the previous VirtualKNN is now deprecated and no longer

   supported. the brand new VirtualKNN2 is intended to be

   a more efficient and faster full replacement for it.

   

3. and finally the most relevant architectural change.

   now mod_spaltialite has no longer any direct dependency

   on libsqlite3, and this is expected (hopefully) to  

   definitely resolve many issues reported by developers

   and users using languages as Java, Python, PHP, C# .NET

   and alike.

   

Final consideration: any testing activity is welcome.

but extensively testing the latest mod_spatialite on

Java, Python an so on has a very special relevance.

Let me known your practical findings about all this.

happy testing,

Sandro

[Maurizio Trevisani]

Thanks a lot!!!!

--
You received this message because you are subscribed to the Google Groups "SpatiaLite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to spatialite-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/spatialite-users/c79ce853-762a-48a2-87be-e00441060d6bn%40googlegroups.com.

[Totò Fiandaca]

Grazie mille.

Scusami per la brevità, ti sto scrivendo dal cellulare

To view this discussion on the web visit https://groups.google.com/d/msgid/spatialite-users/CABjWwHzF8XH-_66UcjK5%2B8Z0JEJW_rx7jLjzXph-L4xvr5kCXw%40mail.gmail.com.

[Andrea Peri]

Hi, Sandro,

I'm glad to know this.

I just updated my server wms server with your spatialite fossil in the 20 june .

should I update to have last version ?

thx,

Andrea

I update my server , with last available from spatialite in the 20 june.

inin the 21 june

--

You received this message because you are subscribed to the Google Groups "SpatiaLite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to spatialite-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/spatialite-users/c79ce853-762a-48a2-87be-e00441060d6bn%40googlegroups.com.

--

-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------

[a.fu...@lqt.it]

On Thu, 24 Jun 2021 22:19:46 +0200, Andrea Peri wrote:
> Hi, Sandro,
>
> I'm glad to know this.
>
> I just updated my server wms server with your spatialite fossil in
> the
> 20 june .
> should I update to have last version ?
>

ciao Andrea,

yes, you should update yet another time because my last commit
supporting
KNN2 was on June 21

bye Sandro

[Jeff McKenna]

Hi Sandro, I'll do some build testing on Windows for this. Thanks for
your efforts,

-jeff

> --
> You received this message because you are subscribed to the Google
> Groups "SpatiaLite Users" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to spatialite-use...@googlegroups.com

> <mailto:spatialite-use...@googlegroups.com>.

> To view this discussion on the web visit
> https://groups.google.com/d/msgid/spatialite-users/c79ce853-762a-48a2-87be-e00441060d6bn%40googlegroups.com

> <https://groups.google.com/d/msgid/spatialite-users/c79ce853-762a-48a2-87be-e00441060d6bn%40googlegroups.com?utm_medium=email&utm_source=footer>.

[Andrea Peri]

👍

--
You received this message because you are subscribed to the Google Groups "SpatiaLite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to spatialite-use...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/spatialite-users/0342dd75b884f8f562fb2db9fc3201f4%40lqt.it.

[Pedro Camargo]

Bravo!!

---- On Fri, 25 Jun 2021 04:07:08 +1000 Alessandro Furieri <alessandr...@gmail.com> wrote ----

--
You received this message because you are subscribed to the Google Groups "SpatiaLite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to spatialite-use...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/spatialite-users/c79ce853-762a-48a2-87be-e00441060d6bn%40googlegroups.com.

[Andrea Borruso]

Grazie mille

[Duncan]

Thanks Sandro

 The new KNN2 function can now easily replace the spatial index query for speed and simplicity for me, with added useful info

[bric...@outlook.com]

Thanks! I did some testing in C# on .NET Core with SQLitePCLRaw (the library behind SQLite-net and Microsoft.Data.Sqlite) and things appear to be working now. (Even with PROJ enabled!)

[a.fu...@lqt.it]

On Tue, 6 Jul 2021 12:54:04 -0700 (PDT), bric...@outlook.com wrote:
> Thanks! I did some testing in C# on .NET Core with SQLitePCLRaw (the
> library behind SQLite-net and Microsoft.Data.Sqlite) and things
> appear
> to be working now. (Even with PROJ enabled!)
>

a very good new: it seems really encouraging

thanks for your tests,
Sandro