Articles

CockroachDB TIL : Vol. 12

CockroachDB TIL : Vol. 12

,

Découvrez le dernier volume de CockroachDB TIL ! Apprenez-en plus sur les fonctionnalités et les améliorations de CockroachDB pour vous aider à développer des applications plus robustes.

Articles précédents

Volumes 1 à 11

Sujets

Le volume 1 à 11 de cet article traite de différents sujets liés au logiciel. Dans ce volume, nous allons examiner le sujet n°1 : Identifier les index partiels. Notre équipe d’ingénieurs a publié un avis technique #96924 indiquant que certains changements de schéma, tels que la suppression de colonnes référencées dans des index partiels, échoueront. Un client demande comment identifier les bases de données, les tables et les index partiels associés qui référencent les colonnes à supprimer. Les méthodes suivantes vont aider à trouver ces index indésirables.

En considérant une table avec les données suivantes :

Table: customers

Columns: id, name, address

Indexes:

CREATE INDEX customers_name_idx ON customers (name) WHERE address IS NOT NULL;

CREATE INDEX customers_address_idx ON customers (address) WHERE name IS NOT NULL;

La première méthode consiste à exécuter une requête SQL pour obtenir les informations sur les index partiels. La requête suivante peut être utilisée pour obtenir les informations sur les index partiels pour la table « customers » :

SELECT * FROM pg_indexes WHERE indpred IS NOT NULL AND tablename = ‘customers’;

Cette requête renvoie les informations sur les index partiels pour la table « customers ». Le résultat de cette requête est le suivant :

indexname | tablename | indpred

———-+———–+———

customers_name_idx | customers | (address IS NOT NULL)

customers_address_idx | customers | (name IS NOT NULL)

La deuxième méthode consiste à utiliser un outil logiciel pour identifier les index partiels. Il existe plusieurs outils logiciels qui peuvent être utilisés pour identifier les index partiels. Certains des outils logiciels populaires sont pg_indexes, pg_stat_user_indexes et pg_stat_all_indexes. Ces outils peuvent être utilisés pour obtenir des informations détaillées sur les index partiels d’une base de données. Ces outils peuvent également être utilisés pour obtenir des informations sur les index partiels pour une table spécifique.

Enfin, la troisième méthode consiste à utiliser le fichier de configuration du serveur PostgreSQL pour identifier les index partiels. Le fichier de configuration du serveur PostgreSQL contient des informations détaillées sur les index partiels. Ces informations peuvent être utilisées pour identifier les index partiels pour une base de données ou une table spécifique.

En conclusion, il existe plusieurs méthodes pour identifier les index partiels dans une base de données PostgreSQL. Ces méthodes peuvent être utilisées pour obtenir des informations détaillées sur les index partiels d’une base de données ou d’une table spécifique. Ces méthodes peuvent également être utilisées pour identifier les index partiels qui référencent des colonnes à supprimer.

Source de l’article sur DZONE

/par

Using the PostgreSQL Pager With MariaDB Xpand

,

I’m not an anti-GUI person. In fact, I wrote three books about web GUI development with Java. However, I also like the command-line interface (CLI), especially text-based UIs. After a year of exploring MariaDB and the DevOps world, I got to discover and play with many text-based CLI tools that I didn’t know even existed. These tools are especially useful when connecting to remote servers that don’t have a GUI.

One special CLI tool that I frequently use is the mariadb SQL client (or mysql in the MySQL world)—a CLI program used to connect to MariaDB-compatible databases. With it, you can send SQL queries and other commands to the database server.

Source de l’article sur DZONE

/par

10 Great WordPress Plugins in 2023

,

WordPress is a highly flexible content management system for website creation. A key reason for this flexibility is the wide variety of plugins available. You can add features and other improvements to your site.

The thousands of available useful WordPress plugins cover almost every feature for any type of website. Your website’s niche determines the kind of plugins you should have. There are some great WordPress plugins that every blog site needs; security, speed, SEO, and contact form, to name several.

The most effective WordPress websites create an enjoyable visitor experience. Whether you’re blogging about the latest fashion trends or selling products for your brand, you can enhance your website. Do it with one or more of these ten great WordPress plugins.

1. Brizy: The Best Website Builder for Non-techies

You might want to approach Brizy with caution because once you start using it, no other website theme builder you might try will ever seem as easy to use. Even better, you can download this WordPress website builder for non-techies (and for techies as well) for Free.

With the Brizy WordPress theme builder at your fingertips, you can –

  • build a brand new website or upgrade an existing one;
  • create dynamic templates for your blog and archive pages, headers, footers, custom pages, and more;
  • enjoy instant access to 150+ customer-friendly pre-made templates;
  • build your blog exactly as you envisioned it;
  • easily customize your WooCommerce shop site.

Brizy’s Theme Builder, Global Blocks, and Global Styling features are right at your fingertips, and WooCommerce integration is also included.

You can also choose the 100% White Label option if you wish to brand the Brizy Builder as your own. A Pro option is available.

Click on the banner to learn more about Brizy and download it free.

2. WpDataTables – WordPress tables plugin

While there are a host of good reasons for using wpDataTables, the main benefit is that it works with any WordPress theme, it can create a responsive table in minutes, and it requires no coding to use.

With this WordPress tables plugin, you can take advantage of a host of useful features that include –

  • four chart-building engines: Google Charts, Highcharts, Chart.js, and the new Apex Charts;
  • connecting to multiple database sources, e.g., MYSQL, MS SQL, and PostgreSQL;
  • fine-tuning a table or chart to make it responsive or editable and using conditional formatting to highlight critical data;
  • the ability to create tables from a nested JSON file;
  • and use dynamic single-cell shortcodes in many different options;
  • integration with Elementor, Divi, WPBakery, and Avada.

wpDataTables is a robust table and chart-building plugin that’s remarkably straightforward. Just click on the banner to learn more.

3. Amelia – WordPress booking plugin

Amelia is a WordPress booking plugin that can fully automate and streamline its appointment booking operations when added to a business’s WordPress site. This makes Amelia an excellent choice for beauty, healthcare, fitness, consulting, educational, and similar client-dependent businesses.

The Amelia plugin can –

  • manage an unlimited number of appointment bookings at multiple locations, and do so from a single platform and dashboard;
  • enable clients to book appointments online 24/7;
  • easily manage group appointments, package bookings, and events;
  • send notifications and reminders to clients via Email or SMS, and make payments online with PayPal, Stripe, Mollie, or Razor;
  • customize booking forms to match its host’s brand.

Click on the banner to find out more about how the Amelia WordPress plugin could be used to upgrade your business’s booking operations.

4. Slider Revolution – more than a WordPress slider plugin

Slider Revolution is a WordPress plugin that is more than just a slider plugin. It’s a highly popular plugin that designers rely on to create visuals they know their clients and customers will love.

Slider Revolution features –

  • 250+ website and slider templates designed to impress;
  • innovative website animation effects and other features that push the boundaries of what is possible in web design.

Slider Revolution is trusted by over 9 million users around the world.

5. WordLift – AI-powered SEO

Structured data helps your website speak the language of Google, and WordLift is the most innovative way to create one.

It is an AI-powered SEO tool that: 

  • adds structured data to your content;
  • creates a Knowledge Graph that makes it easier for Google to understand the relevance of pages, their relationship, and their value;
  • build up the expertise, authority, and trustworthiness of your website.

As a result, you get more organic traffic and audience engagement.

6. TheDock – Ship Solid Websites

TheDock is a design team-oriented WordPress theme builder that supports collaboration, speeds up website design, and helps to create sites that look sharp, perform great, and are easily maintained because of its –

  • custom Post Types and Custom Fields;
  • speedy page load;
  • flexible auto-adjusting layout system with UI components;
  • white-label builder for sharing access to TheDock if you want to;
  • built-in features that assure excellent security and easy maintenance.

7. Download Monitor – Best WordPress Download Manager

Download Monitor is a WordPress downloads manager that can help you streamline your business operations without having to go through the process of setting up a complicated or costly tracking solution.

With the Download Monitor plugin, you can –

  • track any type of file download (ZIP, PPT, XSLX, PDF, etc.);
  • assemble aggregated file download statistics about different file download types;
  • establish access rules based on user roles and download quotas.

8. Essential Grid – best WordPress grid plugin

Essential Grid is, by all accounts, the best WordPress grid plugin on the market. Essential Grid makes it ever so easy to spice up your websites by using it to create superbly engaging and professional-looking galleries.

This WordPress plugin can give you –

  • stunning, fully customizable boxed and full-width to full-screen grid layout options and various grid designs;
  • responsive designs that enable you to control grid appearance on various devices;
  • access to social media content. 

9. LayerSlider – Best WordPress Slider Builder Plugin

LayerSlider is the best WordPress slider plugin, but it is not just for sliders. Create image galleries, popups, landing pages, animated page blocks, parallax and scroll scenes, and even full websites.

LayerSlider –

  • will fit your needs and is easy to use;
  • can spice up and add flair and style to an otherwise run-of-the-mill website;
  • supports any WordPress theme and page builder;
  • features 210+ highly customizable websites, slider, and popup templates.

10. YellowPencil – Visual CSS Editor

YellowPencil is a visual CSS editor you can use to customize any WordPress site in minutes.

Key features include –

  • a complete visual editing interface that allows you to redesign a page with a few clicks;
  • a simple interface that does not require coding;
  • the capability to edit any font and any color;
  • the capability to visually edit a design element’s size, margin, and padding properties;
  • the ability to undo/redo mistakes.

*******

It is almost needless to tell any WordPress user how important plugins are for a website. A good WordPress plugin has the power to boost the success of your business online by adding a range of helpful features and functionality to your website.

In this article, we have shared our expert pick of 10 great WordPress plugins for your websites in 2023.

 

[– This is a sponsored post on behalf of BAW media –]

Source

The post 10 Great WordPress Plugins in 2023 first appeared on Webdesigner Depot.

Source de l’article sur Webdesignerdepot

/par

Essential Protocols for Python Developers to Prevent SQL Injection Attacks

,

You are going to encounter a number of issues as a Python developer. Mastering the syntax of coding isn’t enough to write functioning, stable applications. You also have to familiarize yourself with different challenges the final application might deal with, including Python security risks.

Many of the discussions about developing secure applications focus on using machine learning to protect customers, such as helping them avoid holiday scams. However, it is equally important to ensure the applications themselves are not vulnerable to cybercriminals.

Source de l’article sur DZONE

/par

Common Mistakes to Avoid When Writing SQL Code

,

SQL (Structured Query Language) is a powerful and widely-used language for managing and manipulating data stored in relational databases. However, it’s important to be aware of common mistakes that can lead to bugs, security vulnerabilities, and poor performance in your SQL code. In this article, we’ll explore some of the most common mistakes made when writing SQL code and how to avoid them.

1. Not Properly Sanitizing User Input

One common mistake made when writing SQL code is not properly sanitizing user input. This can lead to security vulnerabilities such as SQL injection attacks, where malicious users can inject harmful code into your database.

Source de l’article sur DZONE

/par

Distributed SQL: An Alternative to Database Sharding

,

Database sharding is the process of dividing data into smaller pieces called « shards. » Sharding is typically introduced when there’s a need to scale writes. During the lifespan of a successful application, the database server will hit the maximum number of writes it can perform either at the processing or capacity level. Slicing the data into multiple shards—each one on its own database server—reduces the stress on each individual node, effectively increasing the write capacity of the overall database. This is what database sharding is.

Distributed SQL is the new way to scale relational databases with a sharding-like strategy that’s fully automated and transparent to applications. Distributed SQL databases are designed from the ground up to scale almost linearly. In this article, you’ll learn the basics of distributed SQL and how to get started.

Source de l’article sur DZONE

/par

How We Reduced Online Serving Latency From 1.11s to 123.6ms With a Distributed SQL Database

,

This post tells how a website with a distributed database reduced online serving latency from 1.11 s to 417.7 ms, and then to 123.6 ms. We found that some lessons learned on MySQL could be applied throughout the optimization process. But when we optimize a distributed database, we need to consider more.

The OSS Insight website displays the data changes of GitHub events in real time. It’s powered by TiDB Cloud, a MySQL-compatible distributed SQL database for elastic scale and real-time analytics.

Source de l’article sur DZONE

/par

Google Cloud for Beginners – How To Choose a Database Service?

,

Context

  • 1: Is choosing a database easy?
  • 2: What are the different categories of databases?
    • 2.1: What are Relational Databases?
      • Relational Databases – OLTP – Online Transaction Processing
        • Cloud SQL
        • Cloud Spanner
        • Cloud SQL vs Cloud Spanner
      • Relational Database – OLAP – Online Analytics Processing
        • BigQuery – Modern Data warehouse
    • 2.2: What are NoSQL Databases?
      • Cloud Datastore and Firestore
      • Cloud BigTable
      • Choosing between Cloud Firestore, Datastore vs Cloud BigTable
    • 2.3: What are In-memory Databases?
  • 3: Let’s get a quick summary

Is Choosing a Database Easy?Datacenters

Choosing a database for your use case is not easy. A few factors you would need to consider:

  • 1: Do you want a fixed schema? Do you want flexibility in defining and changing your schema? Do you want to go schemaless?
  • 2: What level of transaction properties do you need? (atomicity and consistency)
  • 3: What kind of latency do you want? (seconds, milliseconds or microseconds)
  • 4: How many transactions do you expect? (hundreds or thousands or millions of transactions per second)
  • 5: How much data will be stored? (MBs or GBs or TBs or PBs)

Before we get into the details, let’s explore the different categories of databases:

Source de l’article sur DZONE

/par

SAP S/4HANA, Microsoft SQL Integration and Hard Deletion Handling

,

This article will demonstrate the heterogeneous systems integration and building of the BI system and mainly talk about the DELTA load issues and how to overcome them. How can we compare the source table and target table when we cannot find a proper way to identify the changes in the source table using the SSIS ETL Tool?

Systems Used

  • SAP S/4HANA is an Enterprise Resource Planning (ERP) software package meant to cover all day-to-day processes of an enterprise, e.g., order-to-cash, procure-to-pay, finance & controlling request-to-service, and core capabilities. SAP HANA is a column-oriented, in-memory relational database that combines OLAP and OLTP operations into a single system.
  • SAP Landscape Transformation (SLT) Replication is a trigger-based data replication method in the HANA system. It is a perfect solution for replicating real-time data or schedule-based replication from SAP and non-SAP sources.
  • Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the management functions offered by the database, including backups, patching, upgrading, and monitoring, with minimal user involvement.
  • SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and transformation solutions. SSIS is used to integrate and establish the pipeline for ETL and solve complex business problems by copying or downloading files, loading data warehouses, cleansing, and mining data.
  • Power BI is an interactive data visualization software developed by Microsoft with a primary focus on business intelligence.

Business Requirement

Let us first talk about the business requirements. We have more than 20 different Point-of-Sale (POS) data from other online retailers like Target, Walmart, Amazon, Macy’s, Kohl’s, JC Penney, etc. Apart from this, the primary business transactions will happen in SAP S/4HANA, and business users will require the BI reports for analysis purposes.

Source de l’article sur DZONE

/par

Exciting New Tools for Designers, October 2022

,

We write this guide to the best new tools for designers and developers each month. For October, we’ve sought out tools to make you a better website builder, some handy utilities to make you more productive, and a spooky font for the end of the month. Enjoy!

Microsoft Designer

Microsoft Designer is a brand-new app for creating images from text prompts. You can create social media posts, blog images, and any other assets you need with its step-by-step guided process.

Remix

Remix is a full-stack web framework for React that lets you focus on designing your UI. Remix is geared towards web standards and delivers a resilient user experience so you can build better sites.

Ultra

Ultra is a super-fast package manager that uses hardlinks to install packages. It’s up to ten times faster than NPM and Yarn, and the project is open-source.

AskEdith

AskEdith is an AI-powered app that translates English into SQL so you can query your database without writing custom SQL. Just type a description of what you want to know, and the app creates the query for you.

Wide Angle Analytics

Wide Angle Analytics is a GDPR-compliant Google Analytics alternative that puts privacy first. Track actions across multiple sites and discover insights about your site without exposing yourself to privacy violations.

story.to.design

Imagine being able to import a whole webpage straight into Figma. You can, with story.to.design, a fantastic app that imports code into Figma for updating UI elements or speeding up redesigns.

Metlo

Metlo is a testing platform for securing APIs. By running comprehensive tests against your API, you can uncover issues like unidentified endpoints, before they become a security threat.

StockAI

Nothing is more frustrating than searching for the right stock image when one doesn’t exist. StockAI is a day-saver that searches for stock images, and if the sought-after image doesn’t exist, it will generate one for you.

Growthfyi

If ad-blockers are playing havoc with your Google Analytics, check out this script from Growthfyi. It’s an invaluable service that doubles the speed of GA while ensuring ad-blockers don’t catch it.

Sourcery

Sourcery is an excellent tool for developers that continually reviews your code and suggests improvements automatically. Write better code, and catch errors before it goes to review.

Cyber Security Icons

This set of Cyber Security Icons contains 20 illustration-style icons. In addition, there are some great interpretations of complex ideas like retina scans, crypto vaults, and end-to-end encryption.

Blinqo

Blinqo is a handy little Chrome extension for anyone that needs to share their screen. It allows you to blur parts of your screen when sharing or recording, so your private details remain private.

Instaprice

Instaprice is a helpful new service that shows you what other freelancers charge for the job you’re quoting on. Earn the actual market rates and never get caught out undercharging again!

Leta

Leta is a great app that allows you to design your own keyboard layout. You can redesign the key positions for macOS, Linux, or Windows and download them for free.

Blogic

Build blogs powered by the Notion API with Blogic, a no-code blog builder that can create fast, SEO-friendly blogs in under a minute. Custom domains and third-party scripts are supported.

Digital Maker Toolkit

The Digital Maker Toolkit is a collection of resources for anyone releasing digital products. It includes guides on process, a handy step-by-step checklist, a list of further resources, and a guide to the available tools.

Slides

Slides is a static website generator you can use to create beautiful, animated websites in minutes. Select layouts from a collection of templates and publish with clean code that downloads fast.

AXplorer

AXplorer is a privacy-focused browser with a built-in VPN. Created by the Axia blockchain network, it generates free crypto in the form of AXIA coins when using it to browse the web.

Font Engine

Can’t decide on a font for your latest side project? Font Engine is a handy little app that will suggest fonts for you. Just tell it your brand values and hit the ‘Suggest’ button.

Deliciozo

Deliciozo is an excellent display font with irregular strokes and styling, making it feel like a paper cut-out. It’s perfect for magazines, cookbooks, and even logos.

Kayino

If you’re looking for a font to convey the hippy era, look no further than the psychedelic stylings of Kayino, a groovy display font with crazy details.

Noganas

Noganas is a spooktacular font for the upcoming Halloween festivities. Use it to add some gruesome frivolity to your seasonal designs.

Source

The post Exciting New Tools for Designers, October 2022 first appeared on Webdesigner Depot.

Source de l’article sur Webdesignerdepot

/par