We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Simple SQL Change Management with Sqitch

00:00

Formal Metadata

Title
Simple SQL Change Management with Sqitch
Title of Series
Number of Parts
20
Author
Contributors
License
CC Attribution - NonCommercial - ShareAlike 3.0 Unported:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal and non-commercial purpose as long as the work is attributed to the author in the manner specified by the author or licensor and the work or content is shared also in adapted form only under the conditions of this
Identifiers
Publisher
Release Date
Language
Producer

Content Metadata

Subject Area
Genre
Abstract
SQL change management has always sucked. This talk introduces Sqitch, the VCS-aware SQL change management application that doesn't suck. Come see how it works, learn the few simple rules you need to get the most out of it, and liberate yourself from the suckitude. SQL change management is hard. Most "migration"-style implementations require opaque naming conventions, prefer DSLs that cover a fraction of SQL, and require duplication of code for simple changes to existing functions. Such does not have to be. And now it's not Introducing Sqitch, simple SQL change management that doesn't suck. Sqitch doesn't care what programming language your app is written in. It has no opinions as to what database to use or what its schema should look like. And it doesn't require sequentially-named migration scripts or the use of any DSL other than SQL. Sqitch lets you to write SQL migration scripts thar target your database, and provides a simple, unintrusive interface for specifying dependencies, so that it can run things in the proper order. Best of all, when used with a version control system (initially Git), you can even modify idempotent deployment scripts between releases. Sqitch recognizes such changes, and automatically knows how to revert to earlier versions if required. And finally, Sqitch supports simple acceptance testing, so that you can be sure that your deployments are successful, and, if not, revert them. So come to this talk to learn all about Sqitch: How it works, where to get it, and how to get the most out of managing database deployments.
VideoconferencingMetropolitan area networkHuman migrationLogicDisintegrationScripting languageWikiHuman migrationNumerical analysisScripting languageQuicksortInterface (computing)Replication (computing)Context awarenessPhysical systemMathematicsSoftware developerData managementSubsetProcedural programmingDatabaseEndliche ModelltheorieProgramming languageLogicINTEGRALWeb pageTimestampSequelPoint (geometry)Disk read-and-write headXMLUML
MathematicsPrice indexElectronic data interchangeScripting languageFunction (mathematics)Computer fileCodeReal numberData managementMetropolitan area networkDifferenz <Mathematik>MathematicsEntire functionLine (geometry)Human migrationProcedural programmingCodeScripting languageExistenceCASE <Informatik>Revision controlPhysical systemComputer fileWritingMultiplication signSource codeFunctional (mathematics)Problemorientierte ProgrammierspracheDatabaseSource codeComputer animation
Independence (probability theory)DisintegrationImage resolutionDistribution (mathematics)Interface (computing)Executive information systemSoftware testingDatabaseProcedural programmingProjective planeScripting languagePhysical systemSoftware testingPatch (Unix)System callData miningSoftware developerConfiguration spaceFunctional (mathematics)Image resolutionLine (geometry)Function (mathematics)Electronic mailing listINTEGRALPlanningRevision controlMathematicsComputer fileWritingCartesian coordinate systemImplementationBitComputing platformInterface (computing)Data managementCore dumpTrailRight angleDistribution (mathematics)Order (biology)Exception handlingSingle-precision floating-point formatArmNumerical analysisFiber bundleAlpha (investment)MultilaterationCodePoint (geometry)ExistenceNumbering schemeStapeldateiField (computer science)Reverse engineeringData structureFood energyFrequencyFlow separationSequelHacker (term)Process (computing)Social classConnectivity (graph theory)Polar coordinate systemReduction of orderMultiplication signWave packetQuicksortComputer animation
Repository (publishing)Touch typingSoftware development kitSoftware testingConfiguration spaceProjective planeDirectory serviceWritingSoftware testingReverse engineeringComputer fileScripting languageSoftwareRepository (publishing)
Core dumpBinary fileClient (computing)Set theoryCore dumpUniform resource locatorDatabaseReverse engineeringDefault (computer science)Computer configurationExtension (kinesiology)Scripting languageDirectory servicePartial differential equationLine (geometry)Latent heatComputer fileConfiguration spaceInformationQuicksortLevel (video gaming)Point (geometry)Projective planeDirection (geometry)MathematicsClient (computing)Physical systemComputer animation
Metropolitan area networkBinary fileClient (computing)Total S.A.Asynchronous Transfer ModeComputer fileSoftware testingConfiguration spaceSoftware developerSet theorySpeech synthesisPhysical systemDirectory serviceProcess (computing)MathematicsComputer fileMultiplication signScripting languageSoftware testingPoint (geometry)2 (number)Computer animation
Software testingPole (complex analysis)Electronic mailing listAttribute grammarScripting languageCartesian coordinate systemTemplate (C++)Directory serviceDefault (computer science)Free variables and bound variablesDatabase transactionProgramming languagePlanningHuman migrationComputer configurationArithmetic meanSoftware testingDisk read-and-write headAdditionDatabaseMobile appSocial classTriangleComputer animation
Software testingPole (complex analysis)Electronic mailing listAttribute grammarDatabaseRight anglePoint (geometry)Dimensional analysisMetadataMathematicsTrail
MathematicsSoftware testingType theoryMobile appSign (mathematics)Product (business)Shooting methodSoftwareDisk read-and-write head
MathematicsSoftware testingLogarithmPole (complex analysis)ASCIIElectronic mailing listAttribute grammarRow (database)Type theoryMathematicsDatabaseComputer animation
Mathematical singularityComputer fileAsynchronous Transfer ModeSoftware testingPole (complex analysis)Electronic mailing listAttribute grammarDefault (computer science)Multiplication signMathematicsMereologyINTEGRALTrailChainRight angleTimestampComputer animation
Computer fileSoftware testingCore dumpRing (mathematics)Curve fittingDatabaseSoftware testingCore dumpType theoryInformationComputer fileProduct (business)Projective planeConfiguration spaceMultiplication signRevision controlSoftware developerIterationRoundness (object)Fluid staticsAbstractionMobile appScripting languageComputer animation
Metropolitan area networkReal numberSoftware testingIcosahedronASCIISubject indexingKey (cryptography)Data typeTable (information)Line (geometry)Programming languageTemplate (C++)MultiplicationElectronic mailing listGoodness of fitScripting languageTable (information)Repository (publishing)Disk read-and-write headPlanningDatabaseTrailComputer animation
Software testingTable (information)Computer fileAsynchronous Transfer ModeRevision controlDatabaseDisk read-and-write headPhysical systemArithmetic meanComputer configurationData managementInformationElectronic mailing listPlanningBitAdditionMultiplication signDifferent (Kate Ryan album)Source code
MathematicsSoftware testingMobile appProcedural programmingMessage passingOrder (biology)MathematicsNumerical analysisFunctional (mathematics)Multiplication signDatabasePasswordStandard deviationStability theoryRight angleWater vaporSource code
PasswordMetropolitan area networkLine (geometry)Electronic mailing listFunctional (mathematics)Table (information)PasswordMobile appInsertion lossHash functionSource code
Software testingMathematicsMountain passPasswordSet theoryOvalData typeElectronic mailing listFunction (mathematics)MathematicsMessage passingMathematical analysisFunctional (mathematics)PasswordMereologyCommunications protocolDesign by contractDatabaseDisk read-and-write headPattern languageSoftware developerMultiplication signComputer animationSource codeLecture/Conference
Level (video gaming)MathematicsHand fanDatabaseResultantSoftware testingElectronic mailing listPoint (geometry)State of matterComputer animation
Distribution (mathematics)Metropolitan area networkMathematicsScripting languageDirectory serviceDistribution (mathematics)Integrated development environmentPhysical systemPlanningOperator (mathematics)Fiber bundleMultiplication signWordComputer animation
MathematicsHost Identity ProtocolPlanningConfiguration spaceRepository (publishing)Directory serviceFiber bundleSet theoryCommitment scheme1 (number)Multiplication signInstance (computer science)Computer fileRight angle
Metropolitan area networkDuality (mathematics)Mountain passMathematicsEuler anglesScripting languageDependent and independent variablesLogic gateSoftware testingDirectory servicePlotterComputer fileFigurate numberFiber bundlePoisson-KlammerConfiguration spaceLevel (video gaming)DatabaseMathematicsComputer animationLecture/ConferenceSource code
Mountain passMathematicsPasswordSoftware testingDatabaseState of matterGoodness of fitSoftware testingPasswordHash functionComputer animation
CryptographyComputer fileMathematicsSoftware testingCryptographyComputer fileRight angleScripting languageExtension (kinesiology)PasswordMathematicsMessage passingData storage deviceFunctional (mathematics)Procedural programmingPoint (geometry)Computer animation
Price indexPasswordMetropolitan area networkScripting languageIdempotentMathematicsFunction (mathematics)Computer fileFunctional (mathematics)Social classMathematicsArithmetic meanMultiplication signScripting languageRight angleWordIdempotentElectronic signatureRoundness (object)Source codeComputer animation
PasswordSet theoryMountain passMassSoftware testingMathematicsMathematicsFunctional (mathematics)PasswordCryptographyPlanningTrailComputer animation
Software testingMathematicsPort scannerPasswordData acquisitionMathematicsMultiplication signHash functionComputer filePoint (geometry)Connected spacePasswordCode
MathematicsMountain passRight angleComputer fileRevision controlMultiplication signPoint (geometry)Reading (process)Distribution (mathematics)CASE <Informatik>Form (programming)Fiber bundleMathematics
Storage area networkMathematicsMountain passMetropolitan area networkLogarithmSoftware testingSet theoryDisintegrationData managementExecutive information systemWorld Wide Web ConsortiumRankingDistribution (mathematics)PlanningLevel (video gaming)Integrated development environmentBuildingHuman migrationSoftware testingQuicksortProduct (business)INTEGRALDefault (computer science)Computer fileDecision theoryNumerical analysisArithmetic progressionPoint (geometry)MathematicsBitMultiplication signRight angleDatabaseExtension (kinesiology)InjektivitätOnline helpTap (transformer)ArmWritingProjective planeTable (information)Independence (probability theory)Data managementWebsiteCodeScripting languageCore dumpFreewareProgramming languageTask (computing)Mathematical analysisLinear regressionRevision controlPattern languageCentralizer and normalizerInsertion lossFunktionalintegralNatural numberFunction (mathematics)Observational studyOcean currentDegree (graph theory)Electronic data interchangeComputer animation
Metropolitan area networkData managementMathematicsFile Transfer ProtocolSoftware developerBranch (computer science)Validity (statistics)BitSheaf (mathematics)Point (geometry)Right angleSoftware testingHybrid computerCollisionScripting languageServer (computing)Revision controlControl systemHuman migrationDifferent (Kate Ryan album)Core dumpCommunications protocolSequelProjective planePlanningWebsitePhysical systemRepository (publishing)Computer fileLevel (video gaming)Table (information)Social classINTEGRALDatabaseProgramming languageVirtualizationDirectory serviceMereologyVector potentialIterationLine (geometry)Bridging (networking)View (database)MassData storage deviceProduct (business)Computer animation
Metropolitan area networkData managementHaar measureMathematicsRight angleData managementDatabaseCore dumpRollback (data management)Programming languageScripting languagePhase transitionLatent heatGoodness of fitQuicksortSoftware testingIntegrated development environmentCartesian coordinate systemEntire functionComputer fileGame controllerMathematicsTable (information)Level (video gaming)Process (computing)Numerical analysisFiber bundleTrailHTTP cookieElectric generatorDifferenz <Mathematik>Confidence intervalPatch (Unix)Branch (computer science)Context awarenessFlow separationDifferent (Kate Ryan album)Library catalogMereologyProduct (business)Data conversionSynchronizationMoving averageSubsetRepository (publishing)Projective planeObject (grammar)Noise (electronics)Software developerPhysical systemOrder (biology)GradientWeb pageGamma functionSequelWordEndliche ModelltheorieLibrary (computing)Medical imagingSet theoryParameter (computer programming)Electronic mailing listTask (computing)Web 2.0Game theoryAreaGraph (mathematics)Extension (kinesiology)Computer animation
Transcript: English(auto-generated)