[STEEMSQL] A public SQL database with all blockchain data – UPDATE 1

arcange (73) in steemit • 8 years ago (edited)

8 years ago by arcange (73)

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!

Sort Order:

Trending

[-]

faddat (66) · 8 years ago

Do you sync at every block? If not, Happy to help you adapt STEEMJSON to do this for you :). I'm interested in using your DB for many things but I'd like to know how much abuse is too much abuse for the machines you have it hosted on?

$0.00

1 vote

[-]

arcange (73) · 8 years ago

Every block and every transaction are synced every 10 seconds.
You can freely use the DB for any development you have. I made it public and it has been designed to support heavy load. Infrastructure may be even scaled up if required. Go on ;)

$0.00

[-]

faddat (66) · 8 years ago

I absolutely would, if the source code was released. Without the source in the public domain you could (die, disappear, become disinterested, etc) and the services relying on this would poof.

If the source code were public, I'd use your server in a heartbeat. till them I'll have to continue to schlep through this problem my own way :(.

$0.00

[-]

arcange (73) · 8 years ago

I can't opensource steemsql right now because I used some non-opensource libs.
I'm working on replacing them. As soon it's done, I will make code public.

$0.00

[-]

andrew0 (64) · 8 years ago

Thank you for the great work!

$0.00

[-]

arcange (73) · 8 years ago

Thanks

$0.00

[-]

gamgam (55) · 8 years ago

Upvoted and following you.

$0.00

[-]

arcange (73) · 8 years ago

Thanks

$0.00

[-]

steempowerwhale (59) · 8 years ago

Thanks for update. I have upvoted and resteemed.

$0.00

[-]

arcange (73) · 8 years ago

Awesome! Thanks

$0.00

[-]

lukestokes (75) · 8 years ago

I may have to install a VM to figure out how to connect to this db via PHP, but I really am interested in figuring it out eventually. Thanks again for this hard work!

$0.00

[-]

arcange (73) · 8 years ago

Thanks for your comment.
It's quite easy to connect using PHP :


<?php
$serverName = "sql.steemsql.com";
$connectionInfo = array( "Database"=>"DBSteem", "UID"=>"steemit", "PWD"=>"steemit");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn ) {
     echo "Connection established.<br />";
}else{
     echo "Connection could not be established.<br />";
     die( print_r( sqlsrv_errors(), true));
}
?>

$0.00

1 vote

[-]

lukestokes (75) · 8 years ago

By default, on my mac, PHP doesn't come compiled with the drivers needed so you end up with this:

Fatal error: Call to undefined function sqlsrv_connect()

I spent a long time this past weekend at the RESTfest hackathon trying to get the PDO stuff to work on my mac. It turned into a big pain, unfortunately.

Are you running PHP on windows, already compiled with php_sqlsrv_53_ts.dll? If you could get this working on OSX, that would be fantastic.

$0.00

[-]

arcange (73) · 8 years ago

Unfortunately not working on OSX. Contact me on SteemSQL channel and we will see if we can solve it.

$0.00

[-]

miko (25) · 8 years ago (edited)

You can get Uniserver, it's a nice lightweight server with httpd & sql, Apache 2.0(which supports PHP, javascript and the likes) and MySql respectively. Which works on Windows. Nice security, but i wouldn't use it for a production website, i only use it for development and having my own intranet(for having a family website so we can write each other, post news, chores, appointments, etc.. that's just on our own network) . I don't work for Uniserver, i just like their product. I just read you have a mac, so um ya, windows isn't mac, but i'll keep the post up incase anyone else may find it useful.

$0.00

1 vote

[-]

arcange (73) · 8 years ago

There are several Mac alternative to SQL Server Management Studio:

DbVisualizer
RazorSQL
SQLPro for MSSQL

$0.00

2 votes

[-]

soldier (71) · 8 years ago

Great update! Thx

$0.00

[-]

arcange (73) · 8 years ago

More to come ... stay tuned!

$0.00