This is the PostgreSQL backend for RegexPlanet, a tool for online regular expression testing.
See API docs for what it is supposed to do.
See PostgreSQL online regex test page to use it to test your regular expressions.
Run with the environment variable DATABASE_URL pointing to a PostgreSQL database setup as described below. This will look like DATABASE_URL=pg://regex_user:secret@localhost:5432/regex.
CREATE ROLE regex_user LOGIN NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
CREATE DATABASE regex
WITH OWNER = postgres
ENCODING = 'UTF8'
TABLESPACE = pg_default
LC_COLLATE = 'en_US.UTF-8'
LC_CTYPE = 'en_US.UTF-8'
CONNECTION LIMIT = -1;
GRANT CONNECT, TEMPORARY ON DATABASE regex TO public;
GRANT ALL ON DATABASE regex TO postgres;
GRANT ALL ON DATABASE regex TO regex_user;
ALTER ROLE regex_user PASSWORD 'secret';
DROP TABLE IF EXISTS template;
CREATE TABLE public.template
(
id INTEGER NOT NULL,
input VARCHAR(255) NOT NULL,
regex VARCHAR(255) NOT NULL,
replacement VARCHAR(255),
CONSTRAINT template_pkey PRIMARY KEY (id)
)
WITH (
OIDS=FALSE
);
--ALTER TABLE public.template OWNER TO regex_user;
- support for (option flags)[https://www.postgresql.org/docs/current/static/functions-matching.html#POSIX-EMBEDDED-OPTIONS-TABLE]
- support for regex_matches (returns an array which needs
UNNEST(), and skips rows if no matches) - pass in port via env var
- Elastic Beanstalk
- logging