If you have to switch between two minor versions i.e.

version 2 or version 3 then they will be installed in different directories on your PC.

If you have to switch between two major versions of python i.e.

There are two basic conditions for updating python in your operating system. Let’s get to know that how to update python in Windows, Mac, and Linux, if you are already working with Python and want an upgraded version Requirement for Updating Python Working with the updated versions of python is more fun because it comes with more libraries for advanced programming. Once everything works properly you should be able to replace the contents of the SQLCommand variable and run any SQL queries as needed.As you all know, Python is the new trend in the world of computer programming.

Run the script to confirm that python script is working properly, connects to HiveSQL and returns the correct data. Server, database, uid, and pwd information will be sent by Within SQLCommand variable will contain our SQL query commands. We use ODBC Driver 17 for SQL Server for the driver. SELECT delegator, delegatee, vesting_shares, timestamp import pyodbcĬonnection = nnect('Driver= '

The following is a sample script to test if we can properly connect to HiveSQL and get data back. Now we are ready to use HiveSQL within our python scripts. You may need to use pip, pip3, or pip3.8 command depending on the version of the python you are using.

Lastly, we need to pip install pyodbc module.

And run the following to install the driver:.

Open the terminal and run the following command to install the homebrew:.

Now, we can install necessary drivers and dependencies on our mac machine. The information contained in the memo will be server url, database name, login user name, and a password. Since the memo will be encrypted, to see the memo the wallet need to accessed with a memo key. will automatically send back a transfer with an encrypted memo that will contain information needed to access the database. To get access the database, you will need to transfer 0.01 HBD to account. To use HiveSQL you will need to get login credentials to access the database. Now that HiveSQL is funded by Decentralized Hive Fund this service is free. HiveSQL is an awesome SQL database service created and maintained by It makes getting data from Hive blockchain fast and easy. This is a short tutorial on how to get started with using HiveSQL in python scripts on a Mac computer.

Using python on mac