sqlite3-ruby provides an interface for the SQLite DB engine version 3.
This differs from the DBD::SQLite module in that it is more complete,
and from the ruby DBI version of SQLite in that it is SQLite specific,
so you can do things that would otherwise be more difficult via DBI.
If you want portability between backends, use DBI. If you want ease
of use with SQLite, use this.
sqlite3-ruby provides an interface for the SQLite DB engine version 3.
This differs from the DBD::SQLite module in that it is more complete,
and from the ruby DBI version of SQLite in that it is SQLite specific,
so you can do things that would otherwise be more difficult via DBI.
If you want portability between backends, use DBI. If you want ease
of use with SQLite, use this.
The StateMachines ActiveModel integration is useful for both standalone usage
and for providing the base implementation for ORMs which implement the
ActiveModel API. This integration adds support for validation errors and dirty
attribute tracking.
The StateMachines Active Record 4.1+ integration adds support for database
transactions, automatically saving the record, named scopes, validation errors.
Its ruby client for Tarantool Key-Value Storage
Xapian is an Open Source Probabilistic Information Retrieval library,
released under the GPL. It's written in C++, with bindings to allow use
from other languages.
Xapian is designed to be a highly adaptable toolkit to allow developers to
easily add advanced indexing and search facilities to their own
applications.
Xapian features include:
- Ranked probabilistic search - word importance weighting
- Relevance feedback
- Phrase and proximity searching
- Full range of structured boolean search operators
- Term stemming
- Database files > 2GB
- Platform independent data formats
- Allows simultaneous update and searching.
Sharedance is a high-performance server that centralize ephemeral
key/data pairs on remote hosts, without the overhead and the
complexity of an SQL database.
This is a package of tools from Skype for replication and
failover. Also it includes a generic queuing mechanism PgQ and
utility library for Python scripts.
spatialite-tools is a collection of open source Command Line Interface (CLI)
tools supporting SpatiaLite.
* spatialite: a complete CLI front-end, more or less equivalent to the well
known sqlite3 front-end, but fully supporting SpatiaLite
* spatialite_tool: a tool supporting import/export of Shapefiles and DBF-files
* shp_doctor: a diagnostic tool to check anomalous shapefiles
* exif_loader: an import tool for EXIF or EXIF-GPS (JPEG) pictures
* spatialite_network: a tool creating a VirtualNetwork (supporting
shortest path / routing SQL queries)
* spatialite_gml: a tool importing GML files
* spatialite_convert: a tool converting DB-files from different versions
of SpatiaLite
* spatialite_dxf: an tool importing DXF files
* OSM-tools: spatialite_osm_raw, spatialite_osm_filter, spatialite_osm_map,
spatialite_osm_net, spatialite_osm_overpass: tools supporting
OpenStreetMap datasets
* XML-tools: spatialite_xml_load, spatialite_xml_collapse,
spatialite_xml_print, spatialite_xml_validator: tools supporting XML files
processing
SpatiaLite is just a small sized SQLite extension. Once you have installed
SpatiaLite (a very simple and elementary task), the SQLite DBMS is enable to
load, store and manipulate Spatial Data (aka GeographicData, GIS Data,
Cartographic Data, GeoSpatial Data, Geometry Data and alike). SpatiaLite
implements spatial extensions following the specification of the Open
Geospatial Consortium (OGC).