Skip to content

Tutorial: unfriendly use of BigQuery #408

Description

@justjake

Hello,

I just tried going through the tutorial. I've never used Colab before, and was really surprised when it asked to log into my Google account. I gave it permission, but I still can't run any of the cells. I've never worked with Google cloud stuff before.

It would be great if the tutorial is set up to use Postgres or SQLite - something that will work out of the box with no login or creating cloud resources. There's one cell using SQLite but I don't know if there's a way to change all the cells.

Thanks!

Activity

  1. EvgSkv commented on Nov 23, 2024

    @EvgSkv
    Owner

    That's a good point. For some time I was thinking to switch to DuckDB by default (which will also run on colab with no setup). The plan it to give potential users time to adjust or object and likely to switch in January.

    Meanwhile here is a copy of tutorial that uses SQLite for main cells:
    https://colab.research.google.com/drive/1PCtrlDPPKeITOG9296irVY6xoNzjkZUW?usp=sharing

    Thank you for feedback and please let me know if you have further questions!

  2. justjake commented on Nov 25, 2024

    @justjake
    Author

    Thanks for making the SQLite colab. Is there a way to run these offline? I'm going to be on a plane tomorrow and want to learn Logica. I'll give your notebook a shot on plane wifi but just curious if there's a local option.

    Beyond the tutorial is there a reference for the syntax or available operators? I tried figuring it out by reading the source but it's too much to learn both the codebase and the language at the same time while also turning my logic programming brain back on 😅

  3. EvgSkv commented on Dec 1, 2024

    @EvgSkv
    Owner

    Apologies for delay. In case you still wonder how to run it offline, it's quite easy -- just download the colab, with this menu option:
    image

    Then you can install standard python notebook:

    python3 -m install jupyter
    

    Run it from the folder where the downloaded colab is as:

    python3 -m notebook
    

    And you'll be able to open it and run.

    Let me know if you have further questions!

  4. EvgSkv commented on Jan 14, 2025

    @EvgSkv
    Owner

    Main branch and default tutorial are switched to DuckDB by default.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions