{"tag":{"id":"56744723958ef13879b953ed","name":"SQL","logo":"https://res.cloudinary.com/hashnode/image/upload/v1501338352/cv7owxtxvr39rjzxoolr.png","slug":"sql","tagline":"SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.","__typename":"Tag"},"publication":{"__typename":"Publication","id":"6252671992d73e7055c190e3","url":"https://engineering.cloudflight.io","canonicalURL":"https://engineering.cloudflight.io","urlPattern":"SIMPLE","title":"Cloudflight Engineering Blog","displayTitle":"","hasBadges":false,"descriptionSEO":"","publicMembers":{"totalDocuments":40,"__typename":"PublicationMemberConnection"},"about":null,"features":{"proTeam":{"isEnabled":false,"__typename":"ProTeamFeature"},"newsletter":{"isEnabled":true,"__typename":"NewsletterFeature"},"viewCount":{"isEnabled":false,"__typename":"ViewCountFeature"},"readTime":{"isEnabled":true,"__typename":"ReadTimeFeature"},"textSelectionSharer":{"isEnabled":true,"__typename":"TextSelectionSharerFeature"},"customCSS":{"isEnabled":false,"published":null,"draft":null,"__typename":"CustomCSSFeature"},"gptBotCrawling":{"__typename":"GPTBotCrawlingFeature","isEnabled":false},"__typename":"PublicationFeatures"},"metaTags":"","ogMetaData":{"image":"https://cdn.hashnode.com/res/hashnode/image/upload/v1651840792170/3Au3iZj74.png","__typename":"OpenGraphMetaData"},"author":{"__typename":"User","id":"62b9a85bf2e6c7d70c123ad6","name":"Stefan Starke","username":"StrongSteve","profilePicture":"https://cdn.hashnode.com/res/hashnode/image/upload/v1698763187393/L4UcHj1bZ.JPG"},"preferences":{"__typename":"Preferences","logo":"https://cdn.hashnode.com/res/hashnode/image/upload/v1651840848260/Lykf4cLJC.png","darkMode":{"__typename":"DarkModePreferences","logo":"https://cdn.hashnode.com/res/hashnode/image/upload/v1651840852727/XzG7w0VZc.png","enabled":null},"navbarItems":[{"__typename":"PublicationNavbarItem","id":"6500a425703e32bdbc1d2f6b","label":"Rapid Web Development","url":"https://engineering.cloudflight.io/series/rapid-web","type":"series","series":{"__typename":"Series","id":"64f0984c35a62a6b74560c11"},"page":null},{"__typename":"PublicationNavbarItem","id":"628643747b02ca162edae878","label":"About Cloudflight","url":"https://www.cloudflight.io/","type":"link","series":null,"page":null},{"__typename":"PublicationNavbarItem","id":"628643627b02ca162edae874","label":"Work with us","url":"https://www.cloudflight.io/en/career/","type":"link","series":null,"page":null}],"enabledPages":{"__typename":"PagesPreferences","badges":false,"newsletter":true,"members":false},"layout":"grid","disableFooterBranding":false,"isSubscriptionModalDisabled":false},"favicon":"https://cdn.hashnode.com/res/hashnode/image/upload/v1649574989932/0NdzQLvSr.png","headerColor":"#1345F0","integrations":{"fbPixelID":"","fathomSiteID":"","fathomCustomDomainEnabled":null,"fathomCustomDomain":"","hotjarSiteID":"","matomoSiteID":null,"matomoURL":"","gaTrackingID":"","gTagManagerID":null,"plausibleAnalyticsEnabled":null,"wmPaymentPointer":"","koalaPublicKey":null,"msClarityID":null,"__typename":"PublicationIntegrations"},"imprintV2":{"__typename":"Content","html":"

Cloudflight processes personal data in accordance its privacy policy. The Cloudflight Engineering Blog uses Hashnode as its blogging platform, therefore Hashnode's privacy policy (also linked in the footer), applies to all processing of personal data related to your visit to this blog.

\n"},"postsCount":{"totalDocuments":40,"__typename":"PublicationPostConnection"},"isTeam":true,"links":{"twitter":"https://twitter.com/Cloudflightio","instagram":"https://www.instagram.com/cloudflight.official/","github":"https://github.com/cloudflightio","website":"https://cloudflight.io","hashnode":"","youtube":"https://www.youtube.com/channel/UCv76x8wyiMrZtam6VgCTSNw","dailydev":"","linkedin":"https://www.linkedin.com/company/cloudflight/mycompany/","mastodon":null,"facebook":null,"bluesky":null,"__typename":"PublicationLinks"},"domainInfo":{"__typename":"DomainInfo","hashnodeSubdomain":"cloudflight","domain":{"__typename":"DomainStatus","host":"engineering.cloudflight.io","ready":true},"wwwPrefixedDomain":null},"redirectionRules":[],"totalRecommendedPublications":0,"sponsorship":{"content":null,"stripe":null,"__typename":"PublicationSponsorship"},"allowContributorEdits":true,"posts":{"edges":[{"node":{"__typename":"Post","id":"65ccf1c95c0dca7d3d7bd9db","title":"Lakehouse: Securing data access","slug":"lakehouse-securing-data-access","publishedAt":"2024-02-14T17:00:57.903Z","cuid":"clsm1giwf00030ajvdr9e3q8i","url":"https://engineering.cloudflight.io/lakehouse-securing-data-access","subtitle":"Hands on blog on how to safeguard your most valuable assets","brief":"In this article, we'll delve into best practices for securing data access when using Microsoft Fabric Lakehouses. The goal is ensuring that your valuable data remains protected and enable people from within your organization to see subsets of the dat...","readTimeInMinutes":8,"views":1072,"author":{"__typename":"User","id":"62b9a85bf2e6c7d70c123ad6","username":"StrongSteve","name":"Stefan Starke","profilePicture":"https://cdn.hashnode.com/res/hashnode/image/upload/v1698763187393/L4UcHj1bZ.JPG","followersCount":0},"coverImage":{"__typename":"PostCoverImage","url":"https://cdn.hashnode.com/res/hashnode/image/stock/unsplash/zAjdgNXsMeg/upload/32320fa851265f378d27a89bf686d796.jpeg","isPortrait":false,"isAttributionHidden":false}},"cursor":"NjVjY2YxYzk1YzBkY2E3ZDNkN2JkOWRiXzIwMjQtMDItMTRUMTc6MDA6NTcuOTAzWg==","__typename":"PostEdge"},{"node":{"__typename":"Post","id":"62b1d01094003a788976e243","title":"Hibernate Optimistic locking with Spring Boot","slug":"hibernate-optimistic-locking-with-spring-boot","publishedAt":"2022-06-21T14:05:04.166Z","cuid":"cl4o8nnm7016xhbnv3dlhhpi1","url":"https://engineering.cloudflight.io/hibernate-optimistic-locking-with-spring-boot","subtitle":"showing two cases: 1. concurrent database transactions & 2. concurrent long (UI) conversations","brief":"Optimistic locking is a concept to avoid concurrent changes on the same data. To be more precise: It's not about preventing concurrent changes (this would be pessimistic locking), but to allow and detect those changes happening at the same time and a...","readTimeInMinutes":6,"views":16118,"author":{"__typename":"User","id":"62a5e4e24754a2eb1e0a5e0e","username":"HaraldVogl","name":"Harald Vogl","profilePicture":"https://cdn.hashnode.com/res/hashnode/image/upload/v1655039204896/GU0SjsFsC.png","followersCount":0},"coverImage":null},"cursor":"NjJiMWQwMTA5NDAwM2E3ODg5NzZlMjQzXzIwMjItMDYtMjFUMTQ6MDU6MDQuMTY2Wg==","__typename":"PostEdge"},{"node":{"__typename":"Post","id":"6299bb3b2869cf1c237547ac","title":"How to track changes, stay agile and sane at the same time","slug":"how-to-track-changes-stay-agile-and-sane-at-the-same-time","publishedAt":"2022-06-03T07:41:47.658Z","cuid":"cl3y51fg200ninunv8t152vpe","url":"https://engineering.cloudflight.io/how-to-track-changes-stay-agile-and-sane-at-the-same-time","subtitle":"A fight with and about changes in MariaDB","brief":"The Intro\nWelcome! If you are a software developer you might have encountered similar feats to what I am about to describe. Maybe you wondered if you really found the best solution. I will put code (SQL, Kotlin) only in the chapter about The Fight. I...","readTimeInMinutes":9,"views":324,"author":{"__typename":"User","id":"628ba83bb4bd016fc9a2eca3","username":"seywerth","name":"Raphael Seywerth","profilePicture":"https://cdn.hashnode.com/res/hashnode/image/upload/v1653320461387/2R3uiOuG8.jpeg","followersCount":0},"coverImage":{"__typename":"PostCoverImage","url":"https://cdn.hashnode.com/res/hashnode/image/upload/v1654201523974/V29J-mh_n.jpg","isPortrait":false,"isAttributionHidden":false}},"cursor":"NjI5OWJiM2IyODY5Y2YxYzIzNzU0N2FjXzIwMjItMDYtMDNUMDc6NDE6NDcuNjU4Wg==","__typename":"PostEdge"},{"node":{"__typename":"Post","id":"6284b17083966a1653f12051","title":"DB-Lock-Issues with Transactional REQUIRES_NEW — More Spring/Java transaction handling pitfalls","slug":"db-lock-issues-with-transactional-requires-new","publishedAt":"2022-05-18T08:42:03.000Z","cuid":"cl3bc5r0c048ty3nv6sae2j2y","url":"https://engineering.cloudflight.io/db-lock-issues-with-transactional-requires-new","subtitle":"","brief":"If you haven’t read it yet, it’s probably a good idea to read part 1 of this post-series first.\nFrom now on we’ll assume that we remember roughly what part 1 was about. As a refresher, here’s one of the main points again:\n\nWhat is Propagation.REQUIRE...","readTimeInMinutes":9,"views":228,"author":{"__typename":"User","id":"626fa1a277f8e2f7fe9346b5","username":"Paukl","name":"Paul Klingelhuber","profilePicture":"https://cdn.hashnode.com/res/hashnode/image/upload/v1651662094538/poemyqptm.png","followersCount":1},"coverImage":{"__typename":"PostCoverImage","url":"https://cdn.hashnode.com/res/hashnode/image/unsplash/8yYAaguVDgY/upload/v1652783746276/pzzhU9goG.jpeg","isPortrait":false,"isAttributionHidden":false}},"cursor":"NjI4NGIxNzA4Mzk2NmExNjUzZjEyMDUxXzIwMjItMDUtMThUMDg6NDI6MDMuMDAwWg==","__typename":"PostEdge"},{"node":{"__typename":"Post","id":"62837d2c83966a1653f10017","title":"Transactional REQUIRES_NEW considered harmful — Spring/Java transaction handling pitfalls","slug":"transactional-requires-new-considered-harmful","publishedAt":"2022-03-07T09:44:01.000Z","cuid":"cl3a16ano009ry3nvb0y24whh","url":"https://engineering.cloudflight.io/transactional-requires-new-considered-harmful","subtitle":"","brief":"Databases and Transactions are great, Spring is great, Kotlin/Java are great (ofc. Kotlin is better 😉), simplifying transaction-handling is great. But as we all know, simplifying things almost always creates some new pitfalls if the things that were...","readTimeInMinutes":7,"views":249,"author":{"__typename":"User","id":"626fa1a277f8e2f7fe9346b5","username":"Paukl","name":"Paul Klingelhuber","profilePicture":"https://cdn.hashnode.com/res/hashnode/image/upload/v1651662094538/poemyqptm.png","followersCount":1},"coverImage":{"__typename":"PostCoverImage","url":"https://cdn.hashnode.com/res/hashnode/image/upload/v1652782734076/_MzV00GiH.png","isPortrait":false,"isAttributionHidden":false}},"cursor":"NjI4MzdkMmM4Mzk2NmExNjUzZjEwMDE3XzIwMjItMDMtMDdUMDk6NDQ6MDEuMDAwWg==","__typename":"PostEdge"}],"pageInfo":{"endCursor":"NjI4MzdkMmM4Mzk2NmExNjUzZjEwMDE3XzIwMjItMDMtMDdUMDk6NDQ6MDEuMDAwWg==","hasNextPage":false,"__typename":"PageInfo"},"__typename":"PublicationPostConnection"}}}