Difference between revisions of "SteemSQL Gal"
(→Información para a conexión á Base de Datos SteemSQL: phyton) |
|||
| Line 14: | Line 14: | ||
<br> | <br> | ||
| − | === | + | ==Conectarse coa Base de datos SteemSQL== |
| + | # 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> | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | === Datos para conexión á Base de Datos SteemSQL: === | ||
<br> | <br> | ||
| Line 22: | Line 37: | ||
* '''User''': steemit | * '''User''': steemit | ||
* '''Password''': steemit | * '''Password''': steemit | ||
| − | * '''Database name''': DBSteem | + | * '''Database name''': DBSteem |
| − | |||
| − | |||
==Links== | ==Links== | ||
Revision as of 18:04, 1 August 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 os programas e léxico adecuados.
| Mellora esta entrada. Rexistrate, fai click en editar, engade, modifica, complementa, enriquece o texto e garda os cambios. Obrigadas pola túa achega |
Contents
Conectarse coa Base de datos SteemSQL
- 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()
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
Links
official sites, tutorial sites and Steemit blog posts that helps understanding the subject
- @arcangehttps://steemit.com/@arcange
- SteemSQL : www.steemsql.com
- SteemSQL Chat : steemit.chat/channel/steemsql
- SteemData meets sbds - SQL Users Rejoice por [@furion
- STEEMSQLCOM A public SQL server database with all Steemit blockchain data por @furion
- Steem : https://steem.io
- Steemit : https://steemit.com
- @steemitusername : https://steemit.com/@steemitusername
- @steemitusername : Steemit blog post title Month XXth, 2017
- Include more links related directly with the subject and Steemit posts links here if you want
Related articles
Links a outros steemCenter artículos
- Steem.center
- 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
