Difference between revisions of "SteemSQL Gal"
(→Links) |
(@paikan) |
||
(5 intermediate revisions by the same user not shown) | |||
Line 18: | Line 18: | ||
==Conectarse coa Base de datos SteemSQL== | ==Conectarse coa Base de datos SteemSQL== | ||
+ | |||
+ | === Datos para conexión á Base de Datos SteemSQL: === | ||
+ | <br> | ||
+ | |||
+ | 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=== | ===Mediante Phyton=== | ||
#: <code>import pypyodbc | #: <code>import pypyodbc | ||
Line 29: | Line 40: | ||
connection.close()</code> <ref>[ [STEEMSQL.COM] A public SQL server database with all Steemit blockchain data] | 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. | Sitios oficiais, tutoriais e Posts nos blogs do Steemit que axudan a entender o suxeito do artigo. | ||
+ | * [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'''] | * [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] | ||
Line 50: | Line 52: | ||
* [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/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/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. | * Inclue mais links relacionados directamente co suxeito e enlaces a Post do Steemit se o consideras necesario. | ||
Line 55: | Line 58: | ||
==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] | * [https://steemit.com/@arcange '''@arcange'''][https://steemit.com/@arcange https://steemit.com/@arcange] | ||
− | |||
* [[Steemit]] | * [[Steemit]] | ||
* [[Steem Ecosystem]] | * [[Steem Ecosystem]] |
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