Tutorial: unfriendly use of BigQuery

[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!

[EvgSkv]

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!

[justjake]

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 😅

[EvgSkv]

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:

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!