Tag: SQL

Poor man’s full text search for SuiteCRM

The poor man's CRM, a.k.a SuiteCRM, is great (... was great for its time!); that's…

Full-text search using PostgreSQL: simple, fast, cached

Let's find out what can we achieve; using what we already have, without adding other…

Managing date fields properly with correct time zones in PostgreSQL

In apps for users all around the world (even in apps for local users where…

Postgresql and Node.js 100% Javascript Adventure – Part 2

This is the second part of PostgreSQL, Node.js and JavaScript post. We can continue by…

PostgreSQL and Node.js – 100% JavaScript Adventure

This is a log of every step I will take to create a 100%-JavaScript application…

Recursive Relationships in Databases

One of the tricky issues in entity relationship model is the recursive relationships. Sometimes an…

Adaptable Database Design

I had an opportunity to work on a Magento implementation and checked its database. I…

Creating a CV indexing facility using Oracle Text

Recently, I have struggled to get Oracle Text working on Linux. It was supposed to…

Emergency check on command-line for Oracle XE

Go to your Oracle binaries folder and export environment variables, if they are not set…

Show MS Access Subreports With No Data

On MS Access applications, usually I use subreport objects with SQL queries of their own,…