Note: these pages are no longer maintainedNever the less, much of the information is still relevant.
Beware, however, that some of the command syntax is from older versions, and thus may no longer work as expected.
Also: external links, from external sources, inside these pages may no longer function.
a fast and simple practical how-to for absolute beginners
Introduction / Table of Contents
|2011 January 28|
in Computing there are two ill-fated words: database and SQL.
Both terms share a long-established and deeply consolidated bad reputation:
simply pronouncing their name will immediately cause strong negative reactions:
"too much complicated", "I'll never be able to understand all this", "nerds oddities" and so on ...
If all this is indisputably true for plain basic SQL, what's about the most exotic Spatial SQL ?
Obviously, this sounds by far much more complex and intimidating:
for sure only very few specially trained and highly qualified gurus can cope with Spatial SQL, isn't ?
Forget all this, and be open-minded !
For many years the DB market was dominated by highly-priced proprietary software:
and the Spatial DB simply represented a narrowest specialized segment (even more exaggeratedly expensive) within mainstream DB market.
So the intimidating sacral aura surrounding DB technologies was much more a cover-up story to justify abnormally high prices than an objective technical fact.
Happily the actual truth is quite different from this: any normally computer-skilled professional people can easily learn and successfully use both SQL and Spatial SQL;
there is absolutely nothing difficult, obscure or much more complex in using them.
And when I say professional people I don't necessarily intend developers, computer engineers or GIS professionals:
I'm personally well aware that lots of ecologists, traffic engineers, botanicians, environmental engineers, zoologists, public administration officers, geologists, geographers, archeologists (and many others) successfully use Spatial SQL on their daily activities.
So you can now get a sophisticated, standard and really effective Spatial DB absolutely for free and in the easiest and painless way.
And that's not all: SpatiaLite is strongly integrated into the open source ecosystem.
So you can immediately connect any SpatiaLite's DB using e.g. QGIS (a well known and widespread desktop GIS app).
How this tutorial is structured: think of some Cookbook.
At first you are expected to simply acquire some limited and basic
For many people this is their best effort: that's enough for them, and they'll quit at this point.
But many other will probably discover that after all cooking is funny and really interesting: so they'll surely ask for something much more sophisticated.
Any good cookbook will certainly end introducing several complex haute cuisine recipes.
May well be you'll never become a real chef de cuisine, but you will amuse yourself anyway, and feel proud of your cooking skills.
|Author: Alessandro Furieri email@example.com|
|This work is licensed under the Attribution-ShareAlike 3.0 Unported (CC BY-SA 3.0) license.|
Permission is granted to copy, distribute and/or modify this document under the terms of the
GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation;
with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts.