Photon 1.24: SQL queries for CouchDB

[ermouth]

Hi,

happy to announce Photon 1.24.2, a new version of an alternative CouchDB
admin panel.

Photon now incorporates glynnbird/sqltomango which allows querying CouchDB
using a subset of SQL syntax. The feature is available in the dropdown
where all DB view indices and feeds live.

Features like joins, unions, aliases, virtual tables are not present – they
can’t be implemented using Mango only. Also there are several features that
can be implemented, but still not present, like REGEXP/RLIKE and BETWEEN.
Hope I’ll add them later.

Anyway, for simple requests SQL syntax looks much more concise and handy
than Mango, even in the present state.

Also you can store SQL (and Mango) queries in localStorage of your browser
for later re-use.

https://github.com/ermouth/couch-photon

Enjoy!

Cheers,
ermouth

[ermouth]

> but still not present, like REGEXP/RLIKE and BETWEEN

Since 1.24.11 Photon supports MySQL style REGEXP/RLIKE and ILIKE, as well
as classic LIKE. BETWEEN and NOT BETWEEN are also now supported.

To address questions about /i modifier for RegExps: both in Mango and in
the Photon version of SQL one should start a regex with (?i) to make it
case insensitive. So RLIKE '(?i)^a' (or {$regex:'(?i)^a'} in Mango) matches
both 'a' and 'A'.

https://github.com/ermouth/couch-photon

ermouth

On Tue, Apr 4, 2023 at 12:44 AM ermouth <erm...@gmail.com> wrote:

> Hi,
>
> happy to announce Photon 1.24.2, a new version of an alternative CouchDB
> admin panel.
>
> Photon now incorporates glynnbird/sqltomango which allows querying CouchDB
> using a subset of SQL syntax. The feature is available in the dropdown
> where all DB view indices and feeds live.
>