<center>![sql.png](https://images.hive.blog/DQmXYEFZ8EC3AfsFr6piwYEDAkZD5JnCYkr31YUfDpdBCaN/sql.png)***Cheat sheet from a Udemy course***</center> I code as a hobby. I like how simple codes can automate daily tasks, experiment with new ideas, and just be fun. Whenever I get a chance I do like to learn new coding skills. But one aspect of coding I always tried to avoid was dealing with databases. I did have experience in the past retrieving data from database using SQL. I learned about SQL from friends here, @carlgnash and @markangeltrueman. First time I used SQL was for curating purposes using SteemSQL(now HiveSQL). Usually there are some GUI programs to use SQL. I used it within a python code, so that I could do other operations on the data. In the following post I wrote about how to do the initial setup on Mac to use SQL commands in a python code: https://hive.blog/utopian-io/@geekgirl/making-sql-queries-to-steemsql-com-with-python-scripts-on-macos It can still be useful for those need to connect to a MSSQL server on a Mac computer. One change I would make is to use pyodcb, instead of pypyodcb as was suggested by @crokkon back then, and worked perfectly. Last few days I have been trying to learn more about SQL, specifically PostgreSQL. It is open source, widely used, and powerful relational database. I almost finished [a Udemy course](https://www.udemy.com/course/the-complete-sql-bootcamp/) by Jose Portilla. I would highly recommend this Udemy course to anybody who is interested in learning SQL. Jose is a really good at teaching how to code. He also has useful courses on python, data science, etc. We can download PostgreSQL from PostgreSQL.org. To connect to the database, create databases, query data, etc we can use pgAdmin 4, which can be found at pgadmin.org. pgAdmin 4 runs on a browser and is really cool. I enjoyed using when learning how to SQL. However, my personal preference is to use SQL commands within python code. To do that we can use `psycopg2` module. The following code does just that, it allows to connect to a PostgreSQL within a python code. Afterwards we can execute any python operations we want with the retrieved data. Moreover, we should be able to create our own databases, tables, and store data all within python code. ``` import psycopg2 as pg2 import pprint def queryDB(sql): database = 'awesome_database' user = 'postgres' password = 'XXXXXXXXXXXX' conn = pg2.connect(database=database, user=user, password=password) cur = conn.cursor() cur.execute(sql) result = cur.fetchmany(100) conn.close() return result sql = '''SELECT * FROM awesome_table''' result = queryDB(sql) pprint.pprint(result) ``` By changing the content of the text inside `sql` variable we can execute any SQL commands. This code connects to a local database. To connect to a remote database we will need to provide details for `host` address and `port`. For more details on `pscycopg2` visit Psycopg.org To experiment more with SQL, I want to explore the Hive blocks, learn what and how data is stored within Hive blocks, and store them in my own local PostgresSQL database. Of course not all of Hive, just few recent transactions. All of Hive blocks would probably take a lot of time and space. Doing so will give me an opportunity to understand Hive more, and experiment with SQL. I hope to share more about that next time. Coding is fun!
author | geekgirl |
---|---|
permlink | connecting-to-postgresql-database-and-making-queries-within-python-code |
category | python |
json_metadata | {"tags":["python","sql","coding","dev","neoxian","leo","ctptalk","palnet"],"users":["carlgnash","markangeltrueman","crokkon"],"image":["https://images.hive.blog/DQmXYEFZ8EC3AfsFr6piwYEDAkZD5JnCYkr31YUfDpdBCaN/sql.png"],"links":["https://hive.blog/utopian-io/@geekgirl/making-sql-queries-to-steemsql-com-with-python-scripts-on-macos","https://www.udemy.com/course/the-complete-sql-bootcamp/"],"app":"hiveblog/0.1","format":"markdown"} |
created | 2020-09-10 01:40:33 |
last_update | 2020-09-10 01:40:33 |
depth | 0 |
children | 8 |
last_payout | 2020-09-17 01:40:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 8.072 HBD |
curator_payout_value | 6.399 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 3,424 |
author_reputation | 1,215,196,225,598,670 |
root_title | "Connecting to PostgreSQL database and making queries within Python code." |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 99,545,904 |
net_rshares | 50,686,663,952,603 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
tombstone | 0 | 16,010,325,550 | 0.75% | ||
ash | 0 | 171,918,797,625 | 25% | ||
chitty | 0 | 283,682,413,511 | 75% | ||
kevinwong | 0 | 4,168,424,202,297 | 50% | ||
gerber | 0 | 18,855,345,102 | 0.29% | ||
daan | 0 | 55,444,170,814 | 8% | ||
ezzy | 0 | 21,020,852,422 | 0.29% | ||
mrwang | 0 | 13,921,597,945 | 25% | ||
livingfree | 0 | 154,148,732,063 | 2% | ||
exyle | 0 | 19,460,257,518 | 0.29% | ||
arconite | 0 | 17,914,313,294 | 25% | ||
miketr | 0 | 6,168,390,301 | 5% | ||
hanshotfirst | 0 | 543,379,873,656 | 10% | ||
bert0 | 0 | 2,063,982,043 | 0.4% | ||
netaterra | 0 | 5,826,672,253 | 0.26% | ||
someguy123 | 0 | 9,596,537,040 | 0.29% | ||
ats-david | 0 | 1,779,493,416,336 | 50% | ||
sammie | 0 | 21,247,737,695 | 100% | ||
daveks | 0 | 296,287,312,620 | 7.5% | ||
aggroed | 0 | 6,514,539,865,843 | 100% | ||
petrvl | 0 | 120,844,815,061 | 15% | ||
clayboyn | 0 | 104,767,563,247 | 25% | ||
techslut | 0 | 27,898,134,316 | 5% | ||
created | 0 | 364,677,944,884 | 2% | ||
supergoodliving | 0 | 118,635,852,152 | 50% | ||
teofilex11 | 0 | 23,072,301,918 | 100% | ||
darth-azrael | 0 | 38,097,459,649 | 25% | ||
darth-cryptic | 0 | 13,360,285,473 | 25% | ||
privex | 0 | 496,865,654 | 0.58% | ||
chasmic-cosm | 0 | 24,158,845,830 | 100% | ||
bloggingforbeans | 0 | 18,747,493,086 | 50% | ||
bethalea | 0 | 588,790,744 | 20% | ||
dune69 | 0 | 1,967,215,218 | 0.29% | ||
papadimos | 0 | 1,791,363,159 | 16.28% | ||
forykw | 0 | 610,394,789 | 0.14% | ||
roomservice | 0 | 81,804,728,569 | 1.87% | ||
angelgarz | 0 | 4,224,994,051 | 100% | ||
swelker101 | 0 | 236,161,644,383 | 50% | ||
kaylee.nicole | 0 | 15,910,817,817 | 50% | ||
isaria | 0 | 959,466,887,770 | 50% | ||
rycharde | 0 | 1,193,231,640 | 10% | ||
belahejna | 0 | 20,979,923,646 | 15% | ||
alphacore | 0 | 584,333,705 | 0.04% | ||
enjar | 0 | 669,595,284,333 | 100% | ||
henryn2020 | 0 | 715,676,942 | 100% | ||
duckmast3r | 0 | 22,227,366,449 | 46% | ||
kris10 | 0 | 90,281,944,872 | 50% | ||
cryptopie | 0 | 737,195,393,341 | 93% | ||
hope-on-fire | 0 | 1,104,742,280,248 | 100% | ||
lugina | 0 | 1,233,717,832,594 | 100% | ||
themarkymark | 0 | 2,218,972,076,477 | 10% | ||
leaky20 | 0 | 82,895,418,029 | 100% | ||
tykee | 0 | 5,741,119,583 | 50% | ||
resiliencia | 0 | 775,296,836,143 | 100% | ||
thatindianlady | 0 | 14,895,910,448 | 5% | ||
valchiz | 0 | 1,832,106,043 | 10% | ||
chops316 | 0 | 42,411,667,411 | 100% | ||
felander | 0 | 1,446,826,411 | 0.29% | ||
stoodkev | 0 | 3,395,037,248,401 | 100% | ||
jedigeiss | 0 | 1,375,040,139,048 | 100% | ||
nurhayati | 0 | 2,341,815,774 | 50% | ||
crokkon | 0 | 27,113,923,620 | 100% | ||
accelerator | 0 | 44,428,571,978 | 5% | ||
buildawhale | 0 | 7,299,608,242,904 | 10% | ||
artonmysleeve | 0 | 21,564,770,649 | 3.75% | ||
therealwolf | 0 | 741,251,308,045 | 2.5% | ||
roleerob | 0 | 633,388,653,078 | 75% | ||
inthenow | 0 | 53,217,619,247 | 100% | ||
makerhacks | 0 | 27,764,972,032 | 10% | ||
andywong31 | 0 | 11,431,549,481 | 100% | ||
josediccus | 0 | 285,558,779,369 | 50% | ||
traciyork | 0 | 811,284,452,935 | 100% | ||
emrebeyler | 0 | 6,235,053,429 | 0.29% | ||
communitycoin | 0 | 1,213,521,421,200 | 50% | ||
smartsteem | 0 | 149,878,839,178 | 2.5% | ||
chireerocks | 0 | 12,675,734,849 | 50% | ||
mytechtrail | 0 | 41,014,994,852 | 15% | ||
afril | 0 | 46,454,222,204 | 100% | ||
kamchore | 0 | 171,803,074,069 | 100% | ||
tiazakaria | 0 | 1,853,926,484 | 100% | ||
ats-witness | 0 | 198,277,992,295 | 50% | ||
crookshanks | 0 | 3,312,317,349 | 100% | ||
fourfourfun | 0 | 6,863,947,078 | 25% | ||
upmyvote | 0 | 7,385,444,392 | 10% | ||
jim888 | 0 | 1,880,115,205,926 | 100% | ||
korinkrafting | 0 | 744,598,997 | 25% | ||
fun2learn | 0 | 3,246,561,711 | 3% | ||
nealmcspadden | 0 | 3,755,163,266 | 0.29% | ||
bala41288 | 0 | 163,548,389,224 | 50% | ||
edicted | 0 | 2,744,706,772,612 | 100% | ||
mermaidvampire | 0 | 14,904,827,995 | 50% | ||
purefood | 0 | 2,724,679,596 | 0.29% | ||
chorock | 0 | 580,836,616,841 | 45% | ||
leoumesh | 0 | 30,022,738,868 | 100% | ||
investyourvote | 0 | 2,145,643,626 | 6% | ||
svemirac | 0 | 5,779,020,926 | 100% | ||
florenceboens | 0 | 1,405,211,995 | 10% | ||
penderis | 0 | 22,935,239,584 | 50% | ||
anikys3reasure | 0 | 529,392,483 | 10% | ||
movement19 | 0 | 3,942,950,196 | 2.5% | ||
mutiahanum | 0 | 4,590,082,352 | 99% | ||
afrinsultana | 0 | 2,363,007,516 | 10% | ||
backinblackdevil | 0 | 351,920,168,341 | 75% | ||
yusrizakaria | 0 | 8,114,085,120 | 90% | ||
josevas217 | 0 | 720,896,411 | 0.32% | ||
bestboom | 0 | 1,290,031,827 | 0.29% | ||
marcybetancourt | 0 | 27,817,340,778 | 72% | ||
kyberlee | 0 | 9,665,571,612 | 100% | ||
louis88 | 0 | 237,955,888,812 | 20% | ||
stmdev | 0 | 387,269,759 | 10% | ||
jan23com | 0 | 5,744,177,834 | 90% | ||
freddio | 0 | 11,490,502,146 | 15% | ||
z3ll | 0 | 23,705,229,381 | 100% | ||
choco11oreo11 | 0 | 3,564,155,455 | 90% | ||
payroll | 0 | 94,740,477,786 | 2% | ||
irwandarasyid | 0 | 3,237,863,811 | 99% | ||
sheikhsayem | 0 | 3,526,066,649 | 100% | ||
steem.services | 0 | 3,581,568,667 | 0.07% | ||
slobberchops | 0 | 1,769,100,714,035 | 35% | ||
pladozero | 0 | 79,069,188,497 | 10% | ||
nateaguila | 0 | 296,178,159,314 | 8% | ||
thefoundation | 0 | 938,881,470 | 2.95% | ||
suonghuynh | 0 | 10,422,384,965 | 6% | ||
czera | 0 | 16,930,361,904 | 100% | ||
thehive | 0 | 85,390,739,672 | 70% | ||
dalz | 0 | 276,631,924,173 | 100% | ||
smartvote | 0 | 132,449,489,663 | 6% | ||
holovision | 0 | 25,563,682,519 | 100% | ||
jk6276 | 0 | 0 | 1% | ||
littleshadow | 0 | 5,326,380,051 | 90% | ||
dlike | 0 | 3,442,334,872 | 0.29% | ||
blueeyes8960 | 0 | 316,885,567,586 | 100% | ||
voxmortis | 0 | 1,079,301,451 | 0.5% | ||
joseph6232 | 0 | 1,811,691,370 | 90% | ||
emaillisahere | 0 | 3,279,049,828 | 75% | ||
buzzbee | 0 | 631,749,444 | 50% | ||
caoimhin | 0 | 3,968,086,835 | 100% | ||
djtrucker | 0 | 1,480,159,414 | 75% | ||
oakshieldholding | 0 | 304,781,181 | 100% | ||
laissez-faire | 0 | 99,475,083 | 100% | ||
voter001 | 0 | 931,988,284 | 1.47% | ||
marshalmugi | 0 | 77,473,206,160 | 85% | ||
podg3 | 0 | 1,722,411,881 | 90% | ||
misstaken | 0 | 6,478,254,857 | 90% | ||
berthold | 0 | 2,535,396,896 | 6% | ||
followjohngalt | 0 | 1,954,385,708 | 0.29% | ||
brosgn | 0 | 11,886,365,651 | 50% | ||
bro-poker | 0 | 72,274,297,480 | 50% | ||
jussbren | 0 | 2,007,054,248 | 90% | ||
maajaanaa | 0 | 3,699,385,704 | 100% | ||
smokingfit | 0 | 2,965,355,969 | 50% | ||
retrodroid | 0 | 10,609,179,703 | 25% | ||
mariyem | 0 | 878,059,995 | 100% | ||
bluerobo | 0 | 114,216,238,462 | 100% | ||
rikue | 0 | 679,141,818 | 100% | ||
ctime | 0 | 179,295,771,003 | 1% | ||
hanke | 0 | 7,151,930,552 | 100% | ||
goodcontentbot | 0 | 806,968,078 | 15% | ||
curationvoter | 0 | 10,966,259,045 | 50% | ||
curationhelper | 0 | 7,785,369,119 | 100% | ||
limka | 0 | 0 | 5% | ||
leeyh2 | 0 | 8,731,239,854 | 100% | ||
akkibadboy | 0 | 351,718,071 | 100% | ||
cindis | 0 | 1,141,447,218 | 100% | ||
linur | 0 | 1,171,656,791 | 100% | ||
mfblack | 0 | 1,426,472,397 | 0.27% | ||
actifit-devil | 0 | 6,393,433,706 | 100% | ||
samujaeger | 0 | 75,190,692,082 | 100% | ||
coredump | 0 | 62,343,962 | 10% | ||
epicdice | 0 | 5,534,714,012 | 0.75% | ||
bro-rando | 0 | 2,943,887,941 | 50% | ||
ladeen | 0 | 799,480,060 | 100% | ||
haxxdump | 0 | 0 | 5% | ||
wulff-media | 0 | 38,048,859,658 | 50% | ||
tinyhousecryptos | 0 | 528,977,553 | 5% | ||
brosino | 0 | 7,461,422,833 | 50% | ||
burn-it-down | 0 | 1,166,388,144 | 30% | ||
brosgn.fund | 0 | 30,550,606,200 | 50% | ||
suigener1s | 0 | 559,482,691 | 100% | ||
yeswecan | 0 | 16,826,871,021 | 90% | ||
steem.leo | 0 | 2,935,223,807 | 0.29% | ||
abh12345.pal | 0 | 739,171,005 | 100% | ||
mindtrap-leo | 0 | 300,584,093 | 16.28% | ||
xawi-ag | 0 | 534,463,182 | 15% | ||
neoxiancity | 0 | 15,808,673,077 | 20% | ||
bearjohn | 0 | 774,676,819 | 75% | ||
mktmaker | 0 | 550,558,654 | 72.75% | ||
freddio.sport | 0 | 3,281,052,933 | 15% | ||
babytarazkp | 0 | 6,326,715,367 | 100% | ||
mapxv | 0 | 3,333,706,240 | 29% | ||
abh12345.neox | 0 | 0 | 8.1% | ||
botante | 0 | 201,052,493 | 0.07% | ||
fsc69 | 0 | 5,167,735,353 | 80% | ||
opidia | 0 | 24,591,313,660 | 100% | ||
logiczombie | 0 | 83,625,300,644 | 13.88% | ||
acta | 0 | 24,186,149,045 | 100% | ||
the-table | 0 | 16,802,619,488 | 90% | ||
cardtrader | 0 | 2,166,117,231 | 100% | ||
maxuvd | 0 | 20,363,127,371 | 6% | ||
maxuve | 0 | 28,165,531,221 | 6% | ||
brocfml | 0 | 889,107,556 | 100% | ||
thehouse | 0 | 1,876,222,051 | 90% | ||
spinvest-leo | 0 | 357,577,073 | 5% | ||
tonimontana.leo | 0 | 697,551,842 | 16.29% | ||
tonimontana.neo | 0 | 55,806,136 | 2.69% | ||
silverquest | 0 | 124,480,416,939 | 90% | ||
gerbo | 0 | 0 | 0.28% | ||
honeychip | 0 | 8,661,498,408 | 85% | ||
kryptoformator | 0 | 3,809,265,445 | 7.5% | ||
bro.poker | 0 | 3,729,099,203 | 100% | ||
toni.pal | 0 | 6,506,123 | 4.63% | ||
mice-k | 0 | 1,367,080,769 | 0.29% | ||
davidlionfish | 0 | 12,604,424,910 | 50% | ||
tommys.shop | 0 | 1,724,330,504 | 90% | ||
steemcityrewards | 0 | 0 | 0.29% | ||
hivewaves | 0 | 578,605,174 | 75% | ||
blue-witness | 0 | 1,199,505,306 | 100% | ||
hiveyoda | 0 | 4,899,207,295 | 2% | ||
bnk | 0 | 20,789,339,608 | 17.5% | ||
visionaer3003 | 0 | 8,665,413,889 | 0.29% | ||
gitplait | 0 | 76,576,498,745 | 100% | ||
polish.hive | 0 | 734,440,056 | 0.29% | ||
dcityrewards | 0 | 9,192,400,098 | 0.29% | ||
hextech | 0 | 7,223,282,206 | 66% | ||
paulman | 0 | 1,504,704,078 | 75% | ||
hiveonboard | 0 | 2,350,284,254 | 1.87% | ||
hivelist | 0 | 6,046,831,764 | 10% | ||
hivecur | 0 | 6,692,221,541 | 0.29% | ||
hatschi0773 | 0 | 1,063,869,951 | 0.29% | ||
chartreader | 0 | 0 | 0.29% | ||
recoveryinc | 0 | 206,841,062,670 | 5% | ||
brofund-pal | 0 | 1,932,923,059 | 57% | ||
dying | 0 | 36,213,938,392 | 5% | ||
ibrahim51 | 0 | 2,375,113,685 | 100% |
I have picked your post for my daily hive voting initiative, Keep it up and Hive On!!
author | chitty |
---|---|
permlink | re-connecting-to-postgresql-database-and-making-queries-within-python-code-20200912t000450 |
category | python |
json_metadata | "" |
created | 2020-09-12 00:04:54 |
last_update | 2020-09-12 00:04:54 |
depth | 1 |
children | 0 |
last_payout | 2020-09-19 00:04:54 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 86 |
author_reputation | 86,901,300,608,582 |
root_title | "Connecting to PostgreSQL database and making queries within Python code." |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 99,580,265 |
net_rshares | 0 |
I'm using MySQL but PostgreSQL was a very strong second choice. The poker database I used back in the day was based on PostgreSQL. Currently working on my Cards Against Humanity clone. Maybe I'll have you take a look at it when I have something relevant.
author | edicted |
---|---|
permlink | re-geekgirl-qgf6zx |
category | python |
json_metadata | {"tags":["python"],"app":"peakd/2020.09.1"} |
created | 2020-09-10 02:02:21 |
last_update | 2020-09-10 02:02:21 |
depth | 1 |
children | 4 |
last_payout | 2020-09-17 02:02:21 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.145 HBD |
curator_payout_value | 0.145 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 259 |
author_reputation | 2,890,242,526,660,396 |
root_title | "Connecting to PostgreSQL database and making queries within Python code." |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 99,546,167 |
net_rshares | 1,475,682,095,848 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
geekgirl | 0 | 1,475,682,095,848 | 100% |
What do you do with CAH clone?
author | geekgirl |
---|---|
permlink | qgf7ih |
category | python |
json_metadata | {"app":"hiveblog/0.1"} |
created | 2020-09-10 02:13:30 |
last_update | 2020-09-10 02:13:30 |
depth | 2 |
children | 3 |
last_payout | 2020-09-17 02:13:30 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.013 HBD |
curator_payout_value | 0.013 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 30 |
author_reputation | 1,215,196,225,598,670 |
root_title | "Connecting to PostgreSQL database and making queries within Python code." |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 99,546,308 |
net_rshares | 162,044,645,024 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
edicted | 0 | 162,044,645,024 | 6% |
Oh it's going to be an on-chain dapp. Players will provably own their unique cards by sending 1 HBD to @null. This is also how one farms governance tokens, that are used for a variety of game-related voting activities (like adding cards to the whitelist for example). It's kinda complicated but simple at the same time. I think I pretty much have the tokenomic logic all figured out at this point. Although no one really seems excited about it when I explain it so... who knows.
author | edicted |
---|---|
permlink | re-geekgirl-qgf7ql |
category | python |
json_metadata | {"tags":["python"],"app":"peakd/2020.09.1"} |
created | 2020-09-10 02:18:24 |
last_update | 2020-09-10 02:18:24 |
depth | 3 |
children | 2 |
last_payout | 2020-09-17 02:18:24 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.066 HBD |
curator_payout_value | 0.067 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 486 |
author_reputation | 2,890,242,526,660,396 |
root_title | "Connecting to PostgreSQL database and making queries within Python code." |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 99,546,381 |
net_rshares | 725,278,418,033 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
geekgirl | 0 | 725,278,418,033 | 50% |
I am learning about web security and ethical hacking. Though I am now in primary level , I am enjoying to much it. I use kali linux to learn it.Today I have learned about ddos and protection ddos. Its amazing.
author | ibrahim51 | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
permlink | qgge28 | ||||||||||||||||||
category | python | ||||||||||||||||||
json_metadata | {"app":"hiveblog/0.1"} | ||||||||||||||||||
created | 2020-09-10 17:32:36 | ||||||||||||||||||
last_update | 2020-09-10 17:32:36 | ||||||||||||||||||
depth | 1 | ||||||||||||||||||
children | 0 | ||||||||||||||||||
last_payout | 2020-09-17 17:32:36 | ||||||||||||||||||
cashout_time | 1969-12-31 23:59:59 | ||||||||||||||||||
total_payout_value | 0.048 HBD | ||||||||||||||||||
curator_payout_value | 0.051 HBD | ||||||||||||||||||
pending_payout_value | 0.000 HBD | ||||||||||||||||||
promoted | 0.000 HBD | ||||||||||||||||||
body_length | 209 | ||||||||||||||||||
author_reputation | 790,476,549,652 | ||||||||||||||||||
root_title | "Connecting to PostgreSQL database and making queries within Python code." | ||||||||||||||||||
beneficiaries |
| ||||||||||||||||||
max_accepted_payout | 1,000,000.000 HBD | ||||||||||||||||||
percent_hbd | 10,000 | ||||||||||||||||||
post_id | 99,557,099 | ||||||||||||||||||
net_rshares | 586,533,661,733 | ||||||||||||||||||
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
geekgirl | 0 | 586,533,661,733 | 40% |
https://twitter.com/geekjen/status/1303871437778821120
author | poshbot |
---|---|
permlink | re-connecting-to-postgresql-database-and-making-queries-within-python-code-20200910t014235z |
category | python |
json_metadata | "{"app": "beem/0.24.8"}" |
created | 2020-09-10 01:42:36 |
last_update | 2020-09-10 01:42:36 |
depth | 1 |
children | 0 |
last_payout | 2020-09-17 01:42:36 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 54 |
author_reputation | 5,554,335,374,496 |
root_title | "Connecting to PostgreSQL database and making queries within Python code." |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 99,545,923 |
net_rshares | 0 |