Материалы по теме 'sql' | DevsDay.ru

IT-блоги Материалы по теме 'sql'

IT-блоги Материалы по теме 'sql'


Разработка dev.to 20 мая 2024 г. 1:41

Earlier I briefly introduced Apache Iceberg and built an out-of-the-box experiment environment. https://github.com/wirelessr/flink-iceberg-playground The purpose of the article was to experience the integration of Flink SQL and Iceberg, so that I c...... читать далее

bigdata datascience tutorial dataengineering

Разработка dev.to 20 мая 2024 г. 0:53

Django is a powerful web framework known for its speed and ease of use. But with great power comes great responsibility, especially when it comes to security. In today's digital landscape, even minor vulnerabilities can have catastrophic consequences...... читать далее

django security webdev python

Разработка dev.to 19 мая 2024 г. 22:00

A Full-stack Developer is a versatile professional in web development who possesses expertise in both front-end and back-end technologies, allowing them to work on all aspects of web application development. Here's a detailed description of the role:...... читать далее

fullstack developer

Разработка dev.to 19 мая 2024 г. 21:40

Introduction Welcome to this comprehensive guide on using Python for data analysis! Whether you're a beginner or an experienced programmer, this post will provide valuable insights into harnessing Python's power for your data projects. We'll cover e...... читать далее

webdev python programming tutorial

Разработка dev.to 19 мая 2024 г. 19:01

In this tutorial, you will learn how I increased the flexibility and performance of my Astro-powered blog by integrating Couchbase. We will walk through the step-by-step process in transforming your Astro static blog into one that leverages a NoSQL d...... читать далее

tutorial webdev database

Разработка dev.to 19 мая 2024 г. 12:52

Databases are crucial for storing and managing data. In this article, you'll learn to create and interact with MySQL database in Python. Installing PyMySQL PyMySQL is a MySQL client library written in Python that allows you to create and...... читать далее

mysql python database programming

Разработка dev.to 19 мая 2024 г. 2:06

I recently completed the final stage of a data migration project for the start-up I work at by rewriting a bunch of MySQL queries into BigQuery queries. With all the different flavours of SQL (T-SQL, MySQL, Google SQL...) and the move from on-premis...... читать далее

bigquery mysql sql database

Разработка dev.to 19 мая 2024 г. 0:54

Challenge: Reduce the AWS Cloud Operating cost without compromising any existing feature Steps: Switch to 8x5 from 24x7 in Dev and QA Environments​ Use the correct size of Serves in Dev and QA based on the load​ Avoid using same server configurati...... читать далее

aws cost serverless

Разработка 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