Some months ago, have been asked about how to generate a search result ordered by distance, without using spatial DB predicated.
For a situation such as this, the steps are the following:
Store the latitude and longitude in numeric fields in the table, something like this: create table poi(id int auto_increment primary key, name varchar(64), lat float, lon float);
Create the indexes (this is important, other) create index idx_poi_lat on poi(lat); create index idx_poi_lon on poi(lon);
This drink offers a fresh start, featuring a good harmony of vanilla , citrus and berry notes. Leads to a pleasant drinking experience, easy flow and decently calibrated sweetness. However, the ending is too dry leaving an acrid aftertaste with unpleasant aspartame notes.
Veredict: 3.5/5
Type: Taurine/Caffeine (0.4/0.03 mg), sugar free.
Best drinked: Early morning outdoors, on a trip or driving
Recommended drinking time: 20-30 minutes
Country: United Kingdom
[disclaimer: This is a totally subjective review.
After using Wordpress to host this blog, I stumbled upon Ghost. This new blogging platform has clean design and simple editor with Markdown support. Built in Node instead of the usual PHP, is also more sexy these days.
After migrating and configuring static pages, I wanted to migrate from SQLite to PostgreSQL. Not a straight task, but is working. Leave here the instructions for who may need it.
0 create a database
A sweet vanila-powered drink of fast sugar-induced rush, must be drinked cold. Absense of citric aroma, but generous sugar content mildly tempered with shy herbal notes. The afterstaste is not impressive, but scales down well. Very faithful to the Polish tradition of energy drinks, but clearly not the top nectar. (Note: the references to ““Mike Tyson”” and ““The original premium black”” might, by some, be considered bad taste in copywriting)