Explore tweets tagged as #ModernSQL
@ModernSQL @EdwinFLopez hi @MarkusWinand , I don't understand your statement "if you use SQL for CRUD operations only, you are doing it wrong". Why? In OLTP systems, I use SQL as the interface to use a DBMS to make a System of Record. What am I missing?
1
0
0
#FabConEurope Session - Maximizing Productivity in #FabricData Warehouse: Harnessing the Power of #ModernSQL experiences Charles Webb and Dharini Sundaram will cover a comprehensive range of the latest experiences that empower the SQL developer. https://t.co/OHNwCb4A9B
0
1
3
@ModernSQL @gilliusprog @ohmypy Science says that lowercase is easier to read than uppercase. I also like to format my SQL as below so that it takes fewer lines and there is a 'gutter' that separates the right aligned keywords from 'my content'.
0
0
0
This example uses the power horse of the functions that parse JSON in SQL: JSON_TABLE.
2
0
2
New episode: "Modern SQL" Michael is joined by @MarkusWinand, creator of https://t.co/3ZtBAGyYV0 and https://t.co/JZ4c3O0FMr, to discuss @ModernSQL — what it means, why it matters, and a phrase that should be on a t-shirt. 🎧 https://t.co/Bg2Wxiu4TI 📺 https://t.co/pSGhCfxe6k
1
12
75
@ModernSQL Sorry but this is not true. E.g. in Db2 the string_units configuration parameter defaults to OCTETS. If you want 255 characters you have to use CODEUNITS32.
2
0
0
@ModernSQL Because of this tweet, I want do a "10 things a db does and you didn't know" talk, starting with soft deletes. What other 9 features would you recommend to include? Thanks. https://t.co/psg4u9gz9A
1
0
1
@ModernSQL The WITH clause (in SQL query) enables to define a temporary table to use in consecutive request Is there a kind of WITH clause for defining a kind of *scalar* parameter, like an integer or a float ? Thanks
1
0
0
@ModernSQL It's something that's missing IMHO Yes, one can do without (such feature), but it would improve request clarity
0
0
0
@ModernSQL Is there a way to propose some feature for a newer SQL version as a SQL non-expert ? Thanks
0
0
0
구현하는데에 30년 걸림
UNION, EXCEPT and INTERSECT — the three set operators defined in the SQL standard — since SQL-92. October 2022: One of the most popular SQL engines finally learned about INTERSECT & EXCEPT. MySQL in its 8.0.31 release. Pictured: EXCEPT DISTINCT https://t.co/4MeCX6FEbG
0
18
40
@ModernSQL TiDB gets it right too: mysql> SELECT (SELECT sum(a) FROM xx LIMIT 1) FROM aa; +---------------------------------+ | (SELECT sum(a) FROM xx LIMIT 1) | +---------------------------------+ | 6 | +---------------------------------+ 1 row in set (0.00
0
0
2
I just added @ModernSQL to @PlanetMysqlComT, sorry I did not do this earlier, it should have been there for a while. https://t.co/sutMpXrF4F
0
2
8
@ModernSQL Thanks, but which article. I only see your post claiming the number is characters and not bytes😃
1
0
0
Think SQL is outdated? Think again. The future of database querying is fast, flexible & built for 2025. Powered by developers, for developers. #NoLimits
#TechRevolution #FutureOfData #CQL2025 #DevelopersLife
#ModernSQL #ScalableTech #RealTimeData #AIIntegration
#CloudComputing
1
0
1
