Want to learn how to do something in Rails? Make a howto link and those in the know will try to accommodate it. Try to name it like HowtoX.
Fundamental Database HOWTO’s
- HowToEnforeMultiColumnUniqueness
- HowToGetRecords(QueryTable) (Unanswered)
- HowtoSelectRandomRecords
- HowtoQueryTheDatabaseDirectly
- HowToUseLegacySchemas
- HowToAliasColumnNames
- HowToUseTimestampColumns (partial answer)
- HowToUseALookUpTable (Unanswered)
- HowtoUpdateAllWithMultipleTables
- HowToUseMigrations
- HowToUseNonIncrementingPrimaryKey (Unanswered)
- HowtoUseJoinsWithFindAll
- HowtoUseBooleanColumns
- HowtoHandleStatementInvalid
- HowToUseTransactions
- HowToUseManyToManyAgainstASingleTable
- HowToUseNonDatabaseProvidedIDs
MySQL
PostgreSQL
SQLite
MsSql
- HowtoConnectToMicrosoftSQLServer
- HowtoConnectToMicrosoftSQLServerFromRailsOnLinux
- HowtoConnectToMicrosoftSQLServerFromRailsOnDebian
- HowtoConnectToMicrosoftSQLServerFromRailsOnOSX
- HowtoConnectToMicrosoftSQLServerFromRailsOnFreeBSD
Oracle
- HowtoConnectToOracle
- HowToUseOracleWithFastCGI
- HowToRailScotTiger (unanswered)
- HowToOracleStoredProcedures
Sybase
- Information Missing.
IBM DB2
- Information Missing.
Informix
Multiple Databases
- HowtoUseMultipleDatabases
- HowtoSwitchBetweenMultipleDevelopmentDatabases
- HowtoUseMultipleDatabasesOnePerTable
- HowtoUseMultipleDatabasesWithFixtures
- HowtoCreateAndDeleteDatabases?
Database Drivers
- DatabaseDrivers – Databases you can use with Rails and how to add support for more
Database Reporting Tools
MagicFieldNames
More HOWTO’s
- HowToMimickAfterTriggers
- HowToImplementADeepCopy
- HowtoGenerateMultipleAndOrSanitizedQueryConditions
- HowtoUseAccessAttributesOnRelationTables?
- HowtoUseStoredProceduresAsTables
- HowToWriteAnActiveRecordAdapter
- HowtoUseSingleTableInheritance? (Unanswered)
category:Howto