Merken

Schemaverse

Zitierlink des Filmsegments
Embed Code

Automatisierte Medienanalyse

Beta
Erkannte Entitäten
Sprachtranskript
thank you for coming or this being in this room already you really have my numbers hopefully you buy but to talk about kind of interesting you wanna join in and for those who actually are here because they know the scheme of refers also welcome and also is needed for all computer please there's lots so and what the universe is if you haven't found is a game that developed directly inside the post that so everything about the game is done using simple commands and it's all using features with PostgreSQL triggers rules basically any any little thing that I could use security wise to kind of build a game and enforce rules used in this case so Joffe purpose came to me and said I wanna bring a tournament of the game to the conference slot for review for the next roughly 24 hours going to start an instance of the tournament and run has a chance to the next to and actually go and play an issue commands and compute some pretty cool prizes well so all start getting into more specific but the specifics of the game bed let's go over my huge slide that year of Ivorian apologized to the what so 1st of all I have to
thank these people and mostly PG bringing me here to to do this is pretty also is just a game of and now I get can share with a bunch of people who love PostgreSQL was like it was because also have a hand in the future on the table so there definitely 1 the bank has also been a lot of prizes supplied by the size of a big thank you MateCat for some reason like my game quite a bit and they tend to support me also give a price for the death tournament but there was last year and in the longer it is my hosts currently they give me a server to host the databases on for absolutely no reason and I why but because they usually don't want press and but fun little thing that the data center that's actually in a bunker but but that's pretty cool so it was responses and there are some of the so the important part of
the tournament but are you actually competing for and I don't mean how do you win the game yet so but what is the enterprise 1st prize there's going to be a championship pretty which seems supercooled really excited still have actually seen it but I know my a really good job with the actual graphics so I assume translated well in this weather I don't know what size this yet but had hopefully hopefully within the 1st place also receive assigned 9 point you posted which is kind of exciting as well and the next prize is for best hat because I developed this game in a database had a lot of time and effort into creating a lot because of rules triggers functions anything and everything to to keep the user at they can only do certain things but of course everyone makes mistakes if you can break out of anything sequence actions come to mind and I think what you've done is fairly cool then you have a chance at winning a license of netiquette proposed which is really nice so as far as that of its clients got used to quite a bit in crashes less than most were also giving away a post-growth 9 . 2 teacher without a word if for some reason there's no great PAC learning fall doing a random user so long as you sign up to play you can potentially get this like 300 dollars worth of software and procedure so that's kind of incentive just idea as in the game there's a bunch of trophies the trophies themselves are just equal scripts now run and see what user 1 flowing again as the energy of a 9 1 poster to anyone who wins these prices here assuming the same person doesn't doesn't which should be possible if you want to know what the structure is actually then you can go and take a look at the codons serious actually looking for in the trophy table enough you select something about post about the game if you wanted to add more trophies the way people could when you can actually insert into the trophy table with your own code as well to make new way as far as what these kind of size matter is going to be basically the person with the greatest fleet so it's a space in the whole point is to build some part of planets build up your resources by mining them build more fleet aware of a more planets that are so if you have the biggest number of ships basically the largest count of your my ships table the neuron get that discovers person who goes and actually finds the most planets suffers planets also known as the greatest empire the 1st at the end of the game currently holding the most planets and 1st blood is an easy 1 1st what is going to be the 1st person to actually attack another press let me rephrase the 1st slide is the 1st person to attack something from the fire does is on and finally I have another post as my point seizure that give away to anyone who registers so hopefully can predict so with his presence so as far as the
actual tournament details about some hadn't to here that have basically the same information to the host for the tournament in PG conducts universe that this again this tournament is played directly in a post database when you register the account you used to register is a user on the post president so any client any programming language you want whatever you're familiar with and how you work with posters every day you can then use to play this game if you'd like to write a process of little pro program to go and connect and manage everything you can do so if you wanna use PG & manner PSQ well to do your acting around there's no problem with that either so basically anything that can touch PostgreSQL used with so that is the details of that if any point you need initially you have an issue and you need to get a hold of me as the game isn't perfect there are certainly bugs here and there or it's also not always explained well is the list of things that basically types the universe into something on the internet and it's going to come to me eventually will just stop correcting you when you take the members no longer says you know version of that might say and had a word and so on to what the game actually is to do this I'm actually just going to go to the website and of whatever that is kind of open discussion about the today is that seems a lot more interesting you know the time that standing up and going over and over and over and over every single row every single EU every single table every single function that's available for all the online especially if you wanna go to this link appears skewed universe . comes slash tutorials lasted for to class on a public database right now so if you just signed up here that accountant work there but again registration is always this present beautiful sure that you can potentially when it there's a number of people who can potentially get your and the advantages both the that happy in an of the first one that with him when I University in the year in which the read some of the words from the city and we people in any sort of designed by all of the so as far as the actual game goes of the best way look for a reference is to go to the tutorial in August universe are coming gotta learn and there's going to be a reference every view every table in every function they need actually play the game like a standard in was of the activity of a a little bit of and how to 1 on what's going on in the game so the 1st thing you do when you join up in the game is you're given 8 so it's when you start you're given 1 planet each player has 1 planet some planets that don't have anyone that motorway wanna do is start building ships at that planet to have to build ships well to manager ships those of you hold my shit so because it's a sequel in order to build a new ship what you wanna do is inserted into my ships this'll subtract money from your balance and then treated that ship there's some extra changes you can do it based on what columns you pass through so long as they fit into the rules for generally can be that easy the easiest way is just give it give it an intervenor My ships name values with the name so once you've done that is can automatically build that ships if you haven't given it a location then it will use the location of any random quantity of Concord since since the beginning of the game you only have 1 planet in a bill that shipped directly on the planet you can only build ships on points where there is a planet that your conqueror so I can just go build a ship planet and triangularly again have to to actually build up on my planet and then use the Move command to send my ships over the but before you wanna go start discovering others 1st you need more resources so as you create new ships by inserting you can then use the mind commands to tell you tell a system that you want that shipped to mind that planets that are currently on mining planets those 2 things 1 it is your resources each test and if the flow of energy to but it's mining give your resources which you then need to build more ships of British ships and then also moving the ship using the fuel to move the ship and it also doesn't think mining conquers planets of so when you could do you go to discover new planets in order to conquer and around you optimize more than another player at that point in time so those are the 2 key things of moved so the 1st thing you wanna do after you created a ship is start mining that planet so there's a mind function which just takes 2 arguments of the planet I the initial by the other way around dividing planet idea or every should also has state so I know that this ship is always going to be mining this planet I can update the action column of on the my ships table for that ship and the target to be that planet idea number if you wanna see what planet actually on
there's a planets view that lists all the details for everyone and his brother conquering everything and then you can just as call that down by your own player I D based on the conqueror idea about so this this making any sense all over house psychotic in my at this point really in the head and and the tutorial is awful I've given you a reason why it's not working for you but it was is that feeling my sort expires you break them busy and I thought yeah I wanna say nobody liked more likely answer is yes however if you log in right now and over the course of 1 hour in the tournament has the over the course of the next 15 or so minutes to build up enough miners to steadily mind your home planet that we're resources keep coming and coming in and so long as you're protecting your home planet then you'll likely keep it so every planet has a couple attributes planet it has a fuel amount that you can't see it might run out of your mind might just stopped working out that when it's not likely to happen to stay in the game it also has a mind limit the mind limit is the amount of ships that in mind that plant at each step so mining that is 30 you can build 30 ships there that keep mining that 1 planet and you'll likely always keep conquers the only way someone can be 2 is by coming in and mining it may be 16 times when you're trying to minus 15 times and then they have now conquered over you and they can build their ships that so that there is a way right now where you can if you're not really ready to play until later on you can at least have your script or hybrid system start preparing for you giving you resources so when you do lot in tonight but all this money and then you can go and that if you do have and have some time right now to put into it the best idea would be to start stripping something has no 1 wants to sit here for the next 24 hours and just type simple grand a sequel command the game has something called scripts and basically the system itself will run scripts that you write on your behalf each step I should really explain take at this point a mistake based so every minute approximately is a new text each ship can do 1 action potential so there's 3 kinds of actions is attacked is repair and this is mine C can choose 1 of those to perform each step if you write a fleet script the system will run that script on your behalf each time so you don't have to sit there managing it you can just write some little AI that will then go and build up so simple 1 for your whole mining plan it would be checked or check to see what the mind when it is of the planet check to see how many ships I have on that location around that location it's let that the amount of ships they have is less than build another ship and tell it to start mining and then the next time you got a bit more resources is that OK with you this again do this again so there there is very simple even like 5 10 lying pieces of code you can start writing battles start getting your resources another 1 so there's also so the My ships Table of reviewers that is for your own ships if you wanna see 1 enemies are approaching there's another table called ships in range and I'll show you roughly what health they have as well as where they are and what player and then there's a lot to it but it's super addictive actually want start writing scripts and kind of light and getting to know the system then and you start tweaking here and there are no always watching stats here you look like you've got a question mark up whether there is sample scripts and I was hoping to rewrite it for today as that it works really well about 6 months ago to that now there's been a lot of changes to the game and fortunately I will will do is all trying fix it up quickly after the start and then post on my Twitter feed so everyone who wants to go the should be just copy and paste the script and then we'll stop playing on this it will stop line for it what's the area getting on that and then you can you have a saying like incomplete and then you put something else it just says a set of them and like scope even JavaScript and all sorts of stuff like that the epidemic this is actually like a
real talk and I think I was
just going to go over some of the edges that if you'd like Pakistan
appearance are playing game which can since all yeah actually those a
physical so there's been a bit of
discussion lately about visualizing this stance I
created this game and wobble little embarrassing and there's an I'm absolutely horrible anything design this is why I created a game and that any and all of that area but lately some people are talking about
actually still visualizing what's going on in the results in pretty cool so this is the universe on a public server 1 day and this is the universe the next day each color is a different player seeing kind see how the different strips strategies that everyone has kind of shows in how well it's happening by purple that it takes over the right and then orange gets a little bit and somehow yellow just kind of goes everywhere if if you so there is 1 needs whether as the
Netherlands that a while ago you cannot see that at all but ended
up having a narrative that capture verse
of all their of when the tether to myself and then user is that you will have to get that kind of
this is that I have been present value of a dirty habit and here the tournament all of started yet so right now it's kind of like a little display area but I'm not yet I will be resetting addressed in a shouting up here so that it'll start and play a and maybe Chris the nice give you like a 10 minute had started something before is that the script to use what you might know how it is that we can go on and
on and general the thing in here thank you how the enhanced last
regularized and maybe someone was just telling me are using interactive list supply and that and also I don't know the person uses interactive Python apply and that's pretty fun to use the other graphs and created a critical of will double in the in in the in the year of
the 1 at y can go
talk to this guy I don't know where he is but I was using it in his as much in the off at the time they were on of is 1 of the the later on this side of work that is thank
you and how you you you you you you you you want
to do that you need to know that but here's the the first one all users
working very well the programme .
com I thought
my called in to you have yesterday on the public in an hour and a half of that I'm
going to try and use some of the more successful and it is yeah this is this is the public server a once they registered on my iPad is for PG conduct you're stuck on Amazon Web Services if the host of the database for the tournament and this 1 is accessable all the time in the round last week instead of 2 days so it's a bit of a different competition at times yet that 1 a server up and running connect to it but the actual tournament itself hasn't started that'll be in about 20 minutes PG conducts
universe . com there's no there's no online presence for that I have a lot of edits excessive amounts of and that I killed 2 many injuries
again so I will concede that some of so let's do you a case that as
far as like what's actually going to be kind of interesting even if you don't want to play but you want to see what's going on Cervantes stats tables settle kind of give you an interest like the current players that you to when announcing to give you a lot of information and her player takes that is just stats from the tape that just happened and so that's added more what just happened at that's better for gaining advantage finding out who suddenly winning my event is where everything in the game really gets long to if you create a ship it's going to be a lot better if you conquer planets in the log there the operators shippers to log there few mind something is the log the table grows extensively fairly fast but it's there might be this is where you write your fleet scripts and my player hold your player balance and your fuel amount the fuel reserves and also holds another interesting piece of information that's all the error channel enough here that everyone is familiar with the listen notify system in PostgreSQL because Europe has the system is running scripts on your behalf it needed a way of informing you of those areas that are happening so the system will do it is if you take listen and then take the name channel then every time you run a query it's going to return any new error messages with the payload of that of that query so and that that's secret number that each player has its unique is found might like uh your where you're inventory no 1 actually created an item so there's no inventory really if you want to create an item that there is an item table feel free to insert into it with what everyone and so at a coordinate passion person so if if you want if you want to just bring me some sort of sequels scripting cash than other what everyone in the system that there is a thousand dollars were dropped out of a scheme of are my query story is mostly just use for something else there and it's if you know if you're on the and the schemas website is the training wheels section which is like a nice web interface gives using helping functions and lets you run sequel within the browser and that's of stores those if you wanna use for storing something just for anything it's there and some sort of my ships again your ships details on ships stats you ships and current trajectory so much of flight recorder kind of fun when I assume especially for visualization and sing and play with them but but it basically maps about everything should you have about 1 also gets large might trade and I have never seen user use my trades it's there it probably took me the longest a code of most things in the game no and ever used it there I'm sure it's super body so you want to find a way to break the game start taking a look at Trent you may have to find a friend or maybe you can trade with yourself I don't all my players is going to show you who's online but which is basically what sessions are open on the battery's the planet that's view holds the detail for all planets you can see all plants and system anytime you can see who's conquered them you can see how much fuel they have but you can see and the mind limits of was like how big it is planet and range is going to show you don't use that actually of broken that it's going from a cash and we stopped updating the cash that was too intensive and I realized why are we making it had when was this is pretty good at indexing and so we have to respect reinventing the wheel and do something a bit about the yeah ships and range is certainly important but public variable you can store variables so as much as you want and that's useful to you scripting anyone kind of keep track of what you're doing or keep track of what you're talking maxRAF of like that user with everyone because for a a text for the numerical use of a shift-invariant again of the important ones we optimize that a lot so I think its usefulness but if you can actually run a query against it and it will return something of a story to writing begins equals harder I think that they will not exactly absolutely gave about what that means that the game is on github so if you want to learn anything about it or do something to it it's there all the code is that these enjoy there's also that that some air channel that I talked about a Python script and their calls universe OutputStream as a and that will just log into the database and just keep track of our people when to tell you there's any new areas being listed some nasal side the and then the audience that actually thought was something useful it could have been that I all just what's going to be useful quickly go over the function and then only as well if
you want to move the ships something called ship cost controls if that's too long for you at also you can use SEC I would certainly suggest looking at how to do that on the website the fuel and when you mind it wasn't your players balanced and then you can distribute your ship to refuel these are the 3 actions you can do the great use them convert resources converts your money to fuel or fuel to money a one-to-one ratio don't ask me why the difference being that all I want what I had an idea of some sort of economy where every time you try fuel it change the value of it you never traded money back to fuel so that stupid operators operator ships and the rest are just a bunch of utilities that are there's a very useful because all the website for the tutorial if you'd like them register please findings also please speak more pizza had that you are the and of the
Umwandlungsenthalpie
Turnier <Mathematik>
Computersicherheit
Zahlenbereich
Nummerung
Schlussregel
Computer
Extrempunkt
Computeranimation
Rechenschieber
Videokonferenz
Metropolitan area network
Spieltheorie
Grundraum
Instantiierung
Turnier <Mathematik>
Folge <Mathematik>
Bit
Punkt
Gruppenoperation
Systemzusammenbruch
Zahlenbereich
Zählen
Code
Raum-Zeit
Computeranimation
Rechenzentrum
Metropolitan area network
Client
Software
Spieltheorie
Prozess <Informatik>
Endogene Variable
Skript <Programm>
Datenstruktur
Hacker
Inklusion <Mathematik>
Lineares Funktional
Datenhaltung
Schlussregel
Algorithmische Programmiersprache
Sinusfunktion
Rechenschieber
Energiedichte
Mereologie
Server
Unternehmensarchitektur
Tabelle <Informatik>
Turnier <Mathematik>
Bit
Prozess <Physik>
Punkt
Beschreibungssprache
Versionsverwaltung
Familie <Mathematik>
Fortsetzung <Mathematik>
Computeranimation
Internetworking
Client
Datenmanagement
Randomisierung
Skript <Programm>
Gerade
Lineares Funktional
Parametersystem
Datentyp
Sichtenkonzept
Datenhaltung
Gebäude <Mathematik>
Twitter <Softwareplattform>
Menge
Registrierung <Bildverarbeitung>
Information
URL
Ordnung <Mathematik>
Tabelle <Informatik>
Standardabweichung
Aggregatzustand
Klasse <Mathematik>
Mathematisierung
Gruppenoperation
Zahlenbereich
E-Mail
Code
Data Mining
Datensatz
Spannweite <Stochastik>
Spieltheorie
Stichprobenumfang
Datentyp
Inverser Limes
Hybridrechner
Optimierung
Grundraum
Programmiersprache
sinc-Funktion
Statistische Analyse
Mailing-Liste
Schlussregel
Physikalisches System
Binder <Informatik>
Datenfluss
Quick-Sort
Programmfehler
Summengleichung
Energiedichte
Flächeninhalt
Offene Menge
Wort <Informatik>
Formale Grammatik
Elektronische Publikation
Datentyp
Elektronischer Datenaustausch
Extrempunkt
E-Mail
Dateiformat
Computeranimation
RFID
Sinusfunktion
Metropolitan area network
Message-Passing
Flächeninhalt
Ebene
Spieltheorie
Hacker
Normalvektor
Formale Grammatik
Resultante
Subtraktion
Bit
Elektronische Publikation
Elektronischer Datenaustausch
E-Mail
Dateiformat
Bildschirmfenster
Speicherbereichsnetzwerk
Computeranimation
Quader
Metropolitan area network
Message-Passing
Rechter Winkel
Strategisches Spiel
Server
Kantenfärbung
Grundraum
Webforum
Elektronische Publikation
Division
Elektronischer Datenaustausch
Hausdorff-Raum
E-Mail
Extrempunkt
Dateiformat
Bildschirmfenster
Speicherbereichsnetzwerk
Computeranimation
Motion Capturing
Metropolitan area network
Quader
Bildschirmmaske
Message-Passing
Cloud Computing
Gammafunktion
Turnier <Mathematik>
Elektronische Publikation
Datensichtgerät
Elektronischer Datenaustausch
Extrempunkt
Bildschirmfenster
Computeranimation
Metropolitan area network
Uniforme Struktur
Flächeninhalt
Datennetz
Skript <Programm>
Haar-Integral
Elektronische Publikation
Interaktives Fernsehen
Elektronischer Datenaustausch
Mailing-Liste
Ungerichteter Graph
Bildschirmfenster
Dateiformat
Speicherbereichsnetzwerk
Computeranimation
Lesezeichen <Internet>
Metropolitan area network
Message-Passing
Bildschirmsymbol
Datenfluss
Gammafunktion
Lesezeichen <Internet>
Metropolitan area network
Elektronische Publikation
Elektronischer Datenaustausch
Bildschirmfenster
Computeranimation
Programmiergerät
Elektronische Publikation
Indexberechnung
Elektronischer Datenaustausch
Extrempunkt
Hecke-Operator
Bildschirmfenster
Computeranimation
Metropolitan area network
Lesezeichen <Internet>
Login
COM
Baum <Mathematik>
Gammafunktion
Lesezeichen <Internet>
Metropolitan area network
Softwareentwickler
Elektronische Publikation
Ebene
Spieltheorie
Elektronischer Datenaustausch
Ausgleichsrechnung
Bildschirmfenster
Computeranimation
Informationssystem
Gruppenoperation
Turnier <Mathematik>
Bit
Subtraktion
Elektronische Publikation
Datenhaltung
Elektronischer Datenaustausch
Unrundheit
Bildschirmfenster
Computeranimation
Lesezeichen <Internet>
Metropolitan area network
Bildschirmmaske
Server
COM
Registrierung <Bildverarbeitung>
Grundraum
Große Vereinheitlichung
Wärmeleitfähigkeit
Unterring
Bit
Browser
Fortsetzung <Mathematik>
Extrempunkt
Bildschirmfenster
Computeranimation
Eins
Metropolitan area network
Total <Mathematik>
Skript <Programm>
Große Vereinheitlichung
Lineares Funktional
Nichtlinearer Operator
Softwareentwickler
Sichtenkonzept
Datenhaltung
Magnetbandlaufwerk
Wurm <Informatik>
Systemaufruf
Abfrage
Nummerung
Strömungsrichtung
Computervirus
Gleitendes Mittel
Ereignishorizont
Lesezeichen <Internet>
ATM
Garbentheorie
Information
Koordinaten
Software Engineering
Tabelle <Informatik>
Fehlermeldung
Wellenpaket
Zahlenbereich
Trajektorie <Mathematik>
Code
Variable
Spannweite <Stochastik>
Weg <Topologie>
Spieltheorie
Bus <Informatik>
Vererbungshierarchie
Inverser Limes
Speicher <Informatik>
Grundraum
Gammafunktion
Normalvektor
Benutzeroberfläche
Elektronische Publikation
Physikalisches System
Quick-Sort
Mapping <Computergraphik>
Summengleichung
Portscanner
Uniforme Struktur
Flächeninhalt
Bitrate
Nichtlinearer Operator
Subtraktion
Web Site
Elektronische Publikation
Gruppenoperation
Softwarewerkzeug
Extrempunkt
Bildschirmfenster
Quick-Sort
Computeranimation
Gruppenoperation
Metropolitan area network
Lesezeichen <Internet>
Total <Mathematik>
Gamecontroller
Bijektion

Metadaten

Formale Metadaten

Titel Schemaverse
Serientitel PGCon 2012
Anzahl der Teile 21
Autor PGCon - PostgreSQL Conference for Users and Developers
Mitwirkende Heroku (Provider)
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/19035
Herausgeber PGCon - PostgreSQL Conference for Users and Developers, Andrea Ross
Erscheinungsjahr 2012
Sprache Englisch
Produzent FOSSLC

Inhaltliche Metadaten

Fachgebiet Informatik
Abstract Compete against your fellow PostgreSQL users for prizes and the honor of the Schemaverse Champion title.

Ähnliche Filme

Loading...