Tweets Analysis - Keyword: @rakyll
Overview
Total number of tweets analysed
205
Earliest tweet was on
2023-02-12
Latest tweet was on
2023-02-22
Tweets covering
10 days
Average age of authors' accounts
11 years
Summarization
Rakyll, an author, has tweeted about Postgres and relational databases, and their related operational semantics, scalability, and performance. He argues that Postgres is a great option for startup companies, but that more specialized and scalable solutions come into play at the larger scale. He speaks of building a custom database and the inner source model, and speaks well of the CockroachDB Postgres alternative. Furthermore, he calls out Firestore as an unreliable solution, and preaches against seeking silver bullets and building cargo cults.
Topic Modeling
- Postgres
- Scale
- Software Development
- Security (2FA)
- Database Solutions (Postgres, Firestore, CockroachDB)
Emotional Analysis
The emotions expressed in these tweets are mostly positive, with some occasional negative sentiments. The tweets are largely focused on discussing the benefits and drawbacks of Postgres and other databases, with a few tweets focusing on the difficulties of coding and other technical tasks. The majority of tweets express a sense of enthusiasm and optimism, such as when discussing the potential of Postgres and other databases, and the positive sentiment is further reinforced by the admiration for the work of @rakyll. However, there are also some negative emotions expressed in the tweets, such as frustration at the difficulty of coding and annoyance at the use of SMS 2FA.
Trend Analysis
- MySQL and Postgres operational semantics
- Startup company scale
- Embedding files into a Go executable
- Using specialized databases for time series data
- Stateless services
Types of Tweets
Number of Retweets
29
Percentage of total tweets
14%
Number of Original tweets
1
Percentage of total tweets
0%
Number of tweets that contain Mentions
205
Percentage of total tweets
100%
Number of tweets that were Replies
175
Percentage of total tweets
85%
Number of tweets that were Quotes
6
Percentage of total tweets
2%
Number of tweets that contain Hashtags
9
Percentage of total tweets
4%
Top 5 devices used to tweet
| Source | Count |
|---|---|
| Twitter Web App | 84 |
| Twitter for iPhone | 74 |
| Twitter for Android | 43 |
| TweetDeck Web App | 1 |
| GolangRandomRepo | 1 |
What devices were used to tweet
Top 10 accounts with highest followers count
| Username | Name | Bio | Followers count |
|---|---|---|---|
| halvarflake | Halvar Flake | I do math. And was once asked by R. Morris Sr. : "For whom?"@halvarflake@mastodon.socialAt the moment, for https://t.co/5M6zUDAVM0 | 40,980 |
| bryanl | Bryan Liles | If you having code problems, I feel bad for you son. I got 99 problems and a compiler ain’t one. | 35,777 |
| forrestbrazeal | Forrest Brazeal | Cloud bard at @google, author, cartoonist, and Pwnie Award-winning songwriter. Ex-AWS Hero. Here to help. Mastodon: https://t.co/pls4YgUvwk | 31,271 |
| GolangRepos | Awesome Go Repositories | Half bot, half human tweeting random Go Repositories from Github.Feel free to contribute! | 21,580 |
| UdiDahan | Udi Dahan | Tweets about Software Development, Design, and Architecture. Founder and CEO of NServiceBus. He/Him. Won't speak on all-male panels. @udidahan@hachyderm.io | 18,067 |
| SPXTrades | SPX Trader | Short term SPX/ES/NQ Trader. Every time your gut tells you to call the bottom or the top, do the opposite. Politically No Longer Liberal 😢 | 15,980 |
| tobias_petry | Tobias_Petry.sql | The Database Guy. I share database knowledge, tips and performance optimizations to improve your applications. Open for consulting.Building: @stackbricksapp | 13,481 |
| joncalhoun | Jon Calhoun | Panelist on @GoTimeFM • Teaching #golang • Want to learn Go with fun exercises? Try https://t.co/qYoY2xodvd and https://t.co/3cASkPfN2z | 8,406 |
| mlstotts | Matthew Stotts (🌊,🌲) | Investing in Earth-scale technologies for climate impact, sustainability and regeneration. #StopAsianHate Слава Україні 🇺🇦 @_AidForUkraine | 7,064 |
| ewindisch | Erica Windisch | i broke your cloud. retro gaming/computing. founder. hacker. fight back against transphobia. teach lgbt history in schools. | 7,050 |
Top 10 accounts with highest friends count
| Username | Name | Bio | Followers count |
|---|---|---|---|
| mlstotts | Matthew Stotts (🌊,🌲) | Investing in Earth-scale technologies for climate impact, sustainability and regeneration. #StopAsianHate Слава Україні 🇺🇦 @_AidForUkraine | 5,925 |
| cjwilburn | Courtney Wilburn | Sr. Engineering Manager @elastic Cloud. 💍of @215kate. Dog mom of @ourdudespencer. Lifelong Prince fan. Powerlifter. opinions = mine. she/her | 4,963 |
| saviour123 | saviour | Just a brain driving a muscle coated skeleton through time on a gigantic space rock. Systems#Cloud#infrastructure📖Bible Student | SRE | 3,467 |
| nebiyu | Nebiyu Yohannes | You know, walk the earth, meet people... get into adventures. Like Caine from Kung Fu | 3,364 |
| FreXxX | Chief Exotic - Digital Tomorrow Göd (💉💉💉) | Audiosexual. Metal. I void warranties. Sancho-ol-holic. Camera Otaku, professional Pessimist. Works in #ADAS. #keinfussbreit #blacklivesmatter He/him. | 2,974 |
| corneil | Corneil du Plessis. @corneil@hachyderm.io | OSS Engineer @SpringCloud at @VMwareTanzu, speaker (only diverse panels), organizer @JoziJUG, scientific skeptic, BLM. 🇺🇦 Opinions are my own. #nocrypto | 2,943 |
| ArucyLionel | Lionel Arucy | Techpreneur and all round Geek in all things eccentric, love music, movies and gaming | 2,819 |
| tylerhannan | tylerhannan | Distributed Systems. Music. ClickHouse formerly Macrometa, Hasura, Fauna, Elastic, Basho, etc. Ik woon in Amsterdam. | 2,553 |
| thebsdbox | Dan 🐝 | Conjurer of cheap tricks 🧙🏼 https://t.co/M75l5knbhD && @kube_vip Past: @Heptio, @Docker, @EquinixMetal, @HPE | 2,468 |
| halvarflake | Halvar Flake | I do math. And was once asked by R. Morris Sr. : "For whom?"@halvarflake@mastodon.socialAt the moment, for https://t.co/5M6zUDAVM0 | 2,337 |
Most active users
| Username | Bio | Number of tweets |
|---|---|---|
| valyala | CTO @ VictoriaMetrics | 8 |
| ovaistariq | Co-Founder & CEO @tigrisdata | Database and Open source enthusiast | Non-conformist | Formerly, Head of Storage @ Uber. | 5 |
| sadisticsystems | @Spacejam@mastodon.social there are trillions of diarrhea particles on every keyboard. making graph go brrrrr @memgraphdb | 4 |
| FreXxX | Audiosexual. Metal. I void warranties. Sancho-ol-holic. Camera Otaku, professional Pessimist. Works in #ADAS. #keinfussbreit #blacklivesmatter He/him. | 3 |
| tylerhannan | Distributed Systems. Music. ClickHouse formerly Macrometa, Hasura, Fauna, Elastic, Basho, etc. Ik woon in Amsterdam. | 3 |
| _mikeusa | Programmer • Data Analyst • Food Enthusiast • Opinions are my own • He/him | 3 |
| _Felipe | Software Engineer @VoltronData. (prev. C++ @Spotify Client Core). 🇧🇷 → 🇸🇪 → 🌎 https://t.co/MWfkSLyTkb 🐘 https://t.co/8hjFoQqnMh | 3 |
| mholt6 | Imperfect member of the restored Church of Jesus Christ. Husband. Created @caddyserver. M.S. Comp Sci. | 3 |
| nhumrich | DevX aficionado. Python Hacker. Continuous Delivery addict. Building https://t.co/bHV236h5ye | 3 |
| Jonny_Waffles | Pythonista, avid gamer, esports enthusist, big ol nerd. Self taught full stack developer. @mrwaffles@fosstodon.org | 2 |
Tweets per day
Top 10 tweets with highest Retweet count
| ID | Text | Retweet count |
|---|---|---|
| 1627619068458024961 | statik: Embed files into a Go executable⭐️ 3559Author: @rakyll#golanghttps://t.co/hXn2NGgeQa | 4 |
| 1626865497810542593 | @rakyll Haha so true. Postgres is the foundation of the software industry, it's just so reliable and powerful, and gets you so far before you hit its limitations. | 2 |
| 1626402634008756224 | @rakyll "It's the current version" = "524 bugs remaining before alpha release, 47 of them critical" "This is legacy code" = "it's the version in production that makes money" "It's post-MVP" = "we'll never ship this" | 2 |
| 1626679672976158722 | @rakyll Most startup companies are worried about scale, that probably in the first few years I could host their service on my Mac :) | 1 |
| 1628088115805007886 | For example, I can't say enough good things about @rakyll's https://t.co/6j2ORe2jGY | 1 |
| 1625939006176329728 | @rakyll Like if you rely on another HTTP API for... well, anything. | 1 |
| 1626711131057451010 | @rakyll Despite being better in some areas than MySQL, Postgres operational semantics around replication, upgrades, and backups were very bad until quite recently. I’d probably choose to use Postgres to start something new, but 10 years ago, not so much. | 1 |
| 1626687183875723278 | @rakyll Is there anyone still getting around Postgres? 😂 | 0 |
| 1626685033049104387 | @rakyll It DoES nOt ScALe BeCAUsE iT HAs JOInS | 0 |
| 1626676749449965568 | @rakyll Awww yissssss | 0 |
Top 10 tweets with highest Like count
| ID | Text | Like count |
|---|---|---|
| 1626711131057451010 | @rakyll Despite being better in some areas than MySQL, Postgres operational semantics around replication, upgrades, and backups were very bad until quite recently. I’d probably choose to use Postgres to start something new, but 10 years ago, not so much. | 45 |
| 1626679672976158722 | @rakyll Most startup companies are worried about scale, that probably in the first few years I could host their service on my Mac :) | 38 |
| 1626685033049104387 | @rakyll It DoES nOt ScALe BeCAUsE iT HAs JOInS | 27 |
| 1626781836860080129 | @rakyll Postgres is great but once you reach billions dollar mark you end up migrating to a more scalable solution like my last employer did https://t.co/AB0z1qA6Dt | 26 |
| 1627619068458024961 | statik: Embed files into a Go executable⭐️ 3559Author: @rakyll#golanghttps://t.co/hXn2NGgeQa | 20 |
| 1626656418828001285 | @rakyll Nahhh, you build your own database, if really serious, you build the hardware as well to run the database on 😊 | 16 |
| 1626446645541089284 | @rakyll Perf review: "What'd you deliver?" > improved foundational services "That's not flashy though" > neither is everything imploding "But that other dept has big whizbang feature" > these fundamental systems allowed that feature to be delivered .... sooo .... 🤨 | 13 |
| 1626771800180002816 | @rakyll While PostgreSQL is great, it is much better to use specialized databases for big volumes of time series data - @ClickHouseDB and @VictoriaMetrics . They can store and process multiple orders of magnitude more data than PostgreSQL on the same hardware at much higher speed. | 13 |
| 1625803248757088257 | @rakyll Most people who think that they are making stateless services are usually just making extremely inconsistent ad-hoc databases. Some degree of state is inherent in anything interesting, and while it's a choice to avoid considering it, it just pushes that consideration onto others. | 10 |
| 1628088115805007886 | For example, I can't say enough good things about @rakyll's https://t.co/6j2ORe2jGY | 9 |
Top 3 Languages Used In Tweets
Top 10 Hashtags used
| Hashtag | Count |
|---|---|
| #innersource | 1 |
| #truestory | 1 |
Top 10 Hashtags Used In Tweets
Top 10 mentions
| Mention | Count |
|---|---|
| @rakyll | 206 |
| @clickhousedb | 24 |
| @victoriametrics | 23 |
| @valyala | 14 |
| @reallyjeffevans | 9 |
| @badastronomer | 8 |
| @timescaledb | 7 |
| @mholt6 | 5 |
| @simonkalouche | 4 |
| @_mikeusa | 4 |
Top 10 mentions
Wordcloud of Tweets
Emojis
Average number of emojis used per tweet
8
Emojis used in tweets
| Emoji | Count | Emoji Text |
|---|---|---|
| ⭐ | 2 | star |
| 🤔 | 2 | thinking_face |
| 😉 | 1 | winking_face |
| 💯 | 1 | hundred_points |
| 🙌 | 1 | raising_hands |
| 😃 | 1 | grinning_face_with_big_eyes |
| 🧵 | 1 | thread |
| 👇 | 1 | backhand_index_pointing_down |
| 🧐 | 1 | face_with_monocle |
| 😂 | 1 | face_with_tears_of_joy |
Emojis groups
| Emoji Group | Count |
|---|---|
| Smileys & Emotion | 12 |
| Travel & Places | 2 |
| People & Body | 2 |
| Activities | 1 |