Related & Interesting External Documents

• SQL
  • Information about SQL (Wikipedia)
  • SQL Specifications - useful for works on KexiDB, etc.
  •  Description of SQL:2003 standard
  • Comparison of different SQL implementations
  • INFORMATION_SCHEMA - a "virtual" daabase providing database's metadata - a possible way for Kexi to deal with native databases; PostgreSQL 8.0+, MySQL 5.0.2+
  • SQL recipes - resource for finding answers to common (and not so common) SQL queries for many SQL servers.
  •  The many-to-many revolution - Advanced dimensional modeling - provided by this Kexi wish
• SQLite
  • Sqlite Competitors - comparisons between SQLite and other database engines.
  • Akonadi::DataStore Class Reference, KDEPIM's file-based storage
• MS Access
  • The Access Web - FAQ site designed to help Microsoft Access developers, maybe this could help Kexi developers avoid some mistakes?
  •  Migrating from Microsoft Access to the MySQL database - By Paul Dubios
  • MS Access Tips & Tricks - many useful MS Access-related information (and some ugly patches that show what are typical users' troubles) (in polish)
  • Allen Browne's tips for Microsoft Access. Brief tutorials and help for beginners and database developers. Examples and solutions to implement. Bugs and traps to avoid. Sample code and utilities.
  • Short MSA Flash Tutorials from DataPig technologies - useful if you just want to realize what's up with a given MSA feature...
  • MSO Dev Center: Access
    • Access Reference Documentation (downloadable)
    • Developing Smart Tags with MSA (see also more generic description of Semantic links / Microformats)
  • A discussion of what's new in Access 12. Is MSA awake after 7 years?
  • MSA archives of databasejournal.com
  • MSA MVPs
  • More recent shots of MSA 12 (beta 1)
  • MSA's Better Navigation in Less Space - these hints are compatible with original TODOs for Kexi Project Navigator...
  • MSA 2007 Highlights, includes flash demo preview and guide document.
  • Posts about Access 2007 (MSDN)
  • Sample Data Models for Relational Database Design
  • Useful MSA links
  • Reverse Engineering an Access Database in MS Visio - Kexi can be even easier rev-engineered since there's rich db schema easily available; We can think about usign ODF as a format and Kivio as a viewer (other document on the topic)
  • Access-Freak - a website dealing with an introduction to new features added in MSA 2007 and a comparison between MSA 2003 and 2007.
•  Data Access with Linux - interesting document
• Apple WEBObjects Documentation - a possible source of in-depth knowledge how to design WEB-enabled database structure. Kexi has some similar design principles...
• Apple Remote Desktop "Providing Application Access to SQL Data in Apple Remote Desktop 2" Using a PostgreSQL database to store system configuration information for desktop management.
• FoxPro Wiki
• UIML - a proposal of open standard user interface description language in XML, from OASIS; a converter from Kexi's forms XML format to this may be an idea, but we're not sure yet
• Oracle docs online (registration required)
• Fast, Easy Database Access with Python
• Database formats documentation valuable for writing Kexi import/export plugins
• Information about Imaging Metadata and Standards
• Draft 22: Open Document 1.0 Format for Office Applications - expecially look at sections 6.x: Database Fields and 11.x: Form Content - this is something Kexi probably will need to play with in the future.
• 'Gotchas' in MySQL and Postgres
• Explanation of Database File Systems
• Open Source Database Feature Comparison Matrix
• Comparison: PostgreSQL vs. MySQL
• OpenDocument, OpenOffice.org Base And Related
  • OpenDocument Format for Office Applications v1.0
  • OpenOffice.org Database Access - Specifications (older page)
    • KDE Address Book Access
  • Andrew Pitonyak's Documents on Database access using OpenOffice.org - very good source of information including StarBasic scripting
  • Database Access chapter of StarOffice 8 Programming Guide for BASIC - interesting point of view, code samples, references to MS DAO in terms of API (Kexi/KexiDB developer docs could contain something similar)
  • MSA-OO.org Base FAQ - insteresting list of features supported and not supported by OO.org Base
• MSDN Windows GUI Guide - Dialog Boxes
• Introduction to the Zope Object Database
•  To BLOB or Not To BLOB: Large Object Storage in a Database or a Filesystem? (MS Research)
•  Strigi - searching files in KDE4 - aKademy 2006 slides
• Library of Free Data Models from DatabaseAnswers.org
•  Query-by-Example (QBE)

Wikipedia's Resources

• Multidimensional Database

Recommended Books

• Database Design for Mere Mortals - implementation-independent look at database design art