0:00dug DB the inprocess allab database can
0:02run anywhere it supports multiple client
0:05languages and as today a significant
0:08portion of its usage come from Python
0:11and the dgdb CLI for some users the CLI
0:14can feel intim mediating especially if
0:16they prefer a user interface and let's
0:19be honest exploring data in the CLI can
0:22be
0:22cumbersome but dgdb in partnership with
0:25Mod duck just released a local dgdb UI
0:28so let's talk about how this can
0:30transform your local data exploration
0:32experience so to get started with DUI
0:34you can install the CLI there is a one
0:37command line curl that you can use if
0:39you're on Mac OS you can just do pro
0:41install dgdb and you have also other
0:44installation metod that I'll put in the
0:46description finally when you launch dgdb
0:49you can directly put
0:51dasi to launch DB UI what is happening
0:55behind the scene is that dug DB is
0:56installing and loading the dug DB UI
1:00extension dug DB has an extension
1:01mechanism for various things like
1:04reading over park or Iceberg and dug DB
1:07UI is one of it so a local web server
1:09has been launched and I can click on
1:11this link and I will get a local SQL
1:15notebook interface so we have four main
1:17areas in this UI the first one is here
1:20the catalog as you can see is pretty
1:23empty so you can run the example and
1:25here I'm going to create table based on
1:28a remote Park file you see now my table
1:31is created and if I click on it I'm
1:34going to have the second area of the UI
1:37which is the table Explorer this giv me
1:39direct information about each of the
1:42columns I can directly see what's the
1:44latest earliest date of this data set
1:47and various other Matrix on other type
1:50of column I can of course click and
1:52attach a local or remote database which
1:54just the path so here for example I'm
1:56attaching another database over uh I
2:00believe it's three and you see now I
2:01have the remote station database added
2:04with the station table and again I can
2:06click and see through the table Explorer
2:09so let's go a bit over the SQL notebook
2:11you can create multiple notebook name it
2:14and it will be stored locally you can
2:16expect all the fancy shortcut that you
2:18would have in any do book so if I do
2:21select mandin as stck I want to run this
2:24one I do command enter I can create
2:27other cell and of course you the arrow
2:30key to switch but cell I can toggle
2:33command by doing command slash and it's
2:36a toggle into a SQL command and of
2:39course we load stuff from the cloud but
2:42it works really fast with local file so
2:45here I'm going to create a table and you
2:48see I have auto complete on the command
2:50iur use as select command from a local
2:54parket file which is in the current
2:57directory so this parket file is
2:59actually almost 10 GB of data so now
3:02it's over there let's look at the table
3:04Explorer you see we have
3:0642.7 millions rows and so now if I'm
3:10exploring this data set a bit let's do
3:12100,000 lines for example you see that I
3:15have the nice UI where I can uh display
3:19which colon I want to display sort it
3:21out and I have also the colon Explorer
3:24which is based on the result of my query
3:26so you see here I can see I have a bit
3:29of sample from data up to 2008 and up to
3:33the latest of uh April 2024 and of
3:37course if you want to Crunch the data
3:39against search a data set it also super
3:42fast here I'm extracting the top uh
3:45domain shared on acar news from uh 2016
3:49to
3:512025 uh that's the data set and you see
3:54in less than a seconds I'm processing
3:56over more than 40 millions of Bros and
3:59getting the top domains which is get up
4:01then YouTube then medium.com as often
4:03articles that being shared on acur news
4:05finally you may have seen this button
4:07here right there which is sign on to
4:10Mother dock if you already have an
4:11account and you click there you can sign
4:13up and now you still have the local UI
4:16but as you can see you have access to
4:19all your Cloud database the one are are
4:21shared so for example you can start uh
4:23create the sample data which is database
4:26that any Modoc user get access to with a
4:29couple sample of data from acur new
4:31stock overflow or New York city so let's
4:34say if I'm quiry this database and the
4:36New York City service complaint to run
4:38and see what is the most complaint uh
4:41from New York City service and I see
4:43it's like heat hot water uh and the
4:46second is the noise all of that now
4:48leveraging the cloud compute and the
4:50cloud storage still using the same UI
4:52all right that's it's a smooth powerful
4:54and easy way to explore data locally
4:57with wbui if you have any feature
5:00request you can head over the gith up
5:02repository and in the meantime keep
5:04clacking and keep coding in the UI
5:09[Music]
