Percona

SEPTEMBER 1, 2023

Here, we first cover the basics of MySQL Triggers, and then we take a deeper dive, exploring their impact on memory usage and providing strategies to optimize MySQL server performance. However, they can also introduce performance bottlenecks, especially if poorly designed. What is a Trigger in MySQL?

Cache 60

Cache Database Games Healthcare 60

Percona

FEBRUARY 1, 2023

In PostgreSQL, you can use the different TOAST storage strategies by setting the “storage” attribute on a column. text, bytea), and “strategy” is one of the four TOAST storage strategies (PLAIN, EXTENDED, EXTERNAL, MAIN). EXTENDED strategy : This strategy allows both compression and out-of-line storage.

Storage 88

Storage Scalability Strategy Performance 88

IO River

NOVEMBER 2, 2023

Started years ago with a focus on cloud management, Terraform built a massive community around its open-source license–up until two weeks ago, but more on that later. ‍Unlike CloudFormation, which was confined to AWS resources, Terraform was designed with a multi-cloud approach in mind. ‍Why Manage Infrastructure by Code?

Open Source 52

Open Source DevOps AWS Infrastructure 52

Smashing Magazine

APRIL 28, 2021

Image optimization , loading behavior and rendering in the browser require understanding of image formats and image compression techniques, image decoding and browser rendering, image CDNs and adaptive media loading, not to mention effective caching and preloading. Optimizing Network Requests with Caching and Preloading. +.

Media 94

Media Cache Google Best Practices 94

Smashing Magazine

JULY 18, 2022

The “stale-while-revalidate” cache control strategy can reduce the TTFB issue by serving a cached version of the page until it’s updated. By design, client-side rendering and per-request server-side rendering involve the most computations compared to static rendering, which happens only once at build time. middlewares.

Cache 117

Cache Website Energy Servers 117

IO River

NOVEMBER 2, 2023

Unlike CloudFormation, which was confined to AWS resources, Terraform was designed with a multi-cloud approach in mind. significant factor that contributed to Terraform's rise to prominence is its open-source nature. Being open-source, Terraform invited a vast community of developers and companies to rally around it.

Open Source 40

Open Source DevOps AWS Infrastructure 40

Smashing Magazine

SEPTEMBER 2, 2021

JavaScript Design Patterns. Image source: Flex Box Adventure ). Knights of the Flexbox Table is another well-designed interactive course to help you learn the different aspects of the flexbox specification. Image source: Flexbox Zombies ). Image source: Flexbox Defense ). On design systems, CSS/JS and UX.

Development 145

Development Games Education Programming 145

Smashing Magazine

JANUARY 11, 2021

Performance isn’t just a technical concern: it affects everything from accessibility to usability to search engine optimization, and when baking it into the workflow, design decisions have to be informed by their performance implications. Looking back now, things seem to have changed quite significantly. Establish a performance culture.

Performance 145

Performance Cache Media Metrics 145

Smashing Magazine

JUNE 2, 2021

The project consisted of upgrading the shop software to our own open-source system and redoing the shop’s front end from scratch. The design was made by a design and UX agency that also handled the HTML prototype (based on Bootstrap 4). They are basically everywhere and will dominate your design. Large preview ).

Performance 117

Performance Cache Website Mobile 117

Smashing Magazine

MARCH 19, 2021

In fact, we had to look into various cases for the form design: What happens when no data is provided at all? Given that a vast majority of our readers — wonderful people like you — are using autofill, it’s worth spending time designing an experience around it. Large preview ). The next day we subset the fonts and pushed them live.

Mobile 141

Mobile Design Cache Code 141

Percona

MAY 1, 2023

Schema design: Evaluating the database schema design and making adjustments such as partitioning large tables, eliminating redundant data, and denormalizing tables for frequently accessed information can improve performance. This parameter sets how much dedicated memory will be used by PostgreSQL for the cache.

Tuning 52

Tuning Efficiency Database Performance 52

Smashing Magazine

NOVEMBER 17, 2022

It is an open-source AV1 image file format for storing still and animated images with better lossy and lossless compression than most popular formats on the web today, offering a 50% saving in file size compared to JPEG. The change of design. Design change fix: Different images for different displays. Cache Your Images.

Media 108

Media Cache Website Mobile 108

Smashing Magazine

JUNE 1, 2022

You’ve spent months putting together a great website design, crowd-pleasing content, and a business plan to bring it all together. You’ve focused on making the web design responsive to ensure that the widest audience of visitors can access your content. You’ve agonized over design patterns and usability. Ken Harker.

Website 133

Website Design Network Best Practices 133

Smashing Magazine

JANUARY 6, 2020

Performance isn’t just a technical concern: it affects everything from accessibility to usability to search engine optimization, and when baking it into the workflow, design decisions have to be informed by their performance implications. Looking back now, things seem to have changed quite significantly. Large preview ).

Performance 145

Performance Cache Network Metrics 145

Enprowess

MAY 24, 2022

Both are open-sourced frameworks using JavaScript. ReactJS is an open-source JavaScript library. React library is designed in a way that it can integrate with existing code or other libraries effortlessly. It gives a massive boost to the overall SEO strategy. Facebook introduced both. What is React?

Mobile 52

Mobile Open Source Virtualization Speed 52

Smashing Magazine

JANUARY 7, 2019

Performance isn’t just a technical concern: it matters, and when baking it into the workflow, design decisions have to be informed by their performance implications. Without a strong alignment between dev/design and business/marketing teams, performance isn’t going to sustain long-term.

Performance 104

Performance Cache Metrics Network 104

The Netflix TechBlog

MARCH 10, 2023

Elasticsearch Integration Elasticsearch is one of the best and widely adopted distributed, open source search and analytics engines for all types of data, including textual, numerical, geospatial, structured or unstructured data. It was time to take a step back and reevaluate our ES data indexing and sharding strategy.

Strategy 258

Strategy Cache Analytics Storage 258

Smashing Magazine

NOVEMBER 2, 2021

When dealing with e-commerce at some point, you probably have heard, and perhaps used Magento, an open-source e-commerce platform. Application leaders for digital commerce technologies must plan for PWAs when designing digital commerce experiences”. The Design Gives Ground For Utmost Usability. Coding From Scratch.

Code 75

Code Cache Retail Mobile 75

The Morning Paper

NOVEMBER 5, 2019

Ceph is a widely-used, open-source distributed file system that followed this convention [of building on top of a local file system] for a decade. The zone interface… manages the disk as a sequence of 256 MiB regions that must be written sequentially, encouraging a log-structured, copy-on-write design.

Storage 64

Storage Systems Hardware Efficiency 64

Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. In the absence of a proper backup strategy, the data can be lost forever, leading to significant financial and reputational damage. Why are MongoDB database backups important?

Best Practices 52

Best Practices Database Storage Servers 52

Percona

JULY 6, 2023

If your workload and service design affords it, consider filtering your data thinking in retrieving just a few rows. Percona Distribution for PostgreSQL provides the best and most critical enterprise components from the open-source community in a single distribution, designed and tested to work together.

Best Practices 87

Best Practices Tuning Database Testing 87

Smashing Magazine

JANUARY 21, 2019

The term “component” is often used to refer both to functionality and design. Note : Brad Frost’s “ Atomic Design ” is a great methodology for identifying these common patterns and building a reusable design system. Brad Frost identifies five distinct levels in atomic design for creating design systems.

Social Media 65

Social Media Database Media Website 65

Smashing Magazine

NOVEMBER 22, 2021

It’s one thing to identify bottlenecks and implement optimizations for a specific website or a few similar websites, and quite another when dealing with many millions of websites, having such a wide variety of functionality, and an almost total freedom of design. Instead, we have to accommodate all of this variability, mostly on-demand.

Website 128

Website Performance Google Media 128

Smashing Magazine

AUGUST 20, 2021

Piecing together a website using a WYSIWYG editor and seeing the code it generated was a fascinating and educational experience that sparked an initial interest in web design. In Designing The Perfect Navigation , Vitaly will explore 100s of practical examples of better mega-dropdowns , hamburgers, carousels, modals and filters.

Ecommerce 140

Ecommerce Website Government Internet 140

The Netflix TechBlog

DECEMBER 17, 2019

Therefore, dumps are needed to capture the full state of a source. There are several open source CDC projects, often using the same underlying libraries, database APIs, and protocols. No locks on tables are ever acquired, which prevent impacting write traffic on the source database. Using proprietary database features.

Database 197

Database Traffic Transportation Open Source 197

The Netflix TechBlog

DECEMBER 17, 2019

Therefore, dumps are needed to capture the full state of a source. There are several open source CDC projects, often using the same underlying libraries, database APIs, and protocols. No locks on tables are ever acquired, which prevent impacting write traffic on the source database. Using database specific features.

Database 212

Database Traffic Transportation Open Source 212

Abhishek Tiwari

NOVEMBER 3, 2018

Any organisation pursuing microservices strategy will find hard to fit a traditional CMS in their ecosystem. Cost is one of the key reasons why most government organisations, mid to large sized business, and publisher prefer open source CMS options such as WordPress and Drupal. At the core, a traditional CMS is a monolith.

Systems 63

Systems Cache Website Network 63