Articles

Distributed SQL Essentials

,

Distributed SQL databases combine the resilience and scalability of a NoSQL database with the full functionality of a relational database. In this Refcard, we explore the essentials to building a distributed SQL architecture, including key concepts, techniques, and operational metrics.
Source de l’article sur DZONE

/par

Introduction to PDO Extension: How to Use PDO for Different Databases

,
In this article, we will talk about what a PDO is, why is it necessary, and how to work with it.
Let’s start with the fact that for a long time php-programmers have been discussing the fate of the native functions to work with the database: mysql_connect, mysql_query, and others. The fact is that in upcoming versions of PHP data will be erased, these functions will go "Obsolete". Thus PHP developers should force on other tools to work with the database.
Currently, there are two alternatives solutions; mysqli extension and expansion of PDO. In this article, we will discuss PDO.
PDO – PHP Data Objects – is a layer that offers a versatile way to work with multiple databases.
This layer has several advantages:
  • PDO allows you to work with different databases, such as: MYSQL, Oracle, PostgreSQL and many others.
  • PDO allows you to work with a prepared statement
Now let’s talk about all this in more detail.

Connecting to a Database Using PDO

Before you start working with PDO, you must make sure that you have the correct extension – php_pdo_mysql.dll. This can be verified through the function phpinfo(). If everything is okay, you are good to go.
First we need to connect to the database:
PHP

  

xxxxxxxxxx
1

15

 

1 

/ / MuSQL

2 









 3 




   $Database = new PDO ("mysql: host = $ host; dbname = $Databasename", $username, $password); 








 4 












 5 




/ / PostgreSQL








 6 












 7 




   $Database = new PDO ("pgsql: host = $ host; dbname = $Databasename", $username, $password);








 8 












 9 




/ / MS SQL








 10 












 11 




   $Database = new PDO ("mssql: host = $ host; dbname = $Databasename", $username, $password); 








 12 












 13 




/ / SQLite








 14 












 15 




   $Database = new PDO ("sqlite: my / database / path / database.db");














 




 
















 As you can see from the example, each database connection string is slightly different from each other



 You should always use try/catch when you are trying to connect to the unit, so that on exception we do not disclosed any data to the user.









 PHP 


   






  




 






 




 


 














xxxxxxxxxx




 1 






 


 




   










 1 




try {








 2 




   $Database = new PDO ("mysql: host = $ host; dbname = $Databasename", $username, $password); 








 3 




} 








 4 




catch (PDOException $ e) { 








 5 




   echo "Unable to connect to database"; 








 6 




}














 




 
















Source de l’article sur DZONE


/par 
	Using PostgreSQL pgoutput Plugin for Change Data Capture With Debezium				
,  


Change Data Capture Architecture Using Debezium, Postgres, and Kafka
was a tutorial on how to use Debezium for change data capture from Azure PostgreSQL and send them to Azure Event Hubs for Kafka – it used the wal2json output plugin.


What About the pgoutput Plugin?


This blog will provide a quick walk through of how to pgoutput plugin. I will not be repeating a lot of details and use containerized versions (using Docker Compose) of Kafka connect, Kafka (and Zookeeper) to keep things simple. So, the only thing you need is Azure PostgreSQL, which you can setup using a variety of options including, the Azure Portal, Azure CLI, Azure PowerShell, ARM template.


Source de l’article sur DZONE


/par 
	Getting Started With Distributed SQL				
,  
 In recent years, NoSQL distributed databases have become common, as they are built from the ground up to be distributed. Yet they force difficult design choices such as choosing availability over consistency, data integrity, and ease of query to meet their applications’ need for scale. This Refcard serves as a reference to the key characteristics of distributed SQL databases and provides information on the benefits of these databases, as well as insights into query design and execution. 
Source de l’article sur DZONE


/par 
	What’s the Future of Cloud Databases?				
,  


As more organizations look to migrate their databases to the cloud, what does this mean for developers? We at DZone believe there is no one better to ask than you! Tell us about your experiences with cloud databases by taking this 5 minute survey!


Over the next two weeks, we plan to survey hundreds of software developers about their experiences with cloud databases. The key findings from the survey will be found in our Cloud Database Trend Report to be released February 19. It is our hope that we can identify some of the key trends happening in the space to help our community stay ahead of the curve.


Source de l’article sur DZONE


/par 
	SQL, Databases, and Hollywood Movies				
,  



 Hollywood sign close up




Policemen, doctors, lawyers, scientists, teachers: these are the professions that we often see in Hollywood movies. But are movies also trying to show what the work of data analysts looks like? Here is a list of six movies in which screenwriters, directors, and producers decided to cast SQL and databases in the main roles.


Data analysis is most often associated with business, reporting, and making key decisions for the company. Today it is part of many organizations’ daily life, so it’s no wonder that this topic often appears in movies.


Source de l’article sur DZONE


/par