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

Don't Do This

00:00
subtitles
off
playback rate
1
quality
720p
subtitles
off
English (auto-generated)
playback rate
0.25
0.5
0.75
1
1.25
1.5
1.75
2
quality
720p
480p
360p
240p
6
 Cite
 Share
 Related Material
 Download Purchase
Logo of FOSDEM VZWFOSDEM VZW
 Angelakos, Jimmy

Formal Metadata

Title
Don't Do This
Title of Series
Number of Parts
542
Author
License
CC Attribution 2.0 Belgium:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language

Content Metadata

Subject Area
Genre
Abstract
Based on the legendary "Don't Do This" PostgreSQL wiki page, this talk will explore some of the common pitfalls and misconceptions that Postgres users can face - and show possible ways to undo them or workarounds. Some of the topics to be covered: - Correct types for data storage - (Sub-)Partitioning -- And how to get it wrong - Bad SQL habits - Table inheritance -- And how to undo it - Security issues -- Unsafe configurations and usage - Connections -- Number of, and properly handling
00:00
Content (media)WikiDiagramComputer animation
01:01
Limit of a functionType theoryInformation securityLogical constantTimestampSummierbarkeitDatabase transactionReal numberTimestampResultantStandard deviationSelectivity (electronic)Extension (kinesiology)Data typeDatabaseIntegrated development environmentTable (information)Lattice (order)Server (computing)IdentifiabilityLimit of a functionMatching (graph theory)CASE <Informatik>Database transactionQuery languageSummierbarkeitRow (database)MereologySubsetBitHash functionInformation securityComputer animation
09:32
Table (information)Type theoryTimestampTime zoneInformationElectronic visual displayDaylight saving timeBoundary value problemInformationMultiplication signData storage deviceMoment (mathematics)Control flowDefault (computer science)Row (database)Daylight saving timeElectronic visual displayTable (information)2 (number)Time zoneWeightTimestampDoubling the cubeSelectivity (electronic)Local ringFunctional (mathematics)Function (mathematics)Equivalence relationBookmark (World Wide Web)Type theorySystem callSpacetimeInsertion lossAddress spaceDatabaseNumberMixed realityImplementationNeuroinformatikOcean currentDifferenz <Mathematik>CalculationCASE <Informatik>ResultantMathematicsDifferent (Kate Ryan album)Data conversionOperator (mathematics)Query languageComputer animation
18:03
Regulärer Ausdruck <Textverarbeitung>Pattern matchingRegular graphClique-widthSpacetimeParameter (computer programming)Price indexGreatest elementConstraint (mathematics)MereologyFraction (mathematics)outputFloating pointServer (computing)Serial portSequenceTable (information)Standard deviationIdentity managementKey (cryptography)Default (computer science)NumberDatabaseCodierung <Programmierung>Data conversionSet (mathematics)ASCIIRule of inferenceConfiguration spaceLaptopData storage deviceRow (database)SequenceDefault (computer science)Constraint (mathematics)LengthExpressionQuery languageTable (information)Field (computer science)NumberLimit (category theory)Rule of inferenceSpacetimeFraction (mathematics)Codierung <Programmierung>Electric generatorCartesian coordinate systemKey (cryptography)outputError messageSubject indexingStandard deviationLimit of a functionAxiom of choiceMixture modelString (computer science)Parameter (computer programming)Personal identification numberIdentity managementDatabaseRegulärer Ausdruck <Textverarbeitung>Distribution (mathematics)Line (geometry)Type theoryRoundness (object)Data conversionGraphics tabletMultiplication signClique-widthComputer animation
26:34
Rule of inferenceLogicExecution unitStandard deviationView (database)Query languageSound effectTable (information)Inheritance (object-oriented programming)Event horizonTimestampPartition (number theory)Finitary relationConstraint (mathematics)Subject indexingPort scannerKey (cryptography)Physical systemSet (mathematics)Database transactionFormal languageDrop (liquid)Level (video gaming)Range (statistics)Error messageHash functionDatabase transactionCodeTable (information)Key (cryptography)Partition (number theory)Block (periodic table)Error messageRule of inferenceInheritance (object-oriented programming)Content (media)Uniform resource locatorLattice (order)LogicTimestampQuery languageBlogCharacteristic polynomialMereologyEvent horizonInsertion lossRow (database)Link (knot theory)ImplementationSlide ruleMathematicsSelectivity (electronic)Level (video gaming)Order (biology)Limit (category theory)Multiplication signObject-oriented programmingDatabaseGoodness of fitArithmetic meanPhysical systemMilitary baseConstraint (mathematics)Object-relational mappingSet (mathematics)QuicksortType theoryRange (statistics)Standard deviationCodeDifferent (Kate Ryan album)BitView (database)Series (mathematics)Computer animation
35:05
NumberStochastic differential equationProcess (computing)Client (computing)Server (computing)Information overloadRead-only memoryInterprozesskommunikationContext awarenessBefehlsprozessorObject (grammar)Strategy gameConcurrency (computer science)Database transactionBit rateTupleSpacetimeHorizonStapeldateiMilitary operationSoftware maintenanceVacuumOverhead (computing)Subject indexingTable (information)Channel capacityDefault (computer science)Intrusion detection systemWorkloadConnected spaceNumberOrder (biology)Table (information)Cartesian coordinate systemServer (computing)Row (database)Multiplication signSound effectFreezingBookmark (World Wide Web)StapeldateiProcess (computing)Quality of serviceDatabase transactionClient (computing)International Date LineContent (media)DatabaseBit rateLine (geometry)Default (computer science)InterleavingBefehlsprozessorSemaphore lineObject (grammar)Concurrency (computer science)VacuumStrategy gameGame controllerPhysical systemSemiconductor memorySubject indexingOverhead (computing)Context awarenessProduct (business)InterprozesskommunikationExterior algebraMultiplicationComputer animation
42:29
Goodness of fitType theoryPower (physics)Computer animation
43:46
Complex (psychology)Different (Kate Ryan album)Bounded variationType theoryDatabaseSlide ruleInheritance (object-oriented programming)Table (information)Web browserObject-relational mappingLimit (category theory)Data modelSubject indexingDiagram
46:32
Lattice (order)Wrapper (data mining)Partial derivativeRight angleSeries (mathematics)MereologyImplementationCorrespondence (mathematics)Density of statesInterior (topology)Slide ruleAuthenticationPointer (computer programming)Ring (mathematics)Different (Kate Ryan album)Data storage deviceMultiplication signWave packetContext awarenessComputer animation
49:53
Program flowchart
Transcript: English(auto-generated)