Connect External Database – Hummingbot Foundation



Hummingbot stores trades in a local SQLite for database by default, but it may be limiting for some cases such as sharing data to external system, in some cases user may want to use their own preferred client/server RDBMS for it.

Other RDBMS are supported on Hummingbot through SQLAlchemy, it has included some widely used RDBMS dialects, i.e.:

  • PostgreSQL
  • MySQL
  • Oracle
  • Microsoft SQL Server

These dialects requires separate DBAPI driver to be installed on Hummingbot’s conda environment, see SQLAlchemy documentation for more information on appropriate DBAPI driver for each RDBMS. For example, to use PostgreSQL, psycopg2 need to be installed. Run the following command to install it using conda:

To configure RDBMS connection, we need to edit conf_global.yml in /conf directory.

- Advanced database options, currently supports SQLAlchemy's included dialects
- Reference: https://docs.sqlalchemy.org/en/13/dialects/

db_engine: sqlite
db_host: 127.0.0.1
db_port: '3306'
db_username: username
db_password: password
db_name: dbname

Configuration parameters

Configuration Parameter Possible Values
db_engine sqlite,postgres,mysql,oracle,mssql
db_host any string e.g. 127.0.0.1
db_port any string e.g. 3306
db_username any string e.g. username
db_password any string e.g. password
db_name any string e.g. dbname

SQLAlchemy dialects

It is also possible to connect with available SQLAlchemy’s external dialects (e.g. Amazon Redshift). But the feature is not currently supported in Hummingbot due to its various DSN format, use this at your own risk.


Last update:
2021-12-15

This Post Has 245 Comments

  1. I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.

  2. Rastrear Celular

    Desde que haja uma rede, a gravação remota em tempo real pode ser realizada sem instalação de hardware especial.

  3. Rastrear Celular

    Quando você esquecer a senha para bloquear a tela, se você não inserir a senha correta, será difícil desbloquear e obter acesso. Se você achar que seu namorado / namorada suspeita, você pode ter pensado em hackear o telefone Samsung dele para obter mais evidências. Aqui, iremos fornecer-lhe a melhor solução para descobrir a palavra-passe do telemóvel Samsung.

  4. I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.

  5. Donaldfaurb

    medicine in mexico pharmacies
    http://cmqpharma.com/# mexican drugstore online
    reputable mexican pharmacies online

  6. StephenMic

    mexican online pharmacies prescription drugs: online mexican pharmacy – buying prescription drugs in mexico

  7. Michaelcom

    purple pharmacy mexico price list
    http://cmqpharma.com/# mexico drug stores pharmacies
    mexico drug stores pharmacies

  8. Henryrit

    pharmacies in mexico that ship to usa: cmq pharma – mexican online pharmacies prescription drugs

  9. CharlesIrric

    best online pharmacy india [url=http://indiapharmast.com/#]top 10 online pharmacy in india[/url] indianpharmacy com

  10. DavidViery

    mexican pharmacy: mexican pharmacy – mexican border pharmacies shipping to usa

  11. CharlesIrric

    best online canadian pharmacy [url=http://canadapharmast.com/#]online pharmacy canada[/url] safe online pharmacies in canada

  12. CharlesIrric

    indianpharmacy com [url=https://indiapharmast.com/#]pharmacy website india[/url] indian pharmacy paypal

  13. MichaelEMOMS

    best online pharmacy india: india pharmacy – indianpharmacy com

  14. CharlesIrric

    india pharmacy mail order [url=https://indiapharmast.com/#]online pharmacy india[/url] reputable indian online pharmacy

  15. MyronNal

    https://clomiddelivery.pro/# can i get clomid
    can i buy generic clomid online [url=https://clomiddelivery.pro/#]where can i buy clomid without insurance[/url] can you buy cheap clomid without rx

  16. MyronNal

    https://paxloviddelivery.pro/# buy paxlovid online
    amoxicillin azithromycin [url=https://amoxildelivery.pro/#]amoxicillin 500 mg brand name[/url] amoxicillin buy canada

  17. JamesRob

    cheapest 40 mg doxycycline: doxycycline 500mg – doxycycline 100mg online pharmacy

  18. MyronNal

    http://doxycyclinedelivery.pro/# buy doxycycline 100 mg tablet
    п»їcipro generic [url=http://ciprodelivery.pro/#]cipro online no prescription in the usa[/url] cipro online no prescription in the usa

  19. MyronNal

    https://ciprodelivery.pro/# ciprofloxacin over the counter
    paxlovid generic [url=http://paxloviddelivery.pro/#]Paxlovid buy online[/url] paxlovid covid

  20. MyronNal

    http://doxycyclinedelivery.pro/# cheap doxycycline online uk
    purchase amoxicillin online [url=http://amoxildelivery.pro/#]amoxicillin 500mg buy online uk[/url] order amoxicillin no prescription

  21. MyronNal

    https://amoxildelivery.pro/# amoxicillin 875 125 mg tab
    how to buy clomid [url=http://clomiddelivery.pro/#]where to buy generic clomid now[/url] can you buy cheap clomid

  22. MyronNal

    https://clomiddelivery.pro/# how to get generic clomid no prescription
    paxlovid india [url=http://paxloviddelivery.pro/#]paxlovid for sale[/url] Paxlovid buy online

  23. MyronNal

    http://amoxildelivery.pro/# buy amoxicillin canada
    cipro online no prescription in the usa [url=https://ciprodelivery.pro/#]purchase cipro[/url] ciprofloxacin generic price

  24. JamesRob

    п»їpaxlovid: paxlovid pill – paxlovid cost without insurance

  25. DominicLeddy

    п»їbest mexican online pharmacies: mexican rx online – mexico drug stores pharmacies

  26. Arnolddub

    medicine in mexico pharmacies [url=https://mexicandeliverypharma.com/#]buying prescription drugs in mexico[/url] purple pharmacy mexico price list

  27. Arnolddub

    pharmacies in mexico that ship to usa [url=http://mexicandeliverypharma.com/#]best online pharmacies in mexico[/url] buying prescription drugs in mexico online

  28. Arnolddub

    mexican online pharmacies prescription drugs [url=https://mexicandeliverypharma.online/#]mexico pharmacies prescription drugs[/url] buying prescription drugs in mexico online

  29. Nelsonpreet

    best online pharmacies in mexico: mexican rx online – mexico drug stores pharmacies

  30. Arnolddub

    mexican mail order pharmacies [url=https://mexicandeliverypharma.com/#]mexico drug stores pharmacies[/url] mexican mail order pharmacies

  31. Arnolddub

    mexican online pharmacies prescription drugs [url=https://mexicandeliverypharma.online/#]mexico drug stores pharmacies[/url] mexican border pharmacies shipping to usa

  32. Your point of view caught my eye and was very interesting. Thanks. I have a question for you.

  33. Arnolddub

    best online pharmacies in mexico [url=http://mexicandeliverypharma.com/#]mexican pharmaceuticals online[/url] mexican online pharmacies prescription drugs

  34. Arnolddub

    mexican pharmaceuticals online [url=https://mexicandeliverypharma.com/#]reputable mexican pharmacies online[/url] medication from mexico pharmacy

  35. Arnolddub

    mexican rx online [url=https://mexicandeliverypharma.online/#]mexican drugstore online[/url] best online pharmacies in mexico

  36. Arnolddub

    medicine in mexico pharmacies [url=http://mexicandeliverypharma.com/#]mexican pharmacy[/url] purple pharmacy mexico price list

  37. Arnolddub

    mexican drugstore online [url=http://mexicandeliverypharma.com/#]mexican pharmacy[/url] mexican rx online

  38. Arnolddub

    mexican drugstore online [url=https://mexicandeliverypharma.com/#]reputable mexican pharmacies online[/url] mexican rx online

  39. Arnolddub

    п»їbest mexican online pharmacies [url=https://mexicandeliverypharma.online/#]п»їbest mexican online pharmacies[/url] best online pharmacies in mexico

  40. Arnolddub

    reputable mexican pharmacies online [url=http://mexicandeliverypharma.com/#]mexican rx online[/url] mexico drug stores pharmacies

  41. Robertpoera

    zithromax 500 price [url=http://zithromaxbestprice.pro/#]how to get zithromax[/url] how to get zithromax online

  42. Robertpoera

    zithromax 250 mg pill [url=https://zithromaxbestprice.pro/#]generic zithromax medicine[/url] buy zithromax no prescription

  43. Robertpoera

    buy cytotec online [url=http://cytotecbestprice.pro/#]buy cytotec[/url] buy cytotec pills

  44. Matthewhex

    generic propecia without prescription: buying propecia – cost propecia without insurance

  45. Robertpoera

    buy zithromax [url=http://zithromaxbestprice.pro/#]zithromax 500mg[/url] buy generic zithromax online

  46. Matthewhex

    aromatase inhibitor tamoxifen: nolvadex pills – tamoxifen effectiveness

  47. Matthewhex

    prednisone pill: prednisone 5084 – over the counter prednisone pills

  48. RandyClimi

    acquisto farmaci con ricetta: Avanafil 50 mg – farmacia online senza ricetta

  49. TomasTwers

    dove acquistare viagra in modo sicuro: acquisto viagra – miglior sito dove acquistare viagra

  50. TomasTwers

    viagra generico in farmacia costo: viagra prezzo – viagra ordine telefonico

  51. Stephenkiz

    http://tadalafil.auction/# cialis with dapoxitine
    100 mg viagra lowest price [url=http://sildenafil.llc/#]Cheap Viagra 100mg[/url] viagra professional

  52. GeorgeNaw

    which one is better viagra or cialis: cheapest tadalafil – cialis soft tabs canada

  53. GeorgeNaw

    buying cialis online canadian order: cheapest tadalafil – buy cialis pay with paypal canada

  54. Stephenkiz

    https://sildenafil.llc/# free viagra
    viagra without a doctor prescription [url=https://sildenafil.llc/#]buy sildenafil online usa[/url] generic viagra without a doctor prescription

  55. DouglasWew

    reputable indian pharmacies: indian pharmacy – india online pharmacy

  56. DouglasWew

    buying prescription drugs in mexico online: mexico pharmacy win – buying prescription drugs in mexico

  57. JamesPhosy

    buy furosemide online: lasix pills – buy furosemide online

  58. Stanleyhub

    lisinopril tabs 88mg [url=http://lisinopril.guru/#]Buy Lisinopril 20 mg online[/url] lisinopril 250mg

  59. JamesPhosy

    cost of generic lipitor in canada: buy lipitor 20mg – lipitor brand name price

  60. Stanleyhub

    generic lasix [url=https://furosemide.win/#]furosemide online[/url] generic lasix

  61. JamesPhosy

    buy generic lipitor canada: lipitor buy – lipitor.com

  62. JamesPhosy

    zestril 5mg price in india: buy lisinopril – lisinopril tabs 40mg

  63. AnthonyBug

    canadian family pharmacy [url=http://easyrxcanada.com/#]maple leaf pharmacy in canada[/url] best canadian pharmacy to order from

  64. AnthonyBug

    canadian pharmacy [url=https://easyrxcanada.online/#]canadian pharmacy antibiotics[/url] canadianpharmacyworld com

  65. AnthonyBug

    canadian pharmacy 365 [url=http://easyrxcanada.com/#]canadadrugpharmacy com[/url] canadian valley pharmacy

  66. binance sign up bonus

    Your point of view caught my eye and was very interesting. Thanks. I have a question for you.

  67. abrir conta na binance

    Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me.

Leave a Reply