Remove articles do-we-need-data-normalization-anymore
article thumbnail

NULL complexities – Part 1

SQL Performance

NULL handling is one of the trickier aspects of data modeling and data manipulation with SQL. Even among people who do have a good grasp of relational theory and SQL, you will hear very strong opinions both in favor and against using NULLs in your database. This article is the first in a series about NULL complexities.

article thumbnail

How To Migrate From jQuery To Next.js

Smashing Magazine

The possibility of extending and manipulating the DOM that the library offers is great, and we also have many plugins to add behavior to our pages in case we need to do tasks that aren’t supported by the jQuery main library. Let’s discuss how we could stop using jQuery and migrate our website into a React or Next.js

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Fundamentals of Table Expressions, Part 11 – Views, Modification Considerations

SQL Performance

This article is the eleventh part in a series about table expressions. In this article, I focus on modification considerations. As you probably know, you’re allowed to modify data in base tables indirectly through named table expressions like views. Sample Data. You can control modification permissions against views.

Servers 130
article thumbnail

Automating Website Deployments Through Buddy

Smashing Magazine

This is a sponsored article.) How can we avoid getting overwhelmed by the complexity of the task at hand? By automating all the tasks to execute, we will not dread doing the deployment (and having a trembling sweaty finger when pressing the Enter button), indeed we may not be even aware of it. Leonardo Losoviz.

Website 82
article thumbnail

Building The SSG I’ve Always Wanted: An 11ty, Vite And JAM Sandwich

Smashing Magazine

I don’t know about you, but I’ve been overwhelmed by all the web development tools we have these days. Whether you like Markdown, plain HTML, React, Vue, Svelte, Pug templates, Handlebars, Vibranium — you can probably mix it up with some CMS data and get a nice static site cocktail. Need an animated image carousel?

Website 93
article thumbnail

HTTP/3: Performance Improvements (Part 2)

Smashing Magazine

In part 1, we looked at why exactly we need HTTP/3 and the underlying QUIC protocol, and what their main new features are. In this second part, we will zoom in on the performance improvements that QUIC and HTTP/3 bring to the table for web-page loading. HTTP/3 performance features ( current article ).

article thumbnail

I Used The Web For A Day On A 50 MB Budget

Smashing Magazine

This article is part of a series in which I attempt to use the web under various constraints, representing a given demographic of user. I hope to raise the profile of difficulties faced by real people, which are avoidable if we design and develop in a way that is sympathetic to their needs. Just how expensive are we talking?

Cache 96