Tags » PostgreSQL

Airspace is complicated -- and so I abuse PostGIS once again

Let’s ignore for a moment the drone hobbiest / enthusiast. What is the shape of airspace for airplanes and commercial and government unmanned aircraft flying under Certificates of Authorization, and how can we visualize it? 606 more words


Bye Bye... SQL, Hello! NoSQL

Voltando no tempo, estamos em 1998, ano em que surgiu o NoSQL, que veio romper o reinado do SQL (bases de dados com o modelo relacional). 352 more words

Base De Dados

Midway and Gradueen

At the end of the week, I’ll have completed the first half of my 12-week bootcamp at Makers.

During these first six weeks I learned how to create a web app in Ruby language, test it with RSpec, Cucumber and Capybara and put it on the web with Sinatra and Heroku. 226 more words

Creating a subset of a table as a function

In this post we are going to make a function that returns a subset of an existing table.

The function is written in SQL and it will receive a polygon in binary form WKB. 101 more words


Experienced Freelance Programmer

experienced freelance programmer

with vb.net, asp.net, javascript, html, css, bootstrap, python, java and android.

connect with database microsoft sql server, mysql, sqlite, postgresql, microsoft access. 49 more words


Creating A New User & Database for Metasploit


Yes, you saw the title, in this tutorial we are gonna create a new user & database for metasploit and connect it inside the msfconsole. 348 more words


Rails 3 or Rails 4, ActiveRecord, PostgreSQL, and PG::NotNullViolation: ERROR: null value in column "id" violates not-null constraint

PG::NotNullViolation: ERROR:  null value in column "id" violates not-null constraint

If you see this error in your logs for your newly-hosted app, whether on Heroku or Amazon AWS, and you’ve just recently moved to PostgreSQL from MySQL, here’s what’s happening. 316 more words