Difference between revisions of "SteemSQL Gal"

From Steem Center
Jump to: navigation, search
(engadir (2))
(@paikan)
 
(17 intermediate revisions by the same user not shown)
Line 1: Line 1:
  
[http://www.steemsql.com/ SteemSQL] é un servidor de bases de datos público con acceso a todos os datos da [https://www.steem.center/index.php?title=Category:Steem_Blockchain BlockChain de Steem]] [http://www.steemsql.com/].
+
[http://www.steemsql.com/ SteemSQL] é un servidor de bases de datos público con acceso a todos os datos da [https://www.steem.center/index.php?title=Category:Steem_Blockchain BlockChain de Steem]]  
Foi presentada por [https://steemit.com/@arcange @arcange][https://steemit.com/@arcange] en Outubro de 2016 no post [https://steemit.com/steemit/@arcange/steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data '''[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data'''](1)
+
Foi presentada por [https://steemit.com/@arcange @arcange][https://steemit.com/@arcange] en Outubro de 2016 no post [https://steemit.com/steemit/@arcange/steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data '''[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data''']<ref> [STEEMSQL.COM] A public SQL server database with all Steemit blockchain data. [[https://steemit.com/steemit/@arcange/steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data https://steemit.com/steemit/@arcange/steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data]</ref>
SteemData offers a database layer for Steem. It allows people to query for large amounts of data very fast, as well as construct complex aggregate queries.
+
SteemData ofrece unha capa de base de datos para Steem. Isto permite as usuarias realizar consultas complexas e extructuradas movendo grandes cantidades de datos rápidamente.
  
 
Os datos estructurados en bases estructuradas son de fácil acceso dende calquera aplicación capaz de conectarse a unha base de datos [[SQL SERVER]]
 
Os datos estructurados en bases estructuradas son de fácil acceso dende calquera aplicación capaz de conectarse a unha base de datos [[SQL SERVER]]
As consultas son preguntas realizadas a base de datos SQL en lingoaxe nativo a cal recibe unha resposta de datos en bruto.(1)
+
As consultas son preguntas realizadas a base de datos SQL en lingoaxe nativo a cal recibe unha resposta de datos en bruto.
No caso de non ter unha copia local da [[Steem Blockchain]] cabe a posibilidade de enviar unha '''pregunta''' ó servidor '''SteemSQL'' mediante os programas e léxico adecuados.(1)
+
No caso de non ter unha copia local da [https://www.steem.center/index.php?title=Steem_blockchain_gal Steem Blockchain] cabe a posibilidade de enviar unha '''pregunta''' ó servidor '''SteemSQL'' mediante a lingoaxe de programación [[MySQL (Gal)]]
 
<br>
 
<br>
 
{| class="wikitable" style="margin: auto;"
 
{| class="wikitable" style="margin: auto;"
| Mellora esta entrada. Rexistrate, fai click en  [https://www.steem.center/index.php?title=SteemSQL_Gal&action=edit editar], engade, modifica, complementa, enriquece o texto e garda os cambios. Obrigadas pola túa achega  
+
| Mellora esta entrada. Rexistrate, fai click en  [https://www.steem.center/index.php?title=SteemSQL_Gal&action=edit editar], engade, modifica, complementa, enriquece o texto e garda os cambios. <br>
 +
 
 +
Podes facer túas achegas en RAG ou en AGAL, mais non se deben mesturar ambas normativas<br>
 +
Obrigadas pola túa achega <br>
 
|-
 
|-
 
|}
 
|}
 
<br>
 
<br>
 
   
 
   
=== Información para a conexión á Base de Datos SteemSQL ===
+
==Conectarse coa Base de datos SteemSQL==
 +
 
 +
=== Datos para conexión á Base de Datos SteemSQL: ===
 
<br>
 
<br>
  
Velaiquí a información paa conectarse a e preguntar á Base de Datos.(1)
+
Velaiquí a información paa conectarse a e preguntar á Base de Datos.
  
 
* '''Server''': sql.steemsql.com
 
* '''Server''': sql.steemsql.com
 
* '''User''': steemit
 
* '''User''': steemit
 
* '''Password''': steemit
 
* '''Password''': steemit
* '''Database name''': DBSteem  
+
* '''Database name''': DBSteem
 
 
You can extend the info about the topic separating the text in more parts, each one identified with a specific title.
 
  
{| class="wikitable" style="margin: auto;"
+
===Mediante Phyton===
|'''Referencias'''
+
#:                             <code>import pypyodbc
 +
                                connection = pypyodbc.connect('Driver={SQL Server};'
 +
                                'Server=sql.steemsql.com;'
 +
                                'Database=DBSteem;'
 +
                                'uid=steemit;pwd=steemit')
 +
                                cursor = connection.cursor() <br>
 +
                                SQLCommand = ("YOUR SQL QUERY”)<br>
 +
                                cursor.execute(SQLCommand)<br>
 +
                                connection.close()</code> <ref>[ [STEEMSQL.COM] A public SQL server database with all Steemit blockchain data]
  
* (1) [STEEMSQL.COM] A public SQL server database with all Steemit blockchain data. [[https://steemit.com/steemit/@arcange/steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data https://steemit.com/steemit/@arcange/steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data]
+
=== Mediante R ===
*(2) SteemData meets sbds - SQL Users Rejoice [https://steemit.com/steemdata/@furion/steemdata-meets-sbds-sql-users-rejoice steemit.com/steemdata/@furion/steemdata-meets-sbds-sql-users-rejoice] por [[https://steemit.com/@furion @furion]
 
 
 
 
 
[http://www.siteurl.com/article Title of the article or post], Written by '''Name of Author''' ([http://steemit.com/@steemitusername @steemitusername]) in Name of Site in Month Day, Year.
 
# [https://steemit.com/steemcenterwiki/@steemcenterwiki/anatomy-of-a-pleasant-and-desirable-steem-center-wiki-page-plus-a-new-received-donation-from-scooter77#@freyman/re-steemcenterwiki-anatomy-of-a-pleasant-and-desirable-steem-center-wiki-page-plus-a-new-received-donation-from-scooter77-20170716t002027869z Reference use Proposal], Written by '''Freyman''' ([http://steemit.com/@freyman @freyman]) in July 15th, 2017.
 
# Insert any references cited and identified by numbers in the text
 
 
 
|-
 
|}
 
  
 
==Links==
 
==Links==
official sites, tutorial sites and Steemit blog posts that helps understanding the subject
+
Sitios oficiais, tutoriais e Posts nos blogs do Steemit que axudan a entender o suxeito do artigo.
  
* [https://steemit.com/@arcange '''@arcange'''][https://steemit.com/@arcange https://steemit.com/@arcange]
+
* [https://steemit.com/cn/@justyy/r-tutorial-knowing-when-a-steem-whale-vote-r-steem R Tutorial - Knowing when a Steem Whale vote?] por [https://steemit.com/@justyy '''@justyy''']. Visto 2017/10/24
 +
* [https://steemit.com/steemstem/@justyy/steemsql-tutorial-finding-inactive-steemians-that-you-follow-steemsql-steem SteemSQL Tutorial - Finding Inactive Steemians that You Follow - SteemSQL] por [https://steemit.com/@justyy '''@justyy''']. Visto 2017/10/23
 +
* [https://steemit.com/steemit/@arcange/steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data '''[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data'''] por [https://steemit.com/@arcange '''@arcange''']
 
* '''SteemSQL''' : [http://www.steemsql.com/ www.steemsql.com]
 
* '''SteemSQL''' : [http://www.steemsql.com/ www.steemsql.com]
* '''Canle de Chat de SteemSQL ''' : [https://steemit.chat/channel/steemsql steemit.chat/channel/steemsql]
+
* '''SteemSQL Chat''' : [https://steemit.chat/channel/steemsql steemit.chat/channel/steemsql]
* '''Steem''' : https://steem.io
+
* [https://steemit.com/steemsql/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update-7 STEEMSQL - A public SQL database with all blockchain data – ''' Update 8''']
* '''Steemit''' : https://steemit.com
+
* [https://steemit.com/steemit/@arcange/steemsql-com-how-to-create-a-steem-analytic-report-with-microsoft-excel ''' How to create a Steem analytic report with Microsoft Excel''' ]
* '''@steemitusername''' : https://steemit.com/@steemitusername
+
* [https://steemit.com/fr/@paikan/steemsql-guide-d-utilisation-accessible-a-tous '''SteemSQL : Guide d’utilisation accessible à tous'''] por [https://steemit.com/@paikan @paikan] en Outubro 2017. Visto 2017/11/18
* '''@steemitusername''' : [https://steemit.com/steemit/@someguy123/steem-center-center-of-all-things-steem Steemit blog post title] ''Month XXth, 2017''
+
 
* Include more links related directly with the subject and Steemit posts links here if you want
+
* Inclue mais links relacionados directamente co suxeito e enlaces a Post do Steemit se o consideras necesario.
  
 
==Related articles==
 
==Related articles==
  
Links a outros steemCenter artículos
+
Links a outros artigos no [https://www.steem.center Steem.Center]
  
* [[Steem]]
+
 
* [[Steem.center]]
+
* [https://steemit.com/@arcange '''@arcange'''][https://steemit.com/@arcange https://steemit.com/@arcange]
 
* [[Steemit]]
 
* [[Steemit]]
 
* [[Steem Ecosystem]]
 
* [[Steem Ecosystem]]
Line 86: Line 90:
 
<br>
 
<br>
  
 +
==Referencias==
  
 
[[Category:galego]] [[Category:Steemit]][[Category:Steem Blockchain]][[Category:SQL]]
 
[[Category:galego]] [[Category:Steemit]][[Category:Steem Blockchain]][[Category:SQL]]

Latest revision as of 15:40, 18 November 2017

SteemSQL é un servidor de bases de datos público con acceso a todos os datos da BlockChain de Steem] Foi presentada por @arcange[1] en Outubro de 2016 no post [STEEMSQL.COM A public SQL server database with all Steemit blockchain data][1] SteemData ofrece unha capa de base de datos para Steem. Isto permite as usuarias realizar consultas complexas e extructuradas movendo grandes cantidades de datos rápidamente.

Os datos estructurados en bases estructuradas son de fácil acceso dende calquera aplicación capaz de conectarse a unha base de datos SQL SERVER As consultas son preguntas realizadas a base de datos SQL en lingoaxe nativo a cal recibe unha resposta de datos en bruto. No caso de non ter unha copia local da Steem Blockchain cabe a posibilidade de enviar unha pregunta' ó servidor SteemSQL mediante a lingoaxe de programación MySQL (Gal)

Mellora esta entrada. Rexistrate, fai click en editar, engade, modifica, complementa, enriquece o texto e garda os cambios.

Podes facer túas achegas en RAG ou en AGAL, mais non se deben mesturar ambas normativas
Obrigadas pola túa achega


Conectarse coa Base de datos SteemSQL

Datos para conexión á Base de Datos SteemSQL:


Velaiquí a información paa conectarse a e preguntar á Base de Datos.

  • Server: sql.steemsql.com
  • User: steemit
  • Password: steemit
  • Database name: DBSteem

Mediante Phyton

  1. import pypyodbc
                               connection = pypyodbc.connect('Driver={SQL Server};'
                               'Server=sql.steemsql.com;'
                               'Database=DBSteem;'
                               'uid=steemit;pwd=steemit')
                               cursor = connection.cursor() 
SQLCommand = ("YOUR SQL QUERY”)
cursor.execute(SQLCommand)
connection.close()
<ref>[ [STEEMSQL.COM] A public SQL server database with all Steemit blockchain data]

Mediante R

Links

Sitios oficiais, tutoriais e Posts nos blogs do Steemit que axudan a entender o suxeito do artigo.

  • Inclue mais links relacionados directamente co suxeito e enlaces a Post do Steemit se o consideras necesario.

Related articles

Links a outros artigos no Steem.Center


External Links

  • Wikipedia : Article title Retrieved in Month/Day/2017
  • Name of the site : Title of the page, blog post or news report Written by Name of Author, published in Month/Day/2017
  • Name of the YouTube Channel : Title of the video Video by Name of Author published in Month/Day/2017
  • Here you can suggest external sites links, Wikipedia is a good option. Try Google Search and filter by News too if you want.

In other languages




Axudanos a manter esta páxina da Wiki actualizada.

Rexistrate, fai click en editar, engade ou modifica o texto e garda os cambios.
Se xa eres steemian, podes ser recompensada con tokens STEEM. Mira cómo en @steemcenterwiki.


Referencias

  1. [STEEMSQL.COM] A public SQL server database with all Steemit blockchain data. [https://steemit.com/steemit/@arcange/steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data