rakyll - Tweet Data Analysis
Tweets Analysis - Keyword: @rakyll
Published March 9, 2023
Overview
Tweets covering
10 days
Latest tweet was on
2023-02-22
Earliest tweet was on
2023-02-12
Total number of tweets analysed
205
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
Disclaimer: The text analysis on twtdata.com, powered by OpenAI, does not represent the views of twtdata.com or its affiliates. The analysis is for informational purposes only and not an endorsement of any viewpoint.
Types of Tweets
Number of Retweets
29
14% of total
Number of Original tweets
1
0% of total
Number of tweets that were Quotes
6
2% of total
Number of tweets that were Replies
175
85% of total
Number of tweets that contain Hashtags
9
4% of total
Number of tweets that contain Mentions
205
100% of total
Devices Used to Tweet
Top 5 Devices
| Source | Count |
|---|---|
| Twitter Web App | 84 |
| Twitter for iPhone | 74 |
| Twitter for Android | 43 |
| TweetDeck Web App | 1 |
| GolangRandomRepo | 1 |
Device Distribution
Top 10 Accounts by Followers
| 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 by Friends
| 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 by Retweets
| 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 … | 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 … | 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 by Likes
| 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 … | 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 … | 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 … | 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 … | 10 |
| 1628088115805007886 | For example, I can't say enough good things about @rakyll's https://t.co/6j2ORe2jGY | 9 |
Top Languages Used
Top 10 Hashtags
| Hashtag | Count |
|---|---|
| #innersource | 1 |
| #truestory | 1 |
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 |
Wordcloud of Tweets
Emoji Analysis
Average emojis per tweet:
8
Emojis Used
| 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 |
Emoji Groups
| Emoji Group | Count |
|---|---|
| Smileys & Emotion | 12 |
| Travel & Places | 2 |
| People & Body | 2 |
| Activities | 1 |
Need Custom Twitter Data Analysis?
Get detailed insights on any keyword, hashtag, or account with twtData.
Get Started