Andrew Sherman 🇺🇦 @andrii_sherman Twitter profile

Last Seen Profiles

@yearlzy

@sirbradpinnacle

@Om_8rnen

@IrlLillie

@saki_p04

@etoiaes

@CoachJeffMonken

@MigrationCollab

@JohnKen91692931

@edgarallenhoe99

@stw_pdg

@Cdog159528

@kuma_shinsai

@aine_laur84466

@eXvolution_

@popperssklave

@m_navaramos

@sammyj0333

@s_ichi10

@bokeplokalmalam

@ScarpantiPCO29

@Thagoodteddaaa

@ice_blockchain

@simjaeyungirlie

@naerchan

@Taty_057

@SHIBUYA_T_MUSIC

@bits_center

@HELLSPRlNCESSS

@stw_pdg

@meowchoso

@the_a_factor

@BundhaSri

@Gpt3000_ai

@rajamaka

@tillfourd_1941

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

SQL is easy

69

752

5K

Andrew Sherman 🇺🇦

@andrii_sherman

10 months

Storing JSON in SQL Database is completely fine

Nile

@niledatabase

10 months

9

22

258

76

119

3K

Andrew Sherman 🇺🇦

@andrii_sherman

11 months

127

366

3K

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

Don’t store images in database, please

194

136

2K

Andrew Sherman 🇺🇦

@andrii_sherman

3 months

in case you forgot

51

77

2K

Andrew Sherman 🇺🇦

@andrii_sherman

2 years

25

179

916

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

There was a time (4 years ago) when I wrote my first post on Medium about git commit hooks and was searching for a 'hook' on Unsplash. I found this one and used it. It took me 2 weeks to understand why everyone in the office was laughing at me

29

44

900

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

Yesterday, I saw drizzle in the job requirements for a full-stack position. I applied and got rejected because of a lack of drizzle knowledge

37

29

734

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

Working remotely is the worst thing you can do to yourself

378

45

663

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

Don't mock your database calls for unit testing, please

69

52

591

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

This thread is about the hardest decision in my life that I wanted to make for a long time, and finally, I did it. I've finally come back home to Ukraine, Dnipro, and it means I won't have a possibility to leave my country

31

13

514

Andrew Sherman 🇺🇦

@andrii_sherman

5 months

It's not the first time @t3dotgg has donated to Ukraine. One of these donations was made during one of our charity streams. As we tend to say in Ukraine, 'There are no small donations; even $1 matters.' Theo sent $1000 for a single mistake in a video and talked about it to a

Theo - t3.gg

@t3dotgg

5 months

I made a mistake in my last video, and I want to make it right. I referred to Ukraine as "The Ukraine". I had no idea that "The Ukraine" was used to describe Ukraine as part of Russia, not as an independent nation. It's not much, but I like to put my money where my mouth is.

147

43

3K

3

8

435

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

Is it just me, or is the JS dates(and timezone) API just unusable?

68

8

423

Andrew Sherman 🇺🇦

@andrii_sherman

7 months

I quit my job to start working on Drizzle full-time. It's still not VC-backed(and will never be!), and we are still doing everything thanks to our great sponsors and our first successful B2B integrations. I'm not the first in our team to make this transition, and this decision

17

16

384

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

just in case

7

13

375

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

14

25

356

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

My first ratio, thx

9

2

345

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

SQLite is that friend who doesn't worry about a thing. He is just like, 'Don't worry, man.' Types? - I only have 5, and I don't care about others Foreign Keys? - You can create them but don't give them names. If you want to change them, recreate the table So far the easiest db

15

18

339

Andrew Sherman 🇺🇦

@andrii_sherman

10 days

Drizzle is becoming increasingly popular among many developers and companies in production. We are committed to demonstrating that Drizzle will be maintained for as long as possible The first step was to transition to full-time work on Drizzle, which I discussed nearly six

13

6

375

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

We've messed up with a few releases in a row, and I need to talk about it. Most of you may not have even noticed the problems we had for 2 days with Drizzle, simply because most of the time, you don't need to upgrade something right away. However, the 0.28.3 and 0.28.4 releases

22

12

282

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

Only 1% of all full stack developers are really full stack developers

48

9

265

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

Today I was fired from Drizzle Team. So looking for a job

Drizzle ORM

@DrizzleORM

1 year

@andrii_sherman

3

0

93

13

4

252

Andrew Sherman 🇺🇦

@andrii_sherman

1 month

So, some really exciting updates are coming to @DrizzleORM ! These include: 1. The updated @tursodatabase migration strategy and a major rewrite of SQLite migration generation, which are going live this week. 2. RLS support for PostgreSQL, which is awaiting merging into beta. 3.

23

20

248

Andrew Sherman 🇺🇦

@andrii_sherman

5 months

huge, thanks everyone!

6

5

236

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

Sounds like a plan

12

19

196

Andrew Sherman 🇺🇦

@andrii_sherman

1 month

3 months later

Andrew Sherman 🇺🇦

@andrii_sherman

5 months

huge, thanks everyone!

6

5

236

4

0

176

Andrew Sherman 🇺🇦

@andrii_sherman

9 months

3

1

174

Andrew Sherman 🇺🇦

@andrii_sherman

11 months

@hamsddxn seems like not

1

2

165

Andrew Sherman 🇺🇦

@andrii_sherman

3 months

Every time I see the Linear logo in the dock, I think, 'Does PlanetScale have a desktop app?'

4

3

164

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

Thanks @DrizzleORM to explain this on @neondatabase talk

7

155

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

Bringing database and backend work into a single TypeScript file is just as beneficial as developing a full-stack application in one language Some thoughts on that 🧵

2

14

150

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

you can argue, but it is true

14

3

147

Andrew Sherman 🇺🇦

@andrii_sherman

10 months

Just to be clear, I genuinely believe that using JSON in an SQL database is entirely acceptable. I'm using it frequently in my projects. While it has its specific use cases and shouldn't be applied universally, there are many instances where it proves to be highly beneficial

8

1

148

Andrew Sherman 🇺🇦

@andrii_sherman

1 month

Seems like it will be that easy after the next drizzle releases

10

3

144

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

I know you all are subscribing to my profile to read something about tech or drizzle. But Ukraine is a part of my life, and I just can't tell you how heartbreaking it is to read all of this news. I'll post more about it because everyone in the world should know about all the

10

7

137

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

It was easy

15

0

137

Andrew Sherman 🇺🇦

@andrii_sherman

4 months

We've fully migrated from Ava to @vitest_dev in drizzle-orm, drizzle-kit, and all plugin packages. We also fully rewrote the architecture and strategy for testing drizzle-orm with different driver packages, ensuring that all of them had a specific set of tests. This postponed

4

16

134

Andrew Sherman 🇺🇦

@andrii_sherman

16 days

Finally running the last pipelines for the next Drizzle release. It took quite a while because we were rewriting and restructuring the documentation, which took a month of work. In this release, we will go from 16% to 40% Also, this release took quite a long time, but the next

4

2

134

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

@james_r_perkins You can have several SQLite database files and store them in another database as blobs

5

130

Andrew Sherman 🇺🇦

@andrii_sherman

6 months

Finally 🥳 Shaved head in comments

Andrew Sherman 🇺🇦

@andrii_sherman

6 months

One of the tasks was due at the end of September, but I still intend to do what I promised. 10 stars to go

6

0

32

3

1

130

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

@lucca_dev I start 1 database and then clean the data for each test where it's required. Even for thousands of tests, the execution time remains minimal However, this approach is only suitable for integration tests. Unit tests should never involve testing external APIs such as databases

7

8

130

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

When you chose to use drizzle instead of prisma but then realized that SQL is not just a 'SELECT * FROM users'

8

3

129

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

I know that you are a senior dev if your commit messages look like "+" "fix"/"fixy"/"The Fixies" "cicd fix10" "??"

34

5

123

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

@glcst But it means those are not stored in database itself. It’s just one of a proper abstractions on how to manage images

3

1

119

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

Most of you may not know this, but @pnpmjs is maintained by the Ukrainian developer @ZoltanKochan , which is truly awesome! I am proud to see so many talented Ukrainians creating and maintaining open-source projects that everyone is using

Theo - t3.gg

@t3dotgg

1 year

So...I finally stopped using npm. Also made a video about it

45

12

311

5

6

122

Andrew Sherman 🇺🇦

@andrii_sherman

4 months

@ryanchenkie To be honest, I can agree with you. I personally dislike the relations API we have and prefer the table API, which can be improved and is also undergoing some transformations. The relations API is awful. When this feature was introduced, I started using it and found it difficult

6

0

121

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

Okay, let me explain why. As I mentioned in one of my previous replies: "I guess all the problems and disagreements stem from the fact that everyone treats remote work, office work, and all other types of work in very different ways." When I review the responses, it seems to be

78

5

116

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

Anthony Shew

@anthonysheww

1 year

Not only did @DrizzleOrm handle @vercel /postgres in 15 minutes, they made it take 4 lines of code. 😍

0

6

104

2

111

Andrew Sherman 🇺🇦

@andrii_sherman

4 months

A reminder to everyone who follows me that we are dealing with pure evil

Ihor Lachenkov

@igorlachenkov

4 months

Today russia hit "Ohmatdyt" children’s hospital with a rocket. The National Children's Specialized Hospital "Ohmatdyt" is the largest children's hospital in Ukraine, where more than 20,000 children from all over the country are treated every year.

2K

21K

22K

3

7

114

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

Waking up early, watching my beautiful wife sleep

3

109

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

@DrizzleOrm

1

109

Andrew Sherman 🇺🇦

@andrii_sherman

5 months

Beta release for drizzle-orm and kit was just published! 🎉Pg Vector support. Vector indexes, queries, functions and more 🎉 Updated PostgreSQL Indexes API - ❗️Breaking change 🎉Drizzle Kit now supports all fields from PostgreSQL indexes This release will have breaking changes

4

3

106

Andrew Sherman 🇺🇦

@andrii_sherman

1 month

If you're wondering whether you should stick with Drizzle and the team behind it, this might help you decide: I traded the beautiful city of Stockholm, with its amazing nature and high quality of life—where I had everything I could possibly need—for Dnipro, Ukraine. Dnipro has

9

1

107

Andrew Sherman 🇺🇦

@andrii_sherman

3 months

we'll merge it very soon

6

3

105

Andrew Sherman 🇺🇦

@andrii_sherman

10 months

Huge respect to @prisma team for both the support they giving us here and how much we can achieve thanks to everything they are doing and have done already

Prisma

@prisma

10 months

Friendly competition and debates are part of our dynamic, but supporting Ukraine is one area where we wholeheartedly agree with team @DrizzleORM - Please attend, learn and donate!

6

11

182

1

0

105

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

@nexxeln You mean bundle size?

8

1

103

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

I purchased the Premium subscription before 2k followers to remove any limitations for this post. In 2 weeks, I'll be celebrating my birthday, and for the past nearly 2 years, we have embraced a new tradition in Ukraine for receiving birthday gifts from well-wishers. As many of

2

15

101

Andrew Sherman 🇺🇦

@andrii_sherman

11 months

Is it better?

17

3

102

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

When you start working on a backend, do you prefer business logic first or database modeling first?

88

4

97

Andrew Sherman 🇺🇦

@andrii_sherman

1 month

thank you typescript

2

3

95

Andrew Sherman 🇺🇦

@andrii_sherman

2 years

Just bought a night light from @oven_sh unofficial merch and placed it on my desk It’s crazy, but my laptop starts to work 70% faster

2

5

93

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

2

91

Andrew Sherman 🇺🇦

@andrii_sherman

4 months

this is the proper way to use drizzle in your codebase

4

3

90

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

4

2

87

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

So we spent our entire budget on advertising, now we need to earn something

Drizzle ORM

@DrizzleORM

1 year

⭐️⭐️⭐️It's over 9000⭐️⭐️⭐️ Good time to finally drop our pricing - 🚀

24

8

308

3

1

83

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

It’s a real thing

9

7

83

Andrew Sherman 🇺🇦

@andrii_sherman

1 month

Huge respect to anyone who can write books, learning content, documentation, etc. That's especially hard We've already spent over two weeks rewriting parts of the Drizzle documentation, adding 'Get Started' sections and more, and it's so challenging to balance between not

5

0

84

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

@vmod__ I'm not wasting it; I'm using it as a time to switch my head from work to home mode and vice versa

23

0

80

Andrew Sherman 🇺🇦

@andrii_sherman

7 months

Ernest Hemingway once wrote a three word short story

8

5

83

Andrew Sherman 🇺🇦

@andrii_sherman

6 months

7

1

82

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

small cheat sheet

4

3

81

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

Сoincidence? I don't think @shadcn @htmx_org

1

0

78

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

War can last a long time, and I'm not ready to just sit and wait for many years, living my life alone but seeking safety. I have the one-in-a-lifetime opportunity to make a life-changing decision. It's so sad to have such circumstances for this

2

0

80

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

2

1

74

Andrew Sherman 🇺🇦

@andrii_sherman

5 months

true

5

2

76

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

Drizzle ORM

@DrizzleORM

1 year

drizzle-orm @0 .27 and drizzle-kit @0 .19 are out 🎉🎉 You can now pull and push to SQLite and @tursodatabase 🚀 Checkout our release blog post -

8

9

134

6

1

72

Andrew Sherman 🇺🇦

@andrii_sherman

2 years

This is exactly what we are trying to say. Please, learn SQL. You’ll never be wrong on that You are right now in a year of libraries and companies(such as @planetscaledata ) that tries to teach you SQL together with offering great services and tools Use it wisely

Theo - t3.gg

@t3dotgg

2 years

LONG LIVE SQL - NEW VIDEO OUT NOW

6

5

76

4

71

Andrew Sherman 🇺🇦

@andrii_sherman

2 months

@thdxr We will fire our SMM manager

7

0

72

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

When I switched to the JS world after working in Java, I was so happy to see so many libraries and options available I hate it when I have only 1-2 choices to use and struggle with them I love being able to choose my stack for any new project I start working on

Theo - t3.gg

@t3dotgg

1 year

@joshbedo1 I promise you we made way less progress when we all were shipping rails

5

3

23

3

6

66

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

much better now

4

1

66

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

it was fast, so MSSQL soon

3

0

67

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

Script Raccoon

@scriptraccoon

1 year

Go to the official site of Drizzle ORM and scroll down to find out what other developers think about Drizzle ORM. 🤣 Thanks @yesdavidgray for pointing this out!

2

0

9

0

63

Andrew Sherman 🇺🇦

@andrii_sherman

6 months

#OSDT - Open Source Developer Thoughts This post is a place to share your experience working on anything and living in a war zone. My story will be about working from Ukraine War and open-source After being in Ukraine for 6 months after returning and getting back into a work

5

7

66

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

Was I scared to go back earlier? - Yes, very scared Am I still scared? - Yes, more than ever May I be killed? - Any time May/Should I go to war as a soldier? - Yes, at some point in time Am I regretful about my decision? - Not at all

1

0

63

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

Unique constraints are here

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

3

0

22

5

2

63

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

I'll shave my head if Drizzle gets 20k stars by the end of September

8

5

63

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

Sold

4

0

60

Andrew Sherman 🇺🇦

@andrii_sherman

4 months

who wants this?

2

62

Andrew Sherman 🇺🇦

@andrii_sherman

6 months

@chronark_ @DrizzleORM You can even do it this way, which is a bit more complex to write(still should be written once, but easier to use later), but it will be included in the drizzle-helpers package I'm doing the same, but also have tenantId, primary keys for tenant+table and more inside commonTable

4

1

61

Andrew Sherman 🇺🇦

@andrii_sherman

2 months

I know

2

0

61

Andrew Sherman 🇺🇦

@andrii_sherman

10 months

european/american mind can't comprehend this

Wasm3

@wasm3_engine

10 months

I regret to inform the community that since my own house was destroyed by russians who invaded my country, Wasm3 has entered a minimal maintenance phase.

65

978

4K

2

5

60

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

I know we will win, and I understand that we can achieve it only together. Yes, I could have made this decision earlier, but I never had this much confidence in my decision as I do now. I needed this amount of time, and I'm glad I finally have it

1

0

61

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

When they said “open source is easy”

2

3

59

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

If you see PRs taking a while to review, even if they seem good, it's because we're spending a lot of time making a better API for specific situations. For example, today, @_alexblokh , @bloberenober , and I spent three hours live discussing just one option for configuring

4

2

58

Andrew Sherman 🇺🇦

@andrii_sherman

6 months

I’ll sponsor Ukraine tour

ThePrimeagen

@ThePrimeagen

6 months

unironically thinking about this.... if you wish to sponsor a euro tour let me know :)

41

5

526

7

5

59

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

All the time, I continued to work for a Ukrainian company and never wanted to change it. I was consistently donating more than half of my salary and posting about it on Instagram. However, it quickly turned into a feeling that I can do more but can only do it from Ukraine

1

0

58

Andrew Sherman 🇺🇦

@andrii_sherman

7 months

Almost all data API bugs were fixed in this release As promised, @SST_dev , we are on it

Release 0.30.8 · drizzle-team/drizzle-orm

🎉 Added custom schema support to enums in Postgres (fixes #669 via #2048): ⚠️ Only available in drizzle-orm for now, drizzle-kit support will arrive soon import { pgSchema } from 'drizzle-or...

github.com

4

2

57

Andrew Sherman 🇺🇦

@andrii_sherman

1 year

Just sitting here, browsing @Cloudflare D1 from @DrizzleORM Studio