abstrct

With the ability to use pl/pgsql within the game, it can get as complicated as you want :)

It doesn't necessarily teach each advanced technique, but it does give you a good place to practice what you've learned.

(Thanks for the mention!)

Thanks for the post!

For new players it's best to start in the tutorial: https://schemaverse.com/tutorial/tutorial.php

Awesome. I look forward to it! Keep up the good work

I notice you have to pass a username when starting the server. Is there no way to require username/password from a database user when they access the site?

Thanks! Come try it out sometime :D You clearly have an equal love for postgres.

I asked because we have been considering ways for people to easily deploy their own instance of the game (likely for educational purposes). So I try to keep an eye open for new db services.

The technical reason for the requirement is that players connect from all over but the system also needs to be able to connect as each player - preferably without knowing their password. We normally handle this with a trust relationship between specific servers. Alternatively we could be using a superuser account and SET ROLE but that would require some other changes as well.

Nice to hear about superuser. That's great.

Unfortunately it doesn't sound like it will cover my use-case, but admittedly my scenario is a weird one (see http://schemaverse.com).

Either way, thanks for the response and best of luck with the service!

How much configuration changes do we have access to behind the scenes? Any chance the pg_hba.conf is available to the owner? Similarly, do we have access to create additional roles/users?

We just issued a press release today to announce the Certified Bitcoin Professional (CBP) - our first certification. http://www.prweb.com/releases/2014/09/prweb12165371.htm

We have spent about a year working on the organization and we are really happy with how far it has come. We have a lot more work ahead but we think the CBP is a great start.

Please feel free to post any comments, concerns and questions. I will answer them all to the best of my abilities.

Thanks

TLDR: thnx

Will this work on Heroku?

Trying to use Bitcoind on there is pretty much impossible.

I have been working on a robot battle game that uses cryptocurrency transactions as the main game action mechanic. We call the game Coindroids.

It is currently only available to play with Defcoin but it is pretty fun so far. It's kind of like satoshi dice but with tactics/strategy instead of luck.

https://def.coindroids.com

I had turned it off on my account as well, which is what made seeing two years of search history from myself so surprising. I assume when my account was +'d, this setting was accidentally missed.

Moral of the story, just take a quick look anyways.

Honestly, none in particular at the moment and yet also any that's needed. I just see a situation where if I did need to work with two currencies, having an API for one and then building the infrastructure in house for the other seems silly, especially since most alt coins are literally clones of each other.

Do you have any plans to offer the API for altcoins as well?

I work in digital forensics so information like an IP address can be just another piece of the puzzle. It's not something we would base our entire case around but I'm sure it would be helpful in some way.

I certainly understand that it is just an estimate though, thanks to the beauty of the btc network in general and other fun tools like tor and your own transaction relay.

Ya this is really slick looking. There are some issues here and there but it's a new site so that is to be expected.

The close tie in with testnet is a nice touch. A lot of developers seem to forget that testnet is there to help them.

Do you plan on trying to farm additional details regarding transactions such as estimated originating IP address or known address labels?

Does the JSON type still have a set of use cases as well or is it just obsolete now? If I was writing large quantities of json documents to a table, and I didn't need tag indexing or targeted updating, would using the JSON type be faster than JSONB?

At some point there is so much data available to work with that even nicely optimized queries become too slow. This may have also been a limitation of hardware but either way the game quickly became not fun when it was persistent.

The Schemaverse (http://schemaverse.com) is massive multiplayer game that you play through programming, although the gameplay is no longer persistent and is now played in one day rounds. I would love to make a better persistent version one day but it needs a lot of hardware to support most users complete lack of optimization (or deliberate resource hogging attacks).

Schemaverse isn't nearly as polished as this is but if you are looking to battle some AI, give it a chance.

The Schemaverse (http://schemaverse.com)

Play a space battle MMO, but using SQL. The game is also completely open source so if you want to find out how to write an entire application layer in PostgreSQL, it is a pretty good example of that.

How do you value a network able to send 'value' across the globe immediately. What does PayPal and Visa value their networks at? I imagine it is a good chunk of change.

Now, to further complicate things, you have to put a value on that piece of that puzzle that actually changes hands during these transactions. Realistically, the value of it doesn't even matter if I want to go CAD -> BTC -> BTC -> USD. As long as the value between CAD and USD makes sense, the transaction was a success and all parties are happy.

This is what most people, generally the investment folk, don't understand about our new little technology here. Bitcoin isn't just about the value of a Bitcoin and a Bitcoins buying power. Bitcoin is a network. The value of the fuel for that network will very as people need it and as the cost associated with generating that fuel change. This is irrelevant though as the price of Bitcoin is not the measure of its usefulness, or its success.

I actually went straight to that page after reading the article to find out who he is, but I stand by my statement. Him being an expert just makes the tweets more pathetic.

TL;DR: Man spends 5 minutes thinking about Bitcoin on a plane and comes to conclusions which may or may not be correct. Shares them with people because he is super duper important.

I had my registration to the beta accepted within less than a minute. The interface is impressively slick. I honestly didn't know IBM had it in them but they did a really nice job on it.

That's just my initial thoughts though. Now I need to sit down and actually deploy something to it.

At least one aspect was a bit amusing: http://pic.twitter.com/iPqCk1J3x8

Neat, thanks for the info! I will have to give this a try then.

Luckily, I don't need to care about read-only or blacklisted queries, the entire application is already built into the database layer.

Are you able to login as different database users?

I would love to try using this with Schemaverse (http://schemaverse.com) but most frameworks I have seen have trouble with multiple database roles/connections.

Keep in mind, lawyers also have technical consultants they use whenever computers are involved - and computers are ALWAYS involved.

There is also the Schemaverse (http://schemaverse.com), a multi-player space battle game for learning SQL, pl/pgSQL, and really any other language that has a library for connecting to PostgreSQL

That's awesome :D If you are looking for any particular resources for the presentation let me know.

As for adding awesomeness, I would say the core devs do a pretty fantastic job of that. I just utilize it is odd ways ;)

I have no shame in saying that the MySQLgame was definitely part of the inspiration for the Schemaverse, my own little SQL project.

There are some main platform differences, as many have pointed out, but those who like one of the other generally fit into one of these two reasons:

1) Botting/AI vs Human Interaction only - When people started writing bots to play MySQLGame, others seemed to get furious. If you want to do well in the Schemaverse, you likely have to write some form of AI at some point, either in SQL or any other platform you wish.

2) Story vs no Story - People who like MySQLgame really appreciate the fact that the story is simply the numbers. I think that does make for a pretty unique game on its own, even outside of the SQL aspect of things. The Schemaverse is a space battle.

Shameless plug, if SQL games interest you and you will be at DEFCON 21 in Las Vegas this year, there will be another Schemaverse championship. Start getting ready now and it will take up very little of your conference time but you could win some great prizes and sweet sweet SQL game street-cred. https://forum.defcon.org/forumdisplay.php?f=690 for more information