Child pages
  • Database

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

Supported Databases

  • Microsoft SQL Server
  • PostgreSQL (w/ PostGIS)
  • MySQL (in-progress)

Development

BigSense does not use a Database Abstraction Object (DAO) layer. Instead, each database backend has its own custom data definition files and a command file for SQL queries.

Info

SQL Queries: https://github.com/sumdog/BigSense/tree/master/src/io/bigsense/db

DDL: https://github.com/sumdog/BigSense/tree/master/ddl

Entity Relationship Diagram*

 

*MySQL Version. Data types may vary for other backends.