Opened 10 years ago

Closed 10 years ago

#4782 closed enhancement (fixed)

[PATCH] Add a 'SQLite' dialect

Reported by: Even Rouault Owned by: Even Rouault
Priority: normal Milestone: 1.10.0
Component: OGR_SF Version: unspecified
Severity: normal Keywords:
Cc:

Description

This patch adds a 'SQLite' dialect, alternate to the OGRSQL default dialect, that uses the SQLite engine (when available), potentially with Spatialite extensions. This is usable for any OGR datasource.

Attachments (1)

sqlite_dialect.patch (82.0 KB ) - added by Even Rouault 10 years ago.

Download all attachments as: .zip

Change History (9)

by Even Rouault, 10 years ago

Attachment: sqlite_dialect.patch added

comment:1 by Even Rouault, 10 years ago

Core stuff committed in r24813 :"ogr/ogrsf_frmts/generic/ ogr/ogrsf_frmts/sqlite/ ../autotest/ogr/ogr_sql_sqlite.py -m "OGR: Add a 'SQLite' dialect for SQL queries submitted to ExecuteSQL() (#4782)""

Documentation still needed

comment:2 by Even Rouault, 10 years ago

r24814: SQLite dialect: fix compilation problem with ancien sqlite lib (#4782)

comment:3 by Even Rouault, 10 years ago

r24819 : Make VirtualOGR a loadable sqlite3 extension when SELECT load_extension("libgdal.so"); (#4782)

comment:4 by Even Rouault, 10 years ago

r24824 : SQLite: fix Windows build with amalgamation sqlite and make VirtualOGR extension dynamic loading actually work on Windows (#4782)

comment:5 by Even Rouault, 10 years ago

r24828: VirtualOGR: make all result string/blob TRANSIENT to avoid memory issues when rows are collated

r24830 : SQLite dialect: allow refering layers from other datasources with the same syntax as in OGR SQL

comment:6 by Even Rouault, 10 years ago

r24831: Re-apply r24828 that was lost due to a merge issue

comment:7 by Even Rouault, 10 years ago

r24833: SQLite dialect: add support for OFTDateTime/OFTDate/OFTTime

r24837: SQLite dialect: less false positive detection of layer names

r24838: SQLite dialect: add documentation

comment:8 by Even Rouault, 10 years ago

Resolution: fixed
Status: newclosed

There have been later commits. But everything required is in place. Closing

Note: See TracTickets for help on using tickets.