Viewing a response to: @arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update-1
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!
author | lukestokes |
---|---|
permlink | re-arcange-steemsql-a-public-sql-database-with-all-blockchain-data-update-1-20160921t171529861z |
category | steemit |
json_metadata | {"tags":["steemit"]} |
created | 2016-09-21 17:15:30 |
last_update | 2016-09-21 17:15:30 |
depth | 1 |
children | 5 |
last_payout | 2016-10-23 12:04:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 166 |
author_reputation | 555,781,629,106,002 |
root_title | "[STEEMSQL] A public SQL database with all blockchain data – UPDATE 1" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 1,318,733 |
net_rshares | 0 |
Thanks for your comment. It's quite easy to connect using PHP : ```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)); } ?> ```
author | arcange |
---|---|
permlink | re-lukestokes-re-arcange-steemsql-a-public-sql-database-with-all-blockchain-data-update-1-20160921t172744010z |
category | steemit |
json_metadata | {"tags":["steemit"]} |
created | 2016-09-21 17:27:42 |
last_update | 2016-09-21 17:27:42 |
depth | 2 |
children | 2 |
last_payout | 2016-10-23 12:04:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 426 |
author_reputation | 1,146,621,535,585,811 |
root_title | "[STEEMSQL] A public SQL database with all blockchain data – UPDATE 1" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 1,318,859 |
net_rshares | 41,179,603,672 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
klye | 0 | 41,179,603,672 | 100% |
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.
author | lukestokes |
---|---|
permlink | re-arcange-re-lukestokes-re-arcange-steemsql-a-public-sql-database-with-all-blockchain-data-update-1-20160921t211857650z |
category | steemit |
json_metadata | {"tags":["steemit"]} |
created | 2016-09-21 21:18:57 |
last_update | 2016-09-21 21:18:57 |
depth | 3 |
children | 1 |
last_payout | 2016-10-23 12:04:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 454 |
author_reputation | 555,781,629,106,002 |
root_title | "[STEEMSQL] A public SQL database with all blockchain data – UPDATE 1" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 1,321,048 |
net_rshares | 0 |
Unfortunately not working on OSX. Contact me on [SteemSQL channel](https://steemit.chat/channel/steemsql) and we will see if we can solve it.
author | arcange |
---|---|
permlink | re-lukestokes-re-arcange-re-lukestokes-re-arcange-steemsql-a-public-sql-database-with-all-blockchain-data-update-1-20160922t071621159z |
category | steemit |
json_metadata | {"tags":["steemit"],"links":["https://steemit.chat/channel/steemsql"]} |
created | 2016-09-22 07:16:21 |
last_update | 2016-09-22 07:16:21 |
depth | 4 |
children | 0 |
last_payout | 2016-10-23 12:04:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 142 |
author_reputation | 1,146,621,535,585,811 |
root_title | "[STEEMSQL] A public SQL database with all blockchain data – UPDATE 1" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 1,324,964 |
net_rshares | 0 |
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.
author | miko |
---|---|
permlink | re-lukestokes-re-arcange-steemsql-a-public-sql-database-with-all-blockchain-data-update-1-20160923t050402559z |
category | steemit |
json_metadata | {"tags":["steemit"]} |
created | 2016-09-23 05:04:03 |
last_update | 2016-09-23 05:05:30 |
depth | 2 |
children | 1 |
last_payout | 2016-10-23 12:04:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 602 |
author_reputation | 0 |
root_title | "[STEEMSQL] A public SQL database with all blockchain data – UPDATE 1" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 1,334,810 |
net_rshares | 0 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
miko | 0 | 0 | 100% |
There are several Mac alternative to SQL Server Management Studio: [DbVisualizer](http://www.dbvis.com) [RazorSQL](http://www.razorsql.com/) [SQLPro for MSSQL](https://www.macsqlclient.com/)
author | arcange |
---|---|
permlink | re-miko-re-lukestokes-re-arcange-steemsql-a-public-sql-database-with-all-blockchain-data-update-1-20160923t092818919z |
category | steemit |
json_metadata | {"tags":["steemit"],"links":["http://www.dbvis.com","http://www.razorsql.com/","https://www.macsqlclient.com/"]} |
created | 2016-09-23 09:28:18 |
last_update | 2016-09-23 09:28:18 |
depth | 3 |
children | 0 |
last_payout | 2016-10-23 12:04:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 191 |
author_reputation | 1,146,621,535,585,811 |
root_title | "[STEEMSQL] A public SQL database with all blockchain data – UPDATE 1" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 1,336,063 |
net_rshares | 150,204,593,946 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
abit | 0 | 150,204,593,946 | 1% | ||
miko | 0 | 0 | 100% |