Bestand wählen
Merken

PostgreSQL and Python, a match made in heaven

Zitierlink des Filmsegments
Embed Code

Automatisierte Medienanalyse

Beta
Erkannte Entitäten
Sprachtranskript
thank you for being there look at this is a
story about love so I think this is the
moment to talk about lot what is the meaning of loving what to do the it's not that hard a rhetorical question I want an answer from you know I really want an answer what is the meaning for you of doing what you love run you would think about it the the and so the the yeah what what look all of those were good answer look have another question for you and what do you not know it's another monotonic regression what you love the the coffee me to and those are good answers to I can say to you so what I love I love coffee obviously by of innovation OK and thankfully I'm not the only 1 I lucky enough to work with people that told of innovation through and innovation toward everyday I don't don't work in wonderland but I work for a 2nd quadrant Angela coaching and open source developers and I every day I work with item writing impact on 4 cause this and we Boston's if you want to create something you can use the your bike the national or PMP loss of hashtag for distilled so I promised you uh them starting probably 1 of the biggest of study of all of these the matchmaking and then between biotin and positives you can see the elephants and they're tightening love between each other because 1 of them question that I've been asked not only yesterday by 2 will soon different conferences was but quite imposed this get along together well um yes the a lot they have a lot of things in common really a lot of things in common 1st 1 of the 1st letter is a the and the ensues both of them have a huge who he really huge community that is really really involved that in the uh development of most of the programming language and of the latter based in the case of the positives the community is responsible for the robustness of the database what i powerful by doing this powerfully is flexible the uh Bosnia seized powerful and stable and both of them are really well documented you can find a lot of documentation on a lot of stuff on the internet on i can impose this together let you
know already tightened because this is about a conference so please allow me to introduce you positives 1 important thing the name the spores SQL or positives or if you feel like a close friend the PG began if you crawled deposits like this is the elephant will be happening please go please please please don't call calling pose great boat policy of this chorale or any other iteration between the letters of the name but the rise of the fund could be confused and I'm not sure that he will answer your questions OK and baskets the proposed is to add the guy is the fact of the default not obvious choice for many Piketon developers there are a lot of developers around the word about uh have chosen positives as isn't the fault that the base for deprecation obviously um most of project was projects support more than 1 database not usually test and the development is done impulses and while because part this the screen is present speech but it is stable this this feature reach and we are going see just the tip of the iceberg of the feature that part of positives and bust as is released frequently but this is really uh once a year for the reader and the agrees with the NewWave features and 1 of our time every few months we but fixes and mean of features we have a lot of raw
features so because it's free to reach and because this the first one is them MDC see that obviously is not something that only was this implemented but is something that pose this subpart and these are some of the motivation concordancer control that is something that uh makes you sure that you have transaction areas related between others so when you do something you're that the bees is always consistent with because the 1st directly before about the base is to keep your not as safe and positivist it's particularly good in doing that I've seen that the bases doing my work crashing it you really bad that had seen people recovering in the doctor until the moment of the crash so suppose this is safe proposed this ever the transaction the DL that is something that is less common than views see see and hear them basically when you do a change to your table for example you drop back on again if you do that on offense action that actually section of every operation that involves changing the your database these safe and section of so who is working on the Death of its own that moment is safe the different sections from each of the something that's not happens in every kind of other ways of every ever the biggest part of it is not like alone does not support something like this going but a support to somatic and double snake and so this is something that allow you to create our father table read a lot of uh 1 or more child table allow you to and speed your lattice in sub tables and access them to define a table following a logic and the from this 9 . 5 you can do that also on remote service so you can speak and shot . on remote servers and a speedy believe it in the battle and the Lord 1 different instances of baskets as the support for text full-text search there's something is reimport and especially for people that use jungle and developing jungle dates so part and the general have our ap máquina that tell you to use full-text search almost as easily then we have the replication replication is something that allow you to create a new I a 7 that is a master and a clone the 7 on another the stance phase them by the standby is always synchronized with the master any guesses disaster if the massive goes down and you can go more to this than by and the reduce to a minimum the on timing because of that situation then supports physical the cap and this is cool because but that is for me because I am I am disaster-recovery expert mechanic is that the cap is something that makes you called me your that the directory why your service is running you don't have to stop you several to make a make up you'd and you're going to copy the physical file of the severed and not asking for a SQL dumps so everything happens by the 70 running with no downtime for you so taking the gaps it's easier and it's faster guy does this of course the point-in-time recovery that's it like a kind of magic because if your someone jobs a table at 10 o'clock in the morning you can recover you the base and that mind and 59 and start just a 2nd before the disaster then isn't being just on the inside a specific type of doubt that was think of a people that like to use just on the especially people about maybe like the nurse to Allah type of uh doctor that can store the entire documents retain just on inside here that the so you can makes between a relational database and something different and another cos fainted and we talk about it later OK but now introduce you to our differing that the rapid FTB they allow you to connect to every kind of issues of uh back up outside the documents for example you connect to another database not only was this but that will so nice to an Oracle DB 2 or you can use us ensues at text file diffuser Seuss Hadamard surface we can lose everything and imports in your database as a table and you can do pretty on that and if there a much allows to you can also insert laughter again right straight inside the the OK and we have also post JS spots addresses just partially extensions uh that as x types X the functions X operations and index announcement for handling just passion about the they have a pose pos JS and have a lot of function that all of you to um move inside the arm mn geographic area and uh find points 11 years and is very important for people but um develop using js this in the relation between positives and by use of it a cycle because as a save a lot of developers back developers true positives and because of piece the software that is based on positivist and as an example that are based on positives and documentation of partners it's better than the other so more people is going to use them so was this community grows if the bus discredit community grows that the business stronger if that other business stronger and more people is going to use Python impose this together and this is a cycle because because of these the bottom community growth and is the Cyprus that it important the but now it's time to to talk about love story and let's get out let's get them in business sector this is a showcase of things that have been done using by home and posters and because a lot of people asking me OK but can you tell me at least a couple of projects that have been created using Python positive and the yes again like I created that so 15 we want to connect to pass this using pattern we have a lot of pattern on a mass like STM item me we upon urine and jungle order I'm OK there we can impact on they'd the handled posters and they have 1 thing in common every order and I that's a name to use this cycle be due to it is non 0 tap your hands because it's a moment of Italian pride for me because the main developers of psychology throughout talent I I really so the 2nd digit to the uh implements their Piketon DB API to point all it's based the only PQ data that libraries that other standard libraries for Bosnia's and it's open source because energy GPS so it's really free it's really is easy to use so much easier in that a lot of people user states and I've seen projects
um around the internet wrapping the 2nd due to to uh or create that he and even easier interface for that so all this really powerful obviously is not the only ran down a lot of other drivers this are the most famous was we have I was just to I buying a gesture PGA it thousand 0 CpG DB and a lot of words and then let us together by the way type strategy 2 is not the only 1 that a lot and everyone is valid the OK what if I tell you that you can use by inside cause this every let's say seniors the Bayes usually have our intended procedural language that allow you to write a procedure to uh handed out In a faster way that you would do in the room and extend a program at all this allow you to um lot Python inside the database and you spiked on in these libraries inside your database to modify your doctor you can do use spite to react to action like insert when updates or you can use it to you prepare that for huge band of that what you want you can use the fastest tighten you tighten inside the clusters and right by conclude in such close this at this adds the flexibility of Python straight said was this but wait I promised you that I would talk more about frame that the rapid as a say that you can use the frame but the rapid technology to connect to something instead now usually a say that for that the baptism we can see that if you use more decorum plays a softer uh that's totally that is written in Python you can use Python to right 4 in that the rappers aimed at 2016 and Italian pattern confidence have that's our token-based and ii written just for fun free for inductive wrappers them where I think the longest 1 was 150 lines of code comments included that other allow me to connect for example to SoundCloud and the prairie those asking for songs straight inside the database and then I was able to see the results of my search on a table and that got started because it was really trying to organize my music collection and then posters had me to do that if you want to see that the new confined decoder decodes might be counted as that 1 there is also a video and fortunately easy kind and so if you understand the talent you can skip that and the thing that you want after having loaded to back down to frame that the Raptors having loaded uh tightening inside the bus this these 2 becaptured database because you really can't stress enough people of importance for making a B cap you can do that using pattern that a couple of after that allow you to do that the most famous of iron Wally like this a really nice program but uh really act nicely uh every S and S free from Amazon and another 1 place from each frame was as by so this took about Obama why you would like to use violence because his offense was is 1 of the most use of the capital for posters to at it's feature-rich it's easy to use because 1 of the points that the developers have Wireless developing it is to keep it simple and it's developed by the team of nice people how I know that because I am 1 of those people and 1 of the BAM developers so let me introduce by menorah beats we are going to release their 2 . 2 version of the aspiration of the 2 . 2 will be released on July 17 and then to the feature that we're going to introduce its there as seen raised by the the cap that allow you to copy fast and really really fast it because we have done some classes of that could be and huge database on your big caps ever and this is important because but can say more people use of items softer offered to you you we Bustos the in the bad this after the can and by many is an example of that I can say that because of work at written by men from lot of years and by men and wrote stronger because of the people that reported back to oust not funded some features because like this 1 and now if my mind is stable is because of this OK and I not able to pronounce correctly I'd have other but have a look at so I'm going to call it HA began the the meaning of that word is that you want to database to be avaliable to the people most of the time because if your databases down probably the 1 of your concurrent is not so then the more you did you see the time the batteries for you how you can and that has a said before we have streaming applications that allow you to synchronize more than 1 several read your master social How can you handed the promotion of 1 or more servers in case of disaster you can use these patterns tax code Petronia that is written by Thailand so about its use by them it's often shows because of an MIT license is written in Python and is based on so people were all the more it is the always constant because you have more than 1 option is depends on what you know it's really powerful and um the to explain it simply when a database shuts down your master the use of the a discussion between the other nodes that this side with what which knowledge will be promoted to the master and it happens almost automatically guy so no more calls in the middle of the nite because the that business shut down obviously we have to recover it but you can do it in the morning after we have talked about that a base we're talking about HA now we want to handle our database may be easily now a lot of tools that allow you to do that we have here on the DB tool that's it's open sewers and have been the recently rewritten using jungle again the 2 . 0 version of the software being rude to them from scratch using John will discuss platform and they have a nice business to Tualitative and the self is we too much to really amazing guys from the and now they would for 2nd plot and John R. Michael leaks the then we
have another tool that is historically mn what's historically near Bosnia's OK as admin for all places open sewers is multi-platform and gives you the ability to see the plan of the primary because when you add some greater clarity um positives analyze it and decided how to act as you can see the plan not because this created for the query and you can see if you can optimize you play to be faster at like differently it and another thing and this really really really useful expression for developer gives you the ability to divide the perceiver languages died it's called the PLP just to that by granting the mustard procedure so usually is not easy to the background so to see those you can do that putting a about point under code and step by step analyzing after the graphical interface and show you pick because on the DB G up mean for our graphical OK we have the command line that state 2 was that most of the DBA over this is I mean we have that the default client was that the PS 2 as that in spite of the correspon of cause this is released we bust this is really powerful in its board to what repositories by the people that developed posters and have a lot of meta comments that allow you to perform actions uh like uh retrieving descriptions of tables to if you been deceived shown so ski mask over the following 14 keys or releasing that just need a big slash comment use a suspect slash and while leather traits faster and easier to use but of it is not perfect have some issues and browsing the Web searching for tools nice tools for this presentation have discovered that is existed PGx that is obviously less powerful non gestural uh but gives you seem better lighting somatic completion and always try to preview preened that output of the of the tables on your terminal obviously is not like spread but we fed to write just a quick query sparse that day and this is my completion is obviously context of of what you're writing the last 1 is the workload analyzes because you want to monitor how was this be you can do that using this software that is developed by Delhi bullet there is a French company that was composed this like 7 patents baseball pursues and is composed by 2 parts 1 part is an extension that that is sudden positives and is we can obviously in see because in spite of depositors and 1 part is using the phrase that's entirely right weakening and allow you to see you at trying graphs and see performance chart so you can inspect your database is working in C when or why we had to understand why you that these these under load on that moment he if ever huge amount a lots of his time and photo of a couple of ways that are really wrong for example you can do that all the money for i monitoring your database and these these out item to to do that what I show you is just the tip of the iceberg of the possibility of the things that are around the we can impact and pauses what I show you the status out on love and passion and that's why I said that passion is secured for distort but I want from you it's to get involved and spread of in being part of degree 2 cycle that issue you before to do that participating in conferences like this or not like these 2 but that the next conferences on positives OK but it is we have the Italian PG days that it's going to happen in the land in 2017 15 of October on POS discredit conference Europe that will happen in about 700 Tober 24 27 2017 in this conference and this evidence you can talk with people that are at the core of posters you can talk with people that are there to help you to write that the Python software we this because his day so it's important to meet these people to get involved in that seek a log of 3 to cycle the mn thank you and
thank and OK so who thinks lowers questions 1 day but I Duval distance presentation and user support that I'm tutors so OK and here's or which understandable was to to get something to that was that the Bayes works this so yeah and which is the the the the OK if not just a minute the sorry for detecting condition so uh at the that you hear the question have to repeat that not OK yes the need for them to work that analyzes crude impact on the performance of the batteries were dead yes it could marginally but they for situation so that's Europe that it is always up and they're EEG-workload again the maybe you want to spend a bit of a horsepower on try to understand what's going on the something you can deactivate it's an extension of these particles this must you can uh to me on and off so you can turn it on when you need it at to off not impacted you're impacting your uh performances find OK good the Special someone the so I don't you the but you have to be on the order
of the In the simplest the killing Table 1 100 million records that you want to select 1 so is there anything specific was addressed is going to allow us to foster uses is that let's say my sequence of some of the database the so she can only 100 million doses right it was like the select 1 the Is there something specific to was addressed is going to allow us to optimize the database clustering indexing and the a repeating depression because so I'm sure that every 1 of the he has need for exist something that helps you to create uh mn fast Aquarius this is the set the sensitive question right that had to be reckoned 1st the greatest yes as a set of uh b jet mean for for example makes you see the plan of a very so you you write a simple query that just like a Sextile style from something with ReaderMeter rows that proposes and not a lot of rows to be honest and you can see how cause this thing tend to act on that very and this is graphical you see what happens and you can decide that you can work and speech easily that prairie Enoch readiness of query per cent that's more performance liking depends on how close this react what searching is just inside that these the expected cost another vision so most by the way I will be at the 2nd part of the group mood in them and that some OK so if our questions you can find me or you can search for this guy said them up and go get for detecting regression or if you want to have to ask something that's more marketing know stuff related you can ask that yeah that is there were 2 together is into to the boot record OK but the impression that number I did the the the thanks a lot for your talk of as you can you read it have you talked a lot about the eliciting pipeline and those grass and an action promotes the work with both of my company but I'm wondering for other people who don't have experience with was Castilian what already Python developers do you have any good uh how to material or introduction so how they can learn more about using was bestowed by 4 visiting people a pretty familiar with database is in Python so they might be using mongo or a Maestro something happening it started with most you have any tips for the the the OK so he has given me some tips again to get is that impose this maybe immigrating from my askew as a law and order code of the staff a right OK they're probably the biggest I can still give you it's leader the commendation because the bust is recommendation it's really really organized and you can find what you need know exactly what you need just read out a simple search on the delimitation websites there are a lot of tutorial on how to install was this and usually for the biggest distribution is just a command line the alignment and getting started a it's almost pure SQL apostasy small almost pure as Gralla not strange cost actually if you funeral generally speaking SQL theory you're able to use because this just out of the box so 1 issue that we have um when we're developing for databases is that we wind up with the
schema we may have hundreds of tables we may have in the dozens of store your store procedure functions everything like that in the and what is the best way to organize and to manage that process and to you know of any tools that allow you to actually manage and you know keep all that stuff and see if you can do it on the command line yes you can do it on the command line but other tools that allow you for example that if you have a stored procedure and you make a change that's will procedure that you can automatically publish all the changes to the database you know from your father the answer is not yet again that atoms you never the question that because that tools that allow you to that to do that and not retaining so we're not part of my presentation there are tools allow you to keep track of the changes and the 4 different schemas see the changes specialist schemas and reload them then there are techniques for music was this we that uh allow you to do that we do less impact but at techniques are not specific to to do but as but experience working in 2nd grade in these years I've seen people doing a lot of strange stuff to do that and I was always seen that working working so workers who staff can and of every kind of some changes and because assistance section you can try that lies not brought that everything is the so another question and and the more full remark it's more followup remarked to which teaches us there is a land bank from the same author as people alchemy that is applied the TREC scheme outside he knows more like guess that doesn't do anything everything I guess but might be worth looking into the right along noted as the if you section below for the past this is also on on the top because you will find a web page not have a lease that is always updated of software for positives so refined the to 3 were asking you to find that at the collection of tools for positives and if you don't know that these also picons also again thank you yeah
Beobachtungsstudie
Programmiersprache
Softwareentwickler
Einfügungsdämpfung
Ortsoperator
Momentenproblem
Physikalischer Effekt
Datenhaltung
Open Source
Güte der Anpassung
Kartesische Koordinaten
Ultraviolett-Photoelektronenspektroskopie
Computeranimation
Internetworking
Intel
Arithmetisches Mittel
Open Source
Software
Lineare Regression
Facebook
Softwareentwickler
Einfügungsdämpfung
Punkt
Momentenproblem
Extrempunkt
Adressraum
Snake <Bildverarbeitung>
Iteration
Computeranimation
Freeware
Prozess <Informatik>
Typentheorie
Minimum
Mustersprache
Datenreplikation
Stützpunkt <Mathematik>
Default
Phasenumwandlung
Auswahlaxiom
Softwaretest
Umwandlungsenthalpie
Kraftfahrzeugmechatroniker
Lineares Funktional
Nichtlinearer Operator
Softwareentwickler
Sichtenkonzept
Datenhaltung
Ruhmasse
Systemaufruf
Systemaufruf
Kugelkappe
Arithmetisches Mittel
Transaktionsverwaltung
Dienst <Informatik>
Rohdaten
Verbandstheorie
Automatische Indexierung
Digitalisierer
Server
Garbentheorie
Projektive Ebene
Ordnung <Mathematik>
Verzeichnisdienst
Objektrelationale Abbildung
Standardabweichung
Tabelle <Informatik>
Instantiierung
Aggregatzustand
Subtraktion
Ortsoperator
Kreisfläche
Mathematisierung
Gruppenoperation
Systemzusammenbruch
Sprachsynthese
Maßerweiterung
Nichtlinearer Operator
Datensicherung
Mathematische Logik
RFID
Datenhaltung
Software
Flächentheorie
Datentyp
Digital Rights Management
Programmbibliothek
Diffusor
Maßerweiterung
Softwareentwickler
Touchscreen
Tabelle <Informatik>
Expertensystem
Relationale Datenbank
Antwortfunktion
Vererbungshierarchie
Open Source
Default
Relativitätstheorie
Indexberechnung
Elektronische Publikation
Energiedichte
Auswahlaxiom
Flächeninhalt
Mereologie
Gamecontroller
Bus <Informatik>
Wort <Informatik>
Wiederherstellung <Informatik>
Klon <Mathematik>
Resultante
Chipkarte
Einfügungsdämpfung
Punkt
Texteditor
Freeware
Statistische Schlussweise
Versionsverwaltung
Datenmanagement
Kartesische Koordinaten
Internetworking
Videokonferenz
Dämpfung
Schwebung
Gruppe <Mathematik>
Mustersprache
Druckertreiber
Kanal <Bildverarbeitung>
Gerade
Schnittstelle
Softwareentwickler
Physikalischer Effekt
Datenhaltung
Systemaufruf
Debugging
Plot <Graphische Darstellung>
Algorithmische Programmiersprache
Konfiguration <Informatik>
Kugelkappe
Arithmetisches Mittel
Rechter Winkel
Server
Strategisches Spiel
Decodierung
Drahtloses lokales Netz
Versionsverwaltung
Normalspannung
Jensen-Maß
Rahmenproblem
Portabilität
Klasse <Mathematik>
Gruppenoperation
Datensicherung
Systemplattform
Code
Datensichtgerät
Datenhaltung
Open Source
Leck
Knotenmenge
Bereichsschätzung
Software
Datentyp
Wrapper <Programmierung>
Programmbibliothek
Optimierung
Softwareentwickler
Druckertreiber
Offene Menge
Bus <Informatik>
Wort <Informatik>
Bit
Punkt
Momentenproblem
Formale Sprache
Datenmanagement
Aggregatzustand
Ungerichteter Graph
Deskriptive Statistik
Client
Arithmetischer Ausdruck
Radikal <Mathematik>
Default
Kanal <Bildverarbeitung>
Funktion <Mathematik>
Vervollständigung <Mathematik>
Dokumentenserver
Physikalischer Effekt
Datenhaltung
Abfrage
Debugging
Schwach besetzte Matrix
Algorithmische Programmiersprache
Meta-Tag
Arithmetisches Mittel
Konditionszahl
Ordnung <Mathematik>
Schlüsselverwaltung
Tabelle <Informatik>
Ortsoperator
Gruppenoperation
Automatische Handlungsplanung
Maßerweiterung
Kombinatorische Gruppentheorie
Whiteboard
Code
Datensichtgerät
Datenhaltung
Graph
CLI
Open Source
Benutzerbeteiligung
Software
Digitale Photographie
Abstand
Softwareentwickler
Maßerweiterung
Ereignishorizont
Default
Systemverwaltung
Verdeckungsrechnung
Beanspruchung
Minimalgrad
Last
Offene Menge
Mereologie
Dreiecksfreier Graph
Leistung <Physik>
Speicherabzug
Partikelsystem
Distributionstheorie
Sensitivitätsanalyse
Folge <Mathematik>
Prozess <Physik>
Ortsoperator
Quader
Stab
Mathematisierung
Gruppenoperation
Automatische Handlungsplanung
Gruppenkeim
Zahlenbereich
Ordinalzahl
Sprachsynthese
Kombinatorische Gruppentheorie
Web-Seite
Gesetz <Physik>
Physikalische Theorie
Code
Gradient
Weg <Topologie>
Datensatz
Software
Gruppe <Mathematik>
Notepad-Computer
Speicher <Informatik>
Softwareentwickler
Maschinelles Sehen
Autorisierung
Lineares Funktional
Booten
Physikalischer Effekt
Datenhaltung
Abfrage
Nummerung
Algorithmische Programmiersprache
Arithmetisches Mittel
Menge
Rechter Winkel
Automatische Indexierung
Mereologie
Garbentheorie
GRASS <Programm>
Ordnung <Mathematik>
Tabelle <Informatik>

Metadaten

Formale Metadaten

Titel PostgreSQL and Python, a match made in heaven
Serientitel EuroPython 2017
Autor Calacoci, Giulio
Lizenz CC-Namensnennung - keine kommerzielle Nutzung - Weitergabe unter gleichen Bedingungen 3.0 Unported:
Sie dürfen das Werk bzw. den Inhalt zu jedem legalen und nicht-kommerziellen Zweck nutzen, verändern und in unveränderter oder veränderter Form vervielfältigen, verbreiten und öffentlich zugänglich machen, sofern Sie den Namen des Autors/Rechteinhabers in der von ihm festgelegten Weise nennen und das Werk bzw. diesen Inhalt auch in veränderter Form nur unter den Bedingungen dieser Lizenz weitergeben
DOI 10.5446/33714
Herausgeber EuroPython
Erscheinungsjahr 2017
Sprache Englisch

Inhaltliche Metadaten

Fachgebiet Informatik
Abstract PostgreSQL and Python, a match made in heaven [EuroPython 2017 - Talk - 2017-07-11 - PyCharm Room] [Rimini, Italy] his talk is about a love story. The perfect love between PostgreSQL and Python. PostgreSQL is the default database choice for many Python developers, because it is robust, stable and open source. In 2ndQuadrant, we breathe PostgreSQL and we love python too, using it as much as possible for internal and external open source projects. We want to share our love for python and PostgreSQL and how they work together. So let us tell you a real love story

Ähnliche Filme

Loading...
Feedback