Sort:  
  • Trending
    • [-]
     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?

    [-]
     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
      Reply
      [-]
       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
        Reply
        [-]
         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
          Reply
          [-]
           8 years ago 

          Thank you for the great work!

          $0.00
            Reply
            [-]
             8 years ago 

            Upvoted and following you.

            $0.00
              Reply
              [-]
               8 years ago 

              Thanks for update. I have upvoted and resteemed.

              $0.00
                Reply
                [-]
                 8 years ago 

                Awesome! Thanks

                $0.00
                  Reply
                  [-]
                   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
                    Reply
                    [-]
                     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));
}
?>
                    [-]
                     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
                      Reply
                      [-]
                       8 years ago 

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

                      $0.00
                        Reply
                        [-]
                         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
                          • and 1 more
                          Reply
                          [-]
                           8 years ago 

                          There are several Mac alternative to SQL Server Management Studio:

                          DbVisualizer
                          RazorSQL
                          SQLPro for MSSQL

                          $0.00
                            2 votes
                            Reply
                            [-]
                             8 years ago 

                            Great update! Thx

                            $0.00
                              Reply
                              [-]
                               8 years ago 

                              More to come ... stay tuned!

                              $0.00
                                Reply