rakyll - Tweet Data Analysis
Tweets Analysis - Keyword: @rakyll
2023年3月9日に公開
概要
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
要約
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.
トピックモデリング
- Postgres
- Scale
- Software Development
- Security (2FA)
- Database Solutions (Postgres, Firestore, CockroachDB)
感情分析
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.
トレンド分析
- MySQL and Postgres operational semantics
- Startup company scale
- Embedding files into a Go executable
- Using specialized databases for time series data
- Stateless services
免責事項：twtdata.comのテキスト分析はOpenAIを使用しており、twtdata.comまたはその関連会社の見解を代表するものではありません。分析は情報提供のみを目的としており、いかなる見解の支持でもありません。
ツイートの種類
Number of Retweets
29
全体の14%
Number of Original tweets
1
全体の0%
Number of tweets that were Quotes
6
全体の2%
Number of tweets that were Replies
175
全体の85%
Number of tweets that contain Hashtags
9
全体の4%
Number of tweets that contain Mentions
205
全体の100%
ツイートに使用されたデバイス
トップ5デバイス
| Source | Count |
|---|---|
| Twitter Web App | 84 |
| Twitter for iPhone | 74 |
| Twitter for Android | 43 |
| TweetDeck Web App | 1 |
| GolangRandomRepo | 1 |
デバイス分布
フォロワー数上位10アカウント
| Username | Name | Bio | Followers count |
|---|---|---|---|
| halvarflake | Halvar Flake | I do math. And was once asked by R. Morris Sr. : "For whom?"@[email protected] 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. @[email protected] | 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 |
フォロー数上位10アカウント
| 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. @[email protected] | 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?"@[email protected] the moment, for https://t.co/5M6zUDAVM0 | 2,337 |
最もアクティブなユーザー
| 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 | @[email protected] 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. @[email protected] | 2 |
日別ツイート数
リツイート数上位10ツイート
| 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 |
いいね数上位10ツイート
| 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 |
使用されている上位言語
トップ10ハッシュタグ
| Hashtag | Count |
|---|---|
| #innersource | 1 |
| #truestory | 1 |
トップ10メンション
| Mention | Count |
|---|---|
| @rakyll | 206 |
| @clickhousedb | 24 |
| @victoriametrics | 23 |
| @valyala | 14 |
| @reallyjeffevans | 9 |
| @badastronomer | 8 |
| @timescaledb | 7 |
| @mholt6 | 5 |
| @simonkalouche | 4 |
| @_mikeusa | 4 |
ツイートのワードクラウド
絵文字分析
ツイートあたりの平均絵文字数:
8
使用された絵文字
| 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 Group | Count |
|---|---|
| Smileys & Emotion | 12 |
| Travel & Places | 2 |
| People & Body | 2 |
| Activities | 1 |
カスタムTwitterデータ分析が必要ですか？
twtDataで任意のキーワード、ハッシュタグ、アカウントの詳細なインサイトを取得しましょう。
始めましょう