current location:Home > Technical Articles > Database

  • Cache Fetched AJAX Requests Locally: Wrapping the Fetch API
    Cache Fetched AJAX Requests Locally: Wrapping the Fetch API
    This article is written by invited author Peter Bengtsson. SitePoint's special guest post is designed to bring you great content from well-known writers and speakers in the JavaScript community This article demonstrates how to implement a local cache of fetched requests so that if executed repeatedly, it will be read from the session store. The benefit of this is that you don't need to write custom code for every resource you want to cache. If you want to show off your next JavaScript party and show off your various skills in handling Promise, state-of-the-art APIs, and local storage, read on. Main gains With the Fetch API, developers can create local caches of AJAX requests by reducing redundancy
    JS Tutorial . memcached 631 2025-02-17 11:06:10
  • PHP vs Node.js Smackdown: Right of Reply
    PHP vs Node.js Smackdown: Right of Reply
    SitePoint recently held a peak showdown between PHP and Node.js, and Craig Buckler puts these two development technologies into one of the ten challenges to determine the ultimate winner. As Craig points out in the article, this comparison is always controversial. As an interesting follow-up, we invited Bruno Škvorc (PHP editor for SitePoint) and James Hibbard (one of SitePoint's JavaScript editors) to comment on each round. Here is their round-by-round evaluation… Key Points Since PHP is simple to setup and can get feedback immediately when running scripts, for
    PHP Tutorial . memcached 807 2025-02-17 10:28:10
  • Caching Hat-trick: Zend Opcache, Etags and Query Caching
    Caching Hat-trick: Zend Opcache, Etags and Query Caching
    This article explores common PHP caching techniques: Zend Opcache, Expires Headers, and MySQL Query Caching. We'll delve into further strategies in a subsequent article. Key Advantages: Zend Opcache, Expires Headers, and MySQL Query Caching signif
    PHP Tutorial . memcached 749 2025-02-17 09:29:12
  • Caching Hat-trick: Varnish, Memcached and PHP libraries
    Caching Hat-trick: Varnish, Memcached and PHP libraries
    This article explores advanced caching techniques for PHP applications, focusing on Memcached, Varnish, and supporting PHP libraries. Let's delve into how these tools enhance application speed and efficiency. Key Concepts: Memcached: A high-perfor
    PHP Tutorial . memcached 408 2025-02-17 09:11:10
  • The Ultimate Guide to Deploying PHP Apps in the Cloud
    The Ultimate Guide to Deploying PHP Apps in the Cloud
    li.toc-h3 { margin-left: 20px; } li.toc-h4 { margin-left: 40px; } Table of Contents Introduction to Cloud Servers Heroku Make a small change Database, Caching & Cron Jobs Google Cloud Database, Caching & Cr
    PHP Tutorial . memcached 945 2025-02-12 09:08:18
  • A Comprehensive Guide to Django Caching
    A Comprehensive Guide to Django Caching
    Key Takeaways Understand the Basics: Grasp the foundational concepts of caching in Django, including its importance for reducing server load and enhancing user experience by speeding up response times. Setup and Configuration: Learn how to set u
    Python Tutorial . memcached 475 2025-02-10 12:29:11
  • Accelerating the Cloud: What to Expect When Going Cloud Native
    Accelerating the Cloud: What to Expect When Going Cloud Native
    Ampere Cloud Native Platform: The perfect combination of performance, sustainability and cost-effectiveness This article is the fourth part of Ampere Computing’s “Accelerating Cloud Computing” series, which explores the many benefits of migrating to cloud-native platforms. The previous article has explained the differences between x86 architecture and cloud-native platforms and the investments required for cloud-native migration. This article will focus on the advantages brought by cloud-native platforms. Advantages of cloud native processors in cloud computing: Improve performance per rack and per dollar Enhance predictability and consistency Improve efficiency Optimize scalability Reduce operating costs Cloud native processors achieve peak performance Unlike the x86 architecture that carries a large number of legacy functions, Ampere cloud native processors are designed to efficiently execute common cloud applications.
    It Industry . memcached 861 2025-02-09 10:37:09
  • Accelerating the Cloud: The Investment to Go Cloud Native
    Accelerating the Cloud: The Investment to Go Cloud Native
    This article is the second part of Ampere Computing’s “Accelerating Cloud Computing” series. You can read the first part [here] (replace with Part 1 link here). It's much easier to migrate your app to Ampere cloud native computing platform than you think. This is because most of the work of redeploying applications to an Arm-based server is already done for you, or just recompile it. In short, because Ampere's cloud native processor uses Arm instruction set architecture (ISA), software running on Arm can also run on Ampere. Over the past five years, the open source community’s support for Arm has grown exponentially, with a wide variety of new software and services emerging. For example,
    It Industry . memcached 229 2025-02-09 10:20:18
  • Amazon ElastiCache: An Introduction, and Alternatives
    Amazon ElastiCache: An Introduction, and Alternatives
    This article will guide you quickly to Amazon ElastiCache, a powerful tool that significantly improves the performance and scalability of your application. Amazon ElastiCache is a fully managed in-memory data storage and caching service provided by Amazon Web Services (AWS). It aims to improve the performance of web applications by allowing developers to store and retrieve data from a fast, managed in-memory cache. ElastiCache supports two popular open source caching engines: Redis and Memcached. With just a few clicks, you can deploy, operate, and extend memory caches that can be accessed by applications running on AWS. Core points
    It Industry . memcached 975 2025-02-09 08:43:09
  • The Complete Guide to WordPress Performance Optimization
    The Complete Guide to WordPress Performance Optimization
    A practical guide to improving the performance of WordPress websites Key points: Choose a quality host: High-performance hosting is crucial to website speed. Managed WordPress hosting and VPS solutions provide better control and efficiency. Lite Themes and Plugins: Avoid bloated themes and plugins, unnecessary features will slow down the website and affect the user experience. Implement caching strategies: Page caching and object caching can reduce server load and speed up content delivery. Regularly optimize database: Delete redundant data, optimize database operations, and ensure fast query response. Using CDN: CDN can provide static files to global users faster and improve global performance of websites. Compress and optimize pictures and static files:
    PHP Tutorial . memcached 993 2025-02-08 13:31:37
  • Accelerating the Cloud: The Final Steps
    Accelerating the Cloud: The Final Steps
    (This article is the fifth part of Ampere Computing’s “Accelerating Cloud Computing” series. You can read all articles on SitePoint.) The final step in cloud-native application development is to decide where to start. As the final issue of this series, we will explore how to develop cloud-native application, where to start the process within your organization, and the various situations you may encounter in the process. As shown in other parts of this series, cloud-native platforms are quickly becoming a powerful alternative to x86-based computing. As we demonstrated in Part IV, there is a huge difference between full-core Ampere vCPU and semi-core x86 vCPU in terms of performance, predictability, and energy efficiency.
    It Industry . memcached 965 2025-02-08 10:32:09
  • PHP Authorization with JWT (JSON Web Tokens)
    PHP Authorization with JWT (JSON Web Tokens)
    Application authentication used to rely solely on credentials such as username/mailbox and password, and the session was used to maintain user status until the user logged out. After that, we started using the authentication API. Recently, JSON Web Tokens (JWT) are increasingly used to authenticate server requests. This article will introduce what JWT is and how to use PHP for JWT-based user request authentication. Important points Evolution of authentication methods: This article outlines the evolution of user authentication methods, from traditional sessions to using JSON Web Tokens (JWT), highlighting the transition to a more secure and efficient way of user authentication and session management for web applications. . JWT's Excellence
    PHP Tutorial . memcached 999 2025-02-08 09:57:09
  • Quick Tip: How to Cache Data in PHP
    Quick Tip: How to Cache Data in PHP
    This tutorial quickly explains the PHP caching mechanism and its applications. Efficient performance is the key to PHP application development. Facing thousands or even millions of users, the performance and availability of web applications face huge challenges. Caching technology can effectively avoid performance bottlenecks and improve application efficiency. Core points The cache stores frequently accessed data in a temporary location, reducing the number of times data is read from the original location, thereby improving PHP application performance. Output buffering is a technique in PHP that stores script output in a buffer before being displayed to the user, allowing modifications or other operations before being displayed. PHP provides a variety of cached data functions, such as apc_store(), memcache_set() and xcache_s
    PHP Tutorial . memcached 544 2025-02-08 09:04:14
  • Understanding the concept of caching in software developement
    Understanding the concept of caching in software developement
    Caching: A Performance Booster for Software Applications Caching is a powerful technique that significantly enhances the speed and efficiency of software applications. It works by storing frequently accessed data in a readily available location, min
    JS Tutorial . memcached 976 2025-01-30 06:29:09
  • Tips to Optimize Your Laravel Application Performance
    Tips to Optimize Your Laravel Application Performance
    It is important to build a high -performance Laravel application in order to provide a smooth user experience. This article will share ten effective Laravel application performance optimization skills, covering the cache strategy to the database optimization technology. These techniques will help shorten the loading time, improve server efficiency, and improve the overall speed of application. Use the route cache importance: Laravel loads routes in each request. If your application has a lot of routes, this will slow down the response time. Using Laravel's routing cache function can significantly reduce the time required for loading routing. Operation method: Run the following command cache application route: Php Artisan Route: Cache Tip: Modify the route
    PHP Tutorial . memcached 839 2025-01-25 06:07:07

Tool Recommendations

jQuery enterprise message form contact code

jQuery enterprise message form contact code is a simple and practical enterprise message form and contact us introduction page code.
form button
2024-02-29

HTML5 MP3 music box playback effects

HTML5 MP3 music box playback special effect is an mp3 music player based on HTML5 css3 to create cute music box emoticons and click the switch button.

HTML5 cool particle animation navigation menu special effects

HTML5 cool particle animation navigation menu special effect is a special effect that changes color when the navigation menu is hovered by the mouse.
Menu navigation
2024-02-29

jQuery visual form drag and drop editing code

jQuery visual form drag and drop editing code is a visual form based on jQuery and bootstrap framework.
form button
2024-02-29

Organic fruit and vegetable supplier web template Bootstrap5

An organic fruit and vegetable supplier web template-Bootstrap5
Bootstrap template
2023-02-03

Bootstrap3 multifunctional data information background management responsive web page template-Novus

Bootstrap3 multifunctional data information background management responsive web page template-Novus
backend template
2023-02-02

Real estate resource service platform web page template Bootstrap5

Real estate resource service platform web page template Bootstrap5
Bootstrap template
2023-02-02

Simple resume information web template Bootstrap4

Simple resume information web template Bootstrap4
Bootstrap template
2023-02-02

Cute summer elements vector material (EPS PNG)

This is a cute summer element vector material, including the sun, sun hat, coconut tree, bikini, airplane, watermelon, ice cream, ice cream, cold drink, swimming ring, flip-flops, pineapple, conch, shell, starfish, crab, Lemons, sunscreen, sunglasses, etc., the materials are provided in EPS and PNG formats, including JPG previews.
PNG material
2024-05-09

Four red 2023 graduation badges vector material (AI EPS PNG)

This is a red 2023 graduation badge vector material, four in total, available in AI, EPS and PNG formats, including JPG preview.
PNG material
2024-02-29

Singing bird and cart filled with flowers design spring banner vector material (AI EPS)

This is a spring banner vector material designed with singing birds and a cart full of flowers. It is available in AI and EPS formats, including JPG preview.
banner picture
2024-02-29

Golden graduation cap vector material (EPS PNG)

This is a golden graduation cap vector material, available in EPS and PNG formats, including JPG preview.
PNG material
2024-02-27

Home Decor Cleaning and Repair Service Company Website Template

Home Decoration Cleaning and Maintenance Service Company Website Template is a website template download suitable for promotional websites that provide home decoration, cleaning, maintenance and other service organizations. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-05-09

Fresh color personal resume guide page template

Fresh color matching personal job application resume guide page template is a personal job search resume work display guide page web template download suitable for fresh color matching style. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-29

Designer Creative Job Resume Web Template

Designer Creative Job Resume Web Template is a downloadable web template for personal job resume display suitable for various designer positions. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-28

Modern engineering construction company website template

The modern engineering and construction company website template is a downloadable website template suitable for promotion of the engineering and construction service industry. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-28