Category: ProgrammingPage 1 of 2

Why GraphQL uses string based templates for queries?

I’ve followed the graphql development from its public announcement and at first I had my doubts about it, but over time I found the main idea very interesting….

Application architecture and state management with React based web-apps

This is a brief summary of the architectural decisions that I have taken when I have started the development of uxbox and with time I found that the result is…

Get current timestamp with PostgreSQL

I’m pretty sure that almost everyone that have used PostgreSQL knows the now() function. Its purpose is mostly obvious: return the current timestamp or at least its name indicates that….

Best practices storing time data on the database

There is my personal list of best practices handling with time related data and its persistence. I assume they are for PostgreSQL in first time but that recommendations…

Implementing OCC (optimistic concurrency control) on the database

This is a simple tip for implement OCC directly on the database and so avoiding additional overhead that this can imply doing that at the application level. The OCC mechanism mainly consists…

Introduction to Lenses and how to use them instead of cursors

The cursors abstraction is so far the most used approach for delimit the vision of the global state for react components in ClojureScript applications. But that also has…

Promises and Clojure(Script)

When I start developing in ClojureScript one year ago, core.async was ( and surelly continues to be) the most adopted library for work with asynchronous code. It is not very…

Generate a CSR using OpenSSL cli

This is a little cheat sheet for personal use on how generate a secure certificate request using openssl. The first step is creating a strong private key. At…

Auto currying experiment with Clojure

Currying, is one of the much others featues that haskell implements nativelly but is not widelly extended on lisp like languages. But thanks to the power of lisp,…

Optimizing server for heavy load WSGI application

Many times, we only care to optimize the database, nginx or WSGI server, and often is more than enough. But, when you have a web application that must…