spatialite

NoSQL and spatial data

by

graphs databases like Neo4j are a very good fit, especially as you can add different indexing schemes dynamically as you go. Typical stuff you can do on your base data is of course 1D indexing (e.g. Timline or B-Trees) or funkier stuff like Hilbert Curves etc, see Nick’s blog. Also, for some live demonstration, look … Read more

How to open .SQLite files

by

If you just want to see what’s in the database without installing anything extra, you might already have SQLite CLI on your system. To check, open a command prompt and try: sqlite3 database.sqlite Replace database.sqlite with your database file. Then, if the database is small enough, you can view the entire contents with: sqlite> .dump … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)