Разработка • dev.to • 18 мая 2024 г. 14:50
Structured Query Language (SQL) is the cornerstone of managing and manipulating data in relational database systems. At the heart of SQL operations are the CRUD operations: Create, Read, Update, and Delete. These operations form the foundation of int...... читать далее
sql datascience database tutorialРазработка • dev.to • 18 мая 2024 г. 14:06
Fala Devs! Nesta semana lá na California rolou o evento anual da Google que ela apresenta seus principais lançamentos do ano chamado Google I/O. Na terça feira foi realizado o keynote principal, transmitido ao vivo em vários canais, e muitos fica...... читать далее
flutter googleio dartРазработка • dev.to • 18 мая 2024 г. 8:41
Introduction AWS Redshift Query Editor v2 is a web-based tool that allows analysts to securely explore, share, and collaborate on data using SQL within a common notebook interface. It simplifies querying data with SQL and visualizing results with c...... читать далее
aws queryeditor okta redshiftРазработка • dev.to • 18 мая 2024 г. 1:36
End-to-end (E2E) testing is essential for ensuring that your application works correctly from the user's perspective. This guide will dive into advanced topics in E2E testing, including testing single-page applications (SPAs), progressive web apps (P...... читать далее
webdev testing testdev opensourceРазработка • dev.to • 18 мая 2024 г. 0:04
General Commands -- This is a comment \? -- more help \l -- list all databases \c databaseName -- connect to databaseName \dt -- Show all tables \d tablename -- describe tablename \i -- load query from .sql file (accepts only absolute path...... читать далее
webdev database postgres sqlРазработка • dev.to • 17 мая 2024 г. 20:30
Todo o tutorial está sendo feito dentro de uma WSL2 com Ubuntu do Windows 11. Primeiro precisamos de um PostgreSQL com PostGIS instalado. Nesse exemplo vamos iniciar utilizando Docker Container com o comando abaixo: docker run --name postgis -p 5...... читать далее
Разработка • dev.to • 17 мая 2024 г. 20:15
As you may already know, indexing is a great way to improve the performance of your queries. But is that really it? There are no silver bullets, only trade-offs. What's the catch? There's always a catch! When you create an index, the RDBMS create...... читать далее
database webdev backend sqlРазработка • dev.to • 17 мая 2024 г. 10:35
Since joining ReductStore's project, I've been exploring alternative solutions to get a better understanding about how the project fits into current echosystem. To give you some context, we will look at solutions to store data from IoT devices (e.g...... читать далее
mqtt databaseРазработка • dev.to • 17 мая 2024 г. 10:15
On-Demand Instances With On-Demand Instances, you pay for compute capacity by the hour or by the second depending on which instances you run. No longer-term commitments or upfront payments are needed. You can increase or decrease your compute capacit...... читать далее
aws ec2 cloudcomputingРазработка • dev.to • 17 мая 2024 г. 6:11
Introduction Hive is a lightweight and fast NoSQL database that can be used to store data in Flutter applications. In this blog, we will explore how to fetch data from APi, store and use it in Hive in Flutter. This Blog includes defining Hive ty...... читать далее
flutter dart offline hiveРазработка • dev.to • 17 мая 2024 г. 6:00
A Back-End Developer is a specialist in web development responsible for building and maintaining the server-side logic, databases, and applications that power websites and web applications. They work on the server-side of web development, focusing on...... читать далее
backend developerРазработка • dev.to • 17 мая 2024 г. 2:32
In 2015, the formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. To conveniently calculate these 101 alphas in DolphinDB, you can use the functions encapsulated in the module wq101alpha (wq...... читать далее
programming tutorial alpha databaseРазработка • dev.to • 17 мая 2024 г. 1:42
When working with databases, we often encounter situations where queries require significant time to execute. Long database queries can be a cause of intensive resource usage, such as CPU, I/O, and memory. In this article, I will explore the issue of...... читать далее
mysql database devops monitoringРазработка • dev.to • 16 мая 2024 г. 17:53
One of the most recent projects I did was an exam project for a cloud engineering program I am doing. We were asked to: Automate the provisioning of two Ubuntu-based servers, named “Master” and “Slave”, using Vagrant. On the Master node, create a b...... читать далее
linux mysql php bashРазработка • dev.to • 16 мая 2024 г. 13:38
The EXCEPT statement, first included in Microsoft SQL Server 2005, has become one of the most popular methods for separating records and finding discrepancies between two data sets. It functions on a similar premise to that of minus in mathematics. T...... читать далее
sql sqlserver devart dbforgeРазработка • dev.to • 16 мая 2024 г. 10:17
As a data science enthusiast, I've discovered the immense value of Power BI (Business Intelligence) in transforming raw data into actionable insights. If you're considering which tools to master as a data science student, here are five compelling rea...... читать далее
datascience datastructures assignment powerbiРазработка • habr.com • 16 мая 2024 г. 9:15
Последние несколько лет мы в Postgres Professional активно занимаемся разработкой своего решения для горизонтального масштабирования PostgreSQL. Пользователям нужен был простой способ увеличить производительность путем добавления узлов. Традиционно д...... читать далее
postgresql распределенные системы sharding shardmanРазработка • habr.com • 16 мая 2024 г. 8:02
С момента прошлого релиза фреймворка 🐙 userver для С++ прошло чуть больше полугода. За это время мы многое сделали: сильно оптимизировали работу фреймворка и обогнали основных конкурентов в бенчмарках высокопроизводительных фреймворков; знач...... читать далее
yandex открытый код userver github c++ c++17 postgresql postgres redis mongodb mongo synchronization coroutine coroutines logs dynamic changes python python3 yaml json sql mysql prometheus prometheus grafana опенсорс яндекса ydb kafka осьминогиРазработка • dev.to • 16 мая 2024 г. 8:00
Databases are complex beasts. They have options for various areas like memory usage, backups, write-ahead logs, monitoring, replication, and many more. Installing a database is just the beginning, we need to configure it accordingly later on to match...... читать далее
sql postgres monitoringРазработка • dev.to • 16 мая 2024 г. 7:31
This article is the third part of a series that explores integrating Ory, within the NestJS framework. In the previous articles, we introduced Ory and its core components and discussed creating dedicated NestJS libraries to simplify Ory integration...... читать далее
tutorial javascript nestjs ory
