create account

RE: [STEEMSQL] A public SQL database with all blockchain data – UPDATE 1 by lukestokes

View this thread on: hive.blogpeakd.comecency.com

Viewing a response to: @arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update-1

· @lukestokes ·
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!
properties (22)
authorlukestokes
permlinkre-arcange-steemsql-a-public-sql-database-with-all-blockchain-data-update-1-20160921t171529861z
categorysteemit
json_metadata{"tags":["steemit"]}
created2016-09-21 17:15:30
last_update2016-09-21 17:15:30
depth1
children5
last_payout2016-10-23 12:04:33
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length166
author_reputation555,781,629,106,002
root_title"[STEEMSQL] A public SQL database with all blockchain data – UPDATE 1"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id1,318,733
net_rshares0
@arcange ·
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));
}
?>

```
👍  
properties (23)
authorarcange
permlinkre-lukestokes-re-arcange-steemsql-a-public-sql-database-with-all-blockchain-data-update-1-20160921t172744010z
categorysteemit
json_metadata{"tags":["steemit"]}
created2016-09-21 17:27:42
last_update2016-09-21 17:27:42
depth2
children2
last_payout2016-10-23 12:04:33
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length426
author_reputation1,146,621,535,585,811
root_title"[STEEMSQL] A public SQL database with all blockchain data – UPDATE 1"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id1,318,859
net_rshares41,179,603,672
author_curate_reward""
vote details (1)
@lukestokes ·
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.
properties (22)
authorlukestokes
permlinkre-arcange-re-lukestokes-re-arcange-steemsql-a-public-sql-database-with-all-blockchain-data-update-1-20160921t211857650z
categorysteemit
json_metadata{"tags":["steemit"]}
created2016-09-21 21:18:57
last_update2016-09-21 21:18:57
depth3
children1
last_payout2016-10-23 12:04:33
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length454
author_reputation555,781,629,106,002
root_title"[STEEMSQL] A public SQL database with all blockchain data – UPDATE 1"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id1,321,048
net_rshares0
@arcange ·
Unfortunately not working on OSX. Contact me on  [SteemSQL channel](https://steemit.chat/channel/steemsql) and we will see if we can solve it.
properties (22)
authorarcange
permlinkre-lukestokes-re-arcange-re-lukestokes-re-arcange-steemsql-a-public-sql-database-with-all-blockchain-data-update-1-20160922t071621159z
categorysteemit
json_metadata{"tags":["steemit"],"links":["https://steemit.chat/channel/steemsql"]}
created2016-09-22 07:16:21
last_update2016-09-22 07:16:21
depth4
children0
last_payout2016-10-23 12:04:33
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length142
author_reputation1,146,621,535,585,811
root_title"[STEEMSQL] A public SQL database with all blockchain data – UPDATE 1"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id1,324,964
net_rshares0
@miko · (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.
👍  
properties (23)
authormiko
permlinkre-lukestokes-re-arcange-steemsql-a-public-sql-database-with-all-blockchain-data-update-1-20160923t050402559z
categorysteemit
json_metadata{"tags":["steemit"]}
created2016-09-23 05:04:03
last_update2016-09-23 05:05:30
depth2
children1
last_payout2016-10-23 12:04:33
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length602
author_reputation0
root_title"[STEEMSQL] A public SQL database with all blockchain data – UPDATE 1"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id1,334,810
net_rshares0
author_curate_reward""
vote details (1)
@arcange ·
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/)
👍  ,
properties (23)
authorarcange
permlinkre-miko-re-lukestokes-re-arcange-steemsql-a-public-sql-database-with-all-blockchain-data-update-1-20160923t092818919z
categorysteemit
json_metadata{"tags":["steemit"],"links":["http://www.dbvis.com","http://www.razorsql.com/","https://www.macsqlclient.com/"]}
created2016-09-23 09:28:18
last_update2016-09-23 09:28:18
depth3
children0
last_payout2016-10-23 12:04:33
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length191
author_reputation1,146,621,535,585,811
root_title"[STEEMSQL] A public SQL database with all blockchain data – UPDATE 1"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id1,336,063
net_rshares150,204,593,946
author_curate_reward""
vote details (2)