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

View this thread on: hive.blog | peakd.com | ecency.com

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

steemit · @arcange · Sep 21 '16

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));
}
?>

```

👍 klye

`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,608,602,483,196
`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`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
klye	0 B		41,179,603,672	100%

@lukestokes · Sep 21 '16

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)

`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,178,519,358,062
`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

@arcange · Sep 22 '16

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)