Discover and read the best of Twitter Threads about #Stoic
Most recents (17)
1. “You have power over your mind - not outside events. Realize this, and you will find strength”
2. “When you arise in the morning, think of what a precious privilege it is to be alive, to breathe, to think, to enjoy, to love”
Is this helpful?
.
.
.
.
.
.
.
#wisdom #philosophy
#richardfeynman #oscarwilde #terencemckenna #dostoevsky #virginiawoolf #carljung #sorenkierkegaard #stoicism #stoic #stoicphilosophy #friedrichnietzsche #seneca #marcusaurelius #epictetus #live #growthmindset #philosopher
.
.
.
.
.
.
.
#wisdom #philosophy
#richardfeynman #oscarwilde #terencemckenna #dostoevsky #virginiawoolf #carljung #sorenkierkegaard #stoicism #stoic #stoicphilosophy #friedrichnietzsche #seneca #marcusaurelius #epictetus #live #growthmindset #philosopher
Now that we have a pretty good idea of what the UI will look like, let's focus on the runtime side of things, especially when data gets too large to fit within a single host (2 TB on a host with 4 TB of RAM). In other words, how will the distributed query planner work?
The assumption is that source data is partitioned as a set of Parquet files (with or without Iceberg). From there, if your query is map-reducible, you can use @DuckDB's COMBINE to map it on a fleet of Lambdas, then reduce it on an EC2 VM. That's what #STOIC does today.
Things start getting more complicated if you have a SELECT within a FROM clause, a HAVING clause, or inner queries (correlated or uncorrelated). Let's review these scenarios one by one.
Rules of engagement: this Twitter account is my personal account. I use it to liberally share many of the things that we do at #STOIC. While this leaks some of our IP, I tend to think that we gain more than we lose by doing so, because it helps us engage with the community.
I use my long threads to capture my stream of consciousness. Writing my ideas down helps me think them through, even if nobody reads them on the other end. This makes for a very painful account to follow, and most followers end up tuning out eventually, but I don't mind.
Here is how #STOIC intends to use this feature. Obviously, there are many applications for a native SQL parser/serializer, but this particular one might give you some ideas for your own projects.
Here is a screenshot of our current UI. For us, SELECT is a transform that can be used in a data journey to generate a new table, either directly from an import, or downstream of other transforms.
Right now, the parameters of this transform (the clauses of the SELECT statement) must be coded by hand. This is fine if you're a SQL expert, but this is a non-starter if you're a casual Excel user. We want our product to be usable by both. The latter needs something more.
Public announcement: if your company is using @DuckDB, you should consider sponsoring @DuckDBLabs (these folks are great to work with). And if you do and your needs are aligned with #STOIC's, we should have a chat about priorities and design requirements.
If we pool resources together, we might be able to fund things that would be out of reach for #STOIC on its own, or will take a lot longer to develop, for lack of sufficient resources.
And for the record, 100% of the @DuckDBLabs work funded by #STOIC goes straight to the open source codebase, and we have no intentions of changing that anytime soon.
One of #STOIC's most useful features is its signature Summary Charts, which are these bar charts displayed at the top of every column in a table. They work really well, unless your table has very few rows. Here is how we'll improve them for some interesting corner cases.
Relative Baseline in Bar Plots
When a table has less than 50 rows, we replace the Histogram displayed for a numerical column with a Bar Plot visualizing discrete values, but we keep 0 as baseline. We should use MIN or MAX instead, as we do for cell summaries below.
When a table has less than 50 rows, we replace the Histogram displayed for a numerical column with a Bar Plot visualizing discrete values, but we keep 0 as baseline. We should use MIN or MAX instead, as we do for cell summaries below.
Bar Plot with All Equal Values
When a Bar Plot is produced for a set of values that are all equal, we would want to know that at a glance. To do so, the length of bars will be reduced by 50%, while keeping the plot horizontally centered.
When a Bar Plot is produced for a set of values that are all equal, we would want to know that at a glance. To do so, the length of bars will be reduced by 50%, while keeping the plot horizontally centered.
This thread introduced the SQL vs. Tabula discussion. This other thread will cover our SQL query designer. This tool will focus on @duckdb's SQL dialect, but it will be designed to work with virtually any SQL cloud database (@SnowflakeDB, @databricks, etc).
There are many ways to design a SQL query designer, and to design a good one, two critical questions must be answered first: who is the audience, and what is their working environment?
For #STOIC, we must serve two very different user groups:
1. Users who are new to SQL
2. Users who are SQL experts
1. Users who are new to SQL
2. Users who are SQL experts
The implementation of our new SELECT transform triggered many fascinating discussions at #STOIC. Among them, one was trying to answer the following question: should we encourage users to use SELECT as much as possible, or should we steer them toward simpler Tabula transforms?
For reference purposes, here are Tabula transforms:
By design, Tabula transforms are easier to use and easier to distribute. On the flip side, SQL is an industry standard, and much, much more powerful from a functional and semantic standpoint. But it's also much more difficult to use, and very challenging to distribute.
Now that we have tested all TPC-H queries with our new SELECT transform powered by @duckdb, let's review how #STOIC will produce high-fidelity results for these query results.
One of the most critical design elements that make #STOIC work the way it does is its rich data typing system (Principia Data): each and every column is defined with a precise datatype, which conditions how it is serialized, processed, and analyzed.
stoic.com/principia/data…
stoic.com/principia/data…
Question for SQL experts: #STOIC has a much richer typing system than @duckdb. Therefore, when we create a column like "revenue", we want to type it (Number) and give it a full name (Total Revenue). What would be the best way to add that information directly in the SQL code?
To be clear, we need a solution that would be compatible with @duckdb's SQL parser and would be as idiomatic as possible. Otherwise, we'll have to invent our own syntax and do some pre-processing. That's always an option, but I'd like to avoid it if possible.
1️⃣ Focus on what’s up to you. Ignore what is not.
2️⃣ Review your conduct each evening.
1/6) It is important to remember that without modern medicine, many in the ancient world endured chronic conditions that today we could treat. Seneca suffered from asthma and described how it informed his Stoic views on mortality:
"I have been dealt one illness in particular..
"I have been dealt one illness in particular..
2/6) .."The Greeks call it 'asthma' but it is adequately described as 'laboured breathing'. Attacks usually last an hour or so - can you imagine drawing your final breath for that long? I have been visited by all types of physical pain but none are more distressing than this"..
3/6) .."With other ailments you might get sick but with this one you are losing your very soul's breath. For this reason doctors call asthma a 'rehearsal for death'. Even when an attack ends I can't rejoice: you don't win this legal case, you just postpone the day of the trial"..
#gratitude thread 1/12
“Appreciation is a wonderful thing. It makes what is excellent in others belong to us as well.” Voltaire
#grateful for classics @CIIS_SF
“Appreciation is a wonderful thing. It makes what is excellent in others belong to us as well.” Voltaire
#grateful for classics @CIIS_SF
#gratitude thread 2/12
“When eating fruit, remember the one who planted the tree.” Vietnamese Proverb @BreneBrown
@grateful for cultures
“When eating fruit, remember the one who planted the tree.” Vietnamese Proverb @BreneBrown
@grateful for cultures
#gratitude thread 3/12
“Got no checkbooks, got no banks, still I’d like to express my thanks. I got the sun in the morning and the moon at night.” Irving Berlin @PolarisInsight
#grateful for music
“Got no checkbooks, got no banks, still I’d like to express my thanks. I got the sun in the morning and the moon at night.” Irving Berlin @PolarisInsight
#grateful for music
Ok fellow Stoics...let's engage a little.
What is your favorite #Stoic quote?
Drop it in the comments below. 👇
#Stoicism
What is your favorite #Stoic quote?
Drop it in the comments below. 👇
#Stoicism
My favorite is this one from Marcus.
It distills Stoicism down to three basic practices to follow:
-Objectivity
-Unselfishness
-Acceptance
It distills Stoicism down to three basic practices to follow:
-Objectivity
-Unselfishness
-Acceptance
Would love to hear if any of the experts, writers, and translators of Stoicism have favorite Stoic quotes/passages:
@mpigliucci
@DonJRobertson
@aristofontes
@SharonLebell
@mpigliucci
@DonJRobertson
@aristofontes
@SharonLebell
I’m a big fan of #Stoicism and it’s teachings have helped to bring objectivity, tranquility, and mental fortitude into my life.
Of the #Stoic writings, #Meditations by Marcus Aurelius is my favorite.
Here is a collection of favorite passages from Meditations:
//Thread// 👇🏼
Of the #Stoic writings, #Meditations by Marcus Aurelius is my favorite.
Here is a collection of favorite passages from Meditations:
//Thread// 👇🏼
“To welcome with affection what is sent by fate. 3.16“
A powerful passage on accepting your past and present. I repeat this one a lot when circumstances have not unfolded to my liking.
A powerful passage on accepting your past and present. I repeat this one a lot when circumstances have not unfolded to my liking.
“Choose not to be harmed--and you won't feel harmed. Don't feel harmed--and you haven't been.” 4.7
We cannot control circumstances, but we can control how we choose to respond.
We cannot control circumstances, but we can control how we choose to respond.
