Use SimpleSQL from Github pages

SimpleSQL is an HTTP API that allow complete control over a SQLite database. Underneath SimpleSQL is based on RediSQL to manage all the different databases, connections, backups, replication, etc. One of the most compelling use case is to SimpleSQL to create completely static webpages that can operate against one database. This would allow to create very powerful webapp that don’t need a server backend. A common way to host a simple web app, is to use Github pages, which offer a free space for open source projects. In order to use SimpleSQL you need to allow the browser to make CORS requests against simplesql.redbeardlab.com. Doing so allow the browser to make HTTP requests against the simplesql.redbeardlab.com domain. Fortunately github pages already allow it, so no step is necessary for the CORS. SimpleSQL provide also a JS SDK, which makes writing application simpler. In order to use the SDK is sufficient…

Continue Reading Use SimpleSQL from Github pages

Invariants as interface

An invariant is a condition that holds true no matter what during the execution of a phase of a computer program. For instance, in a classical for loop, for (i…

Software is a FOCUS intensive industry.

Industries are usually characterized as labor-intensive or as capital-intensive. Labor-intensive industries requires a lot of human input in order to produce their output. A classical examples is the industry of…

Tracking the trackers. The beginning.

This project wants to explore how the web is tracked by whom. As the most tech savvy readers know, when we visit a web page, several things happen in the…

Rust and glibc version.

Rust is an amazing language, with amazing community and tooling. However, sometimes, you can end up in complex situation where the standard tools are not sufficient anymore, in those case…

Write a Postgres proxy. Day 1.

In this series of post we are writing a postgres proxy that accept connections made using the postgres (PG) protocol and forward them to RediSQL. Motivation and introduction of the…

Write a Postgresql proxy. The Beginning.

This series of articles will follow my progress in creating a RediSQL proxy for Postgres, pg-redis-proxy. The end goal of this project is to have a proxy that will listen…