Creating Tables with PostgreSQL and TimescaleDB

Поделиться
HTML-код
  • Опубликовано: 14 ноя 2024

Комментарии • 37

  • @parttimelarry
    @parttimelarry  3 года назад +4

    I'm starting a new channel on AI at youtube.com/@parttimeai, please subscribe!
    Source Code: github.com/hackingthemarkets/ark-funds-tracker

  • @hectorniyan
    @hectorniyan 3 года назад +15

    I would like to give some very positive feedback. The content is absolutely amazing, it's fascinating and super relevant. The delivery is brilliant and, possibly most of all, Larry's cheerful manner and optimism is really uplifting in these terrible times. I love it and I look forward, every day, to engaging with this stuff. A huge “Thank You”.

  • @sophiepark3008
    @sophiepark3008 3 года назад

    This is THE best hands-on RUclips tutorial ever! Easy to follow and simple but covers every single part required. Very informative. Thanks much.

  • @yourpersonaldatadealer2239
    @yourpersonaldatadealer2239 3 года назад +4

    Three videos from the holy one in one day 🎉... you might need to change course and build a replacement for robinhood with everything that’s been going on haha

  • @DavidCVdev
    @DavidCVdev 3 года назад +5

    the ending was great

    • @Rickynator13
      @Rickynator13 3 года назад

      Larry Lopez lol had me rolling

  • @arnoldjettison9854
    @arnoldjettison9854 3 года назад

    Excellent!

  • @seanfranklin3555
    @seanfranklin3555 3 года назад

    LMAO nailed the outro. love the content on TimesScaleDB Larry. thank you

  • @johnrichardson1218
    @johnrichardson1218 3 года назад

    You deserve tons more views, doing God's work out here. The end Tai Lopez clip was awesome.

  • @retrofutur1st
    @retrofutur1st 3 года назад

    Absolutely brilliant

  • @grizthegriffdog9939
    @grizthegriffdog9939 3 года назад +8

    "and little did he know at the time, python data analysis text in hand; LittlePTLarry was gave away the greatest weapon in the history of mankind. Knowledge."

  • @jimmy0552
    @jimmy0552 3 года назад

    Love your videos.

  • @sanjaybhatikar
    @sanjaybhatikar 2 года назад

    Thanks, Larry! The blog post you refer to about SQL tutorial is no longer available. Have you taken it down? Grateful for your response. Cheers!

  • @kannansingaravelu
    @kannansingaravelu Год назад

    Hey Larry! Great videos as always. Couple of questions - a) how to make the database / data persists so that we don’t lose the data; do we have to volume mount the postgresdb data? b) also how do we access the the database (from the container) outside of the host system, say if we want to access it from another laptop / desktop that may not be on the same network?

  • @detroiter4eva
    @detroiter4eva 3 года назад

    I love this guy. He's schooling the hell outta me.

  • @sourovghosh2843
    @sourovghosh2843 3 года назад

    Loving the videos keep it up - new sub here

  • @TuranInsight
    @TuranInsight 3 года назад +2

    in case u face this erroir while creating a hypertable: HINT: No function matches the given name and argument types. You might need to add explicit type casts. - U might need to " CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE; then create the hypertable- your welcome:)

  • @maestorm002
    @maestorm002 2 года назад +1

    Why do you have Python for data analysis in garage? :O I am confused.

  • @Icurous
    @Icurous 3 года назад

    nice helps a lot

  • @monkyspnk777
    @monkyspnk777 2 года назад

    At 4:35 you show a chart, can you post a video of the questions and decision free of mindset or thinking on how you make those?

  • @cryptolicious3738
    @cryptolicious3738 2 года назад

    larry, love the channel. the create_hypertable FAILS UNLESS u dont set id field w PRIMARY KEY. once i removed that from my ohlc table id....it worked. but why cant hypertable work on a table like a ohlc having a primary key ?

  • @tejasthakur123
    @tejasthakur123 Год назад

    Can you please make the ddl available for public ?

  • @IonPerpelea
    @IonPerpelea 3 года назад

    Command + R to refresh the tables in TablePlus.

  • @danielrv1325
    @danielrv1325 3 года назад

    Awesome video, I just have a question hope someone ones what I did wrong. At TablePlus I can't find the database 'etfdb' I think I followed everything not sure why I can't see it.

  • @vinodsahastrabuddhe9401
    @vinodsahastrabuddhe9401 3 года назад

    hey Larry, thanks for the video. Are you going create further video's using Alpaca only or do you have any plan to use IB broker also? Alpaca at the moment has lot restriction out side of US hence putting this question.

    • @parttimelarry
      @parttimelarry  3 года назад +2

      I will start using other data providers soon. Alpaca has been convenient since that's how a lot of people found this channel originally and it is free. I don't want to leave people out though, so will start doing more with Interactive Brokers and possibly IEX Cloud. At the same time, there are fees with many of these services and they have their own nuances which take time to explain/make videos on.

    • @vinodsahastrabuddhe9401
      @vinodsahastrabuddhe9401 3 года назад

      @@parttimelarry Thanks much appreciated. Mean time i can still use paper trading account from alpaca to follow the tutorials :)

  • @jessojohn9226
    @jessojohn9226 2 года назад

    hi larry eventhough i am creating database in docker container,I can't access it using psycopg2

  • @AppFanUAE
    @AppFanUAE 3 года назад

    thank you very much 😍, need little help here, when I am executing this: "Error: No such container: timescaledb"

    • @Frat333
      @Frat333 3 года назад

      just asking, did you create the extension? "CREATE EXTENSION TimeScaleDB"

  • @brianrowe1152
    @brianrowe1152 3 года назад

    Why are you pasting the SQL content into Postgres instead of using a python script like in other videos? Great stuff BTW. THX

  • @nicholasranieri8671
    @nicholasranieri8671 3 года назад

    the last 15 seconds hahahahahah

  • @ipkus4228
    @ipkus4228 3 года назад +1

    Great video! Thank you for the tutorial. I got Debian running fine in Docker, but when I enter "psql -U postgres" I get an error message: "Fatal error: role 'postgres' does not exist" or something to that effect. I made sure that I installed postgresql correctly and that postgres was the default username and they were, so I am not sure what I am doing wrong. Do you or anyone else on here have any ideas?

    • @aarondkat9036
      @aarondkat9036 3 года назад +2

      When you set up debian, before you even set up postgres or timescale create a new user with sudo permissions called postgres and assign it a password.

  • @elmar_bajora
    @elmar_bajora 3 года назад +2

    Holy shit dude, you keep redirecting me from one video to another and i keep jumping across your different videos to make one single project work. Now wtf is the docker O_o

  • @SniperUSMC
    @SniperUSMC 3 года назад

    You're giving your age away talking about phone books and dictionaries. LOL

  • @AK-gr5gi
    @AK-gr5gi 3 года назад

    q