Here is the second video of a complete PostgreSQL course that will be available on Udemy and other platforms. This video is about installing and configuring CentOS 6.6 on VirtualBox. The idea is to install here PostgreSQL and use it like a remote server.
Next video will be about PostgreSQL basic and advanced installations under Windows and Linux.
Amazing news. PostgreSQL is growing and growing, fast and strong. A couple of weeks ago EnterpriseDB positioned in the Leaders Quadrant of Gartner Magic Quadrant. You can see the new here:
When deploying production applications, the best way to handle database connections is through a connection pool. Actually, most of JEE containers can manage connection pools, thus, you only request a connection from your application to the server and server is in charge of manage active connections and serve connections when needed. JBoss lets you configure a datasource and then configure a connection pool. The steps are the next:
- Register JDBC library as a module
- Create a new database driver based on JDBC module
- Create a datasource
1. Register JDBC library as a module
I’m using PostgreSQL 9.3 so i have postgresql-9.3-1102-jdbc41.jar . Navigate to JBoss directory. Inside you will find a folder named modules. Here, you will see various modules already present in JBoss or Widlfly. In Wildfly is a little bit different because inside modules folder, you only will find a folder named system. The idea is to separate system modules from your modules. You will have to create your own folders inside it.
This video is the first of a complete videotutorial course about PostgreSQL – usage and management – that is under construction but it will be released in a couple of weeks. The course is focused on teach you how to install PostgreSQL on Windows or Linux, configuring it and tuning it, learn the basics of DML and DDL, learn programming language PL/pgSQL, triggers, backup and restore, using command line tools like psql and so on. This first video isn’t about PostgreSQL, it’s about installing and configuring VirtualBox. The idea is to install PostgreSQL on a virtual machine to simulate a remote database server, or to teach you how to install it on Linux if your computer OS is Linux.