First release candidate of MobilityDB 1.3

This release fixes a few bugs detected in 1.3.0-alpha, and improves the documentation to detail the changes between 1.2 and 1.3.

What's Changed

• Add tfloat_max_value by @Davichet-e in #711
• Add EU funding to documentation by @estebanzimanyi in #714
• Fix ever/always comparisons by @estebanzimanyi in #713
• Improve stops function by @estebanzimanyi in #712
• Add to documentation a section for migrating 1.2 -> 1.3 by @estebanzimanyi in #716
• Fix big-endian handling for ttext type and refactor code to remove redundancy by @mschoema in #718
• Swap 'diff' arguments for intuitive test reporting by @mschoema in #720
• Fix write past end of array bug in tgeoseq_merge_array_iter by @mschoema in #719
• Update pgversion.yml to start testing PG18 by @robe2 in #723
• Fix the commutators of the ttext temporal compops by @mschoema in #722
• Improve external function names to align with PG naming by @estebanzimanyi in #724
• Changed wkb size for geo_as_ewkb by @nhungoc1508 in #731
• Update build workflow for macos by @leilabourouf in #734
• Extract /postgres from /meos by @estebanzimanyi in #726
• Remove support of PG 13 by @estebanzimanyi in #743
• Replicate PostGIS fix for lwcircstring_from_lwpointarray by @estebanzimanyi in #744
• Add tests to MEOS by @estebanzimanyi in #742
• Remove const qualifier for array arguments by @estebanzimanyi in #745
• Uniformize function names by @estebanzimanyi in #747
• Remove local and postgres includes from new exported header files by @Diviloper in #748
• Uniformize tsequence and tsequencset constructors by @estebanzimanyi in #750
• Add beforeTimestamp and afterTimestamp restriction functions by @estebanzimanyi in #752
• Implement a 0(1) mapping from Oid -> meosType by @estebanzimanyi in #753
• Missing quotes in SQL. by @w345731923 in #755
• Add trend, segmentMinDuration, and segmentMaxDuration functions by @estebanzimanyi in #756
• Single parsing for MEOS values by @estebanzimanyi in #754

New Contributors

• @robe2 made their first contribution in #723
• @leilabourouf made their first contribution in #734
• @w345731923 made their first contribution in #755

Full Changelog: v1.3.0-alpha...v1.3.0rc1

This is a small bugfix release for 1.2.

The main two things changes are:

• Update code to work with PG 18
• Fix commutators of ttext, which caused issues when upgrading to PG 17+ (see #680, #725).

This release includes an upgrade file to fix the commutators. To upgrade from 1.2.0 to 1.2.1, compile and install mobilitydb 1.2.1, and then run ALTER EXTENSION mobilitydb UPGRADE TO 1.2.1;. The only thing this does is to drop and recreate the ttext comparator operators, so unless you are using them in some prepared statement or view, this should not cause issues.

What's Changed

• Improve npoint tests (#640) by @mschoema in #641
• Remove docker action and update dockerfile (#657) by @mschoema in #659
• Fix the commutators of the ttext temporal compops (#722) by @mschoema in #725
• Fix workflow (#663) by @mschoema in #727
• Update code for PG18 by @mschoema in #728
• Update pgversion.yml to test PG 17 and 18 by @mschoema in #729
• Add upgrade file from 1.2.0 to 1.2.1 by @mschoema in #730
• Update build workflow for macos (#734) by @mschoema in #739

Full Changelog: v1.2.0...v1.2.1

This is the alpha release for MobilityDB 1.3.

Major changes w.r.t. 1.2

New temporal types:

• New temporal geometry tgeometry and temporal geography tgeography types, which can represent the temporal evolution of any geometry type (polygon, multipoint, etc.).
• A new temporal circular buffer tcbuffer type, which represents a circular buffer (circle) whose position and radius changes over time.
• A new temporal pose tpose type, storing the evolution of a pose (point position + orientation) over time.
• A new rigid temporal geometry trgeometry type, which represents a fixed-shape polygon translating and rotating over time.

The tgeometry and tgeography types only allow discrete or stepwise interpolation between instants, while the other three also allow linear interpolation. Refer to the MobilityDB 1.3 documentation for more information about these new types.

Please notice that the new types tcbuffer, tpose, and trgeometry are still in development and are considered experimental.

In addition, the API of MobilityDB and MEOS was extended with new functionality and streamlined to improve usability. Finally, version 1.3 also enables the latest versions PostgreSQL 18 and PostGIS 3.6.0. For all these reasons, the binary format of the temporal types have changed from version 1.2 to 1.3 and thus a backup and restore is needed for migrating to the newer version 1.3 of MobilityDB.

Full Changelog

• Update version by @mschoema in #602
• Allow devdoc action to be run manually by @mschoema in #604
• At geom time by @estebanzimanyi in #605
• Upgrade documentation version to 1.3 by @estebanzimanyi in #606
• Improve geo_serialize by @estebanzimanyi in #607
• Add test for lat/long and improve typmod manipulation by @estebanzimanyi in #608
• Do not compile pg_bitutils.c as it's not needed and fails with mingw by @mschoema in #610
• Add PG 17 to tests by @estebanzimanyi in #612
• Modify tpoint_rtree.c with MobilityDB coding standards by @estebanzimanyi in #613
• Max header size by @estebanzimanyi in #614
• Migrate some GiST functions from MobilityDB to MEOS by @estebanzimanyi in #615
• Enable meos build by @estebanzimanyi in #616
• Improve code with cppcheck by @estebanzimanyi in #611
• Simplify meos_initialize() by @estebanzimanyi in #618
• Add doxygen documentation for network points by @estebanzimanyi in #620
• Improve naming for npoint functions and files by @estebanzimanyi in #621
• Fix MEOS build by @estebanzimanyi in #625
• Add const qualifier for string parameters by @estebanzimanyi in #626
• Add action to check MEOS compilation by @mschoema in #627
• Fix palloc by @estebanzimanyi in #628
• Cache SRID from ways table by @estebanzimanyi in #630
• Change timezone from PST8PDT to America/Los_Angeles by @mschoema in #632
• Npoint split h by @estebanzimanyi in #633
• Improve MEOS API for PG types by @estebanzimanyi in #634
• Create docker image for PG 17 by @mschoema in #635
• Fix tprecision for discrete interpolation by @estebanzimanyi in #638
• Add BUILD_SHARED_LIBS for shared or static library build by @mschoema in #639
• Improve npoint tests by @estebanzimanyi in #640
• Fix tprecision by @estebanzimanyi in #643
• Add temporal log functions by @estebanzimanyi in #644
• Add cast tbool -> tint by @estebanzimanyi in #645
• Increase coverage by @estebanzimanyi in #647
• Add mobilitydb_datagen extension by @estebanzimanyi in #649
• Add affine transform function by @estebanzimanyi in #650
• Add interpolation parameter to appendInstant by @estebanzimanyi in #648
• Improve cmake code for mobilitydb_datagen extension by @mschoema in #651
• Definition of the tcbuffer type by @estebanzimanyi in #652
• Add new functions to tcbuffer by @estebanzimanyi in #653
• Fix developer documentation generation by @mschoema in #656
• Remove docker action and update dockerfile by @mschoema in #657
• Trigger MobilityDB-docker workflow on push to master by @mschoema in #660
• Implementation of tgeo types by @estebanzimanyi in #661
• Fix: correct PG port configuration in pgversion.yml by @ImreSamu in #663
• Improve implementation and documentation by @estebanzimanyi in #662
• Implementation of the tpose type by @estebanzimanyi in #664
• Implementation of the trgeo type by @estebanzimanyi in #665
• Add traversedArea function for temporal circular buffers by @estebanzimanyi in #666
• Improve interpolation and validity functions by @estebanzimanyi in #667
• Rename directories /general/ -> /temporal/ by @estebanzimanyi in #668
• Improve MEOS examples by @estebanzimanyi in #669
• Improve code and documentation by @estebanzimanyi in #672
• Increase coverage by @estebanzimanyi in #673
• Add Ways cache by @estebanzimanyi in #674
• fix typo by @amwps290 in #676
• Enable DBSCAN clustering in MEOS by @estebanzimanyi in #675
• Improve skiplist infrastructure by @estebanzimanyi in #678
• Remove NDEBUG guard for ensure_span_tbox_type and others by @Diviloper in #682
• Replace macro defining SPATIAL_REF_SYS_CSV with a global variable by @Diviloper in #684
• Fixes timezone cache free by @Diviloper in #687
• Improve MEOS examples by @estebanzimanyi in #688
• Added example for benchmarking tinstant creation by @nhungoc1508 in #689
• Solve Issue #690 by @estebanzimanyi in #691
• Improve performance problems identified by Issue #679 by @estebanzimanyi in #692
• Various minor fixes by @Diviloper in #693
• Header cleanup by @Diviloper in #699
• Fix datum_eq for geography points by @estebanzimanyi in #697
• Improve performance problems identified by Issue #679 by @estebanzimanyi in #695
• Add avgValue function by @estebanzimanyi in #696
• Enable skiplists of key-value pairs by @estebanzimanyi in #685
• Enable Rtree for all bounding boxes by @estebanzimanyi in #686
• Update README.md by @estebanzimanyi in #700
• Upgrade embedded PostGIS code to version 3.6 by @estebanzimanyi in #701
• Improve documentation by @estebanzimanyi in #702
• Improve tcbuffer and documentation by @estebanzimanyi in #703
• Fix rtree by @estebanzimanyi in #708
• Update micro version to 0alpha for 1.3 prerelease by @mschoema in #707

New Contributors

• @ImreSamu made their first contribution in #663
• @amwps290 made their first contribution in #676
• @nhungoc1508 made their first contribution in #689

Full Changelog: https://github.com/MobilityDB/MobilityDB/compare/v1.2.0rc1.....

Release of MobilityDB 1.2.0

Changes w.r.t. v1.2.0rc1

• Do not compile pg_bitutils.c (#610) in #617
• Simplify meos_initialize() (#618) in #622
• Change test timezone from PST8PDT to America/Los_Angeles (#632)
• Create docker image for PG 17 (#635)

First release candidate of MobilityDB 1.2

Major changes w.r.t. MobilityDB 1.1

• Add support for PG 17 and remove support for PG 12
• Update embedded PostGIS code from 3.2 to 3.5
• QoL changes to build and test processes
• Multiple bug fixes
• Performance improvements
• SQL and C API changes
• Fix memory leaks in MEOS
• Add support for pkg-config to the MEOS shared library

New Contributors

• @junderw made their first contribution in #525
• @1-ARIjitS made their first contribution in #552
• @Davichet-e made their first contribution in #546
• @Matematikoi made their first contribution in #563

Full Changelog: v1.1.1...v1.2.0rc1

This release adds support for PG 17 to MobilityDB 1.1 as well as a few bug fixes and QoL changes related to the build and test processes.

Changelog

• Upgrade for pg17 (#510) by @mschoema in #593
• Do not read psql startup file (~/.psqlrc) during tests (#493) by @mschoema in #494
• Configure files in build dir (#590) by @mschoema in #594
• Generate documentation for release branches too by @mschoema in #484
• Use clone_deep in lwhomogenize (patched in postgis 3.4) by @mschoema in #476
• Fix bug in atstbox function (#487) by @mschoema in #489
• Fix tsequenceset_make_gaps for non-exit error handling (#486) by @mschoema in #490

Full Changelog: v1.1.1...v1.1.2

Changelog

• Allow MobilityDB and MEOS to run on ARM64 architecture (by @Diviloper, @mschoema in #461, #463, #465, #469, #472)
• Fix bugs in ever/always spatial relationships (by @estebanzimanyi in #467, #468)
• Fix compilation issues when using Postgres 12 (by @mschoema in #470)

Full Changelog: v1.1.0...v1.1.1

MobilityDB 1.1 Feature Highlights

MobilityDB 1.1 is a major revision with respect to the initial version 1.0.
The most important change in version 1.1 was to extract the core functionality for temporal and spatiotemporal data management from MobilityDB into the Mobility Engine Open Source (MEOS) C library.
In this way, the same functionality provided by MobilityDB in a database environment is available in a C program to be used, for example, in a streaming environment.

To generate the MEOS library it suffices to pass the additional parameter -DMEOS=on to cmake.

Several changes were necessary with respect to MobilityDB version 1.0 to enable the above. An important one was the definition of new data types span and spanset, which provide similar functionality to the PostgreSQL data types range and multirange but can also be used in various programming environments regardless of PostgreSQL. These are template types, which means that they are containers of other types, in a similar way as lists and arrays contains values of other types. Furthermore, a new template data type set was also added. Therefore, the types timestampset, period, and periodset in version 1.0 are replaced by the types tstzset, tstzspan, and tstzspanset in version 1.1.

MobilityDB 1.1 also includes several bugfixes and performance improvements compared to 1.0.
Finally, the API of MEOS and MobilityDB was streamlined to improve usability and to facilitate the other bindings that are currently being developed.

For additional information regarding MobilityDB and MEOS, refer to the pregenerated documentation

This release candidate fixes several bugs detected in release candidate 1.

Main changes w.r.t rc1:

• Several bugfixes
• API changes: use camelCase for all SQL functions and allow calls to atGeometryTime without Z dimension
• Hide postgis and postgres functions in the meos.h library. This allows PyMEOS to be used in QGIS without crashing

First release candidate for MobilityDB 1.1