Difference between revisions of "SteemSQL Gal"
(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/ 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'''] | + | 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 | + | 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. | + | 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 [ | + | 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> | ||
− | === | + | ==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. | + | 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 |
− | |||
− | |||
− | + | ===Mediante Phyton=== | |
− | + | #: <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] | ||
− | + | === Mediante R === | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
==Links== | ==Links== | ||
− | + | Sitios oficiais, tutoriais e Posts nos blogs do Steemit que axudan a entender o suxeito do artigo. | |
− | * [https://steemit.com/@ | + | * [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] | ||
− | * ''' | + | * '''SteemSQL Chat''' : [https://steemit.chat/channel/steemsql steemit.chat/channel/steemsql] |
− | * | + | * [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'''] |
− | + | * [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''' ] | |
− | + | * [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 | |
− | + | ||
− | * | + | * Inclue mais links relacionados directamente co suxeito e enlaces a Post do Steemit se o consideras necesario. |
==Related articles== | ==Related articles== | ||
− | Links a outros | + | Links a outros artigos no [https://www.steem.center 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 19: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 |
Contents
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
-
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.
- R Tutorial - Knowing when a Steem Whale vote? por @justyy. Visto 2017/10/24
- SteemSQL Tutorial - Finding Inactive Steemians that You Follow - SteemSQL por @justyy. Visto 2017/10/23
- [STEEMSQL.COM A public SQL server database with all Steemit blockchain data] por @arcange
- SteemSQL : www.steemsql.com
- SteemSQL Chat : steemit.chat/channel/steemsql
- STEEMSQL - A public SQL database with all blockchain data – Update 8
- How to create a Steem analytic report with Microsoft Excel
- SteemSQL : Guide d’utilisation accessible à tous por @paikan en Outubro 2017. Visto 2017/11/18
- 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
- @arcangehttps://steemit.com/@arcange
- Steemit
- Steem Ecosystem
- Include more existent or suggested Steem.center wiki articles if you want
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
- 繁體中文 (Chinese, Traditional) : Steem.center(繁) | * 简体中文 (Chinese, Simplified) : Steem.center(简) | * 日本語 (Japanese): Steem.center (jp) | Include other languages versions if available
Axudanos a manter esta páxina da Wiki actualizada.
Rexistrate, fai click en editar, engade ou modifica o texto e garda os cambios.
|
Referencias
- ↑ [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