How To Use H2 Database In Eclipse

Both of them use SOAP services and an ORACLE database. It is open source and free to use. Make sure Eclipse with JBoss Tools Plug-in is installed properly. In this blog series, we will develop a Spring Boot application and deploy it on SAP Cloud Platform (Cloud Foundry). Visualize o perfil de Nelson Gomes, JAVA SE 8,PMP, ITIL, Certified no LinkedIn, a maior comunidade profissional do mundo. Click on Add View. Build a powerful database applications following few steps using Sohag Developer. H2 X exclude from comparison: Eclipse public license) Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development. The Java H2 Database is a great low resource option to implement as a database in your Java application. From the H2's home page, we download the database in a ZIP file. In our Spring Batch application, we will use FlatFileItemReader to create reader and JdbcBatchItemWriter to create writer. I am assuming you are already familiar with Alfresco, Activiti, SQL, Spring, JUnit, Mockito framework and H2 database engine. h2database » h2 H2 Database Engine. How to Install Apache Tomcat 9 (on Windows, Mac OS X, Ubuntu) and Get Started with Java Servlet Programming This practical can be completed in a 3-hour session. Hi: I have the same issue like "H2 console cannot be opened in Bonita studio 7. Another poorly implemented feature of Eclipse: rep Adam Bien on Lambda and Runnable;. Step 2: Backup and reload database before and after tests. jar from the command line (and thus the h2 browser interface on port 8082), I have created. H2 is an SQL database engine written in Java that implements the JDBC API. sql found in the database directory of the pizza1 project. Spring Boot can auto-configure embedded H2, HSQL, and Derby databases. A simple. Design and Implementation SDK To connect to the server Commodity Futures Trading (using of java multi threading ,java nio{ datagramChannel,selector,selectionKey } , java net { DatagramSocket,Socket }, log4j , spring, spring-quartz,h2,mysql,maven. alpha4 in 5 steps On August 2, 2010 by Joram Barrez With 15 Comments - Activiti , bpm , bpmn With the 5. CoreException: El archivo no existe para la herramienta externa llamada Open h2 web console. Why is in memory database required? Let's consider a cenario when you want to do a quick proof of concept(POC) and using a traditional database involves a lot of overhead. xml defining a. H2 is an open-source lightweight Java database. After a few moments (the initial contents for the database instance are being created), you should be able to expand into the connection profile an examine the contents of the embedded Apache Derby database. zip Copy ESSSpinner. H2 is an SQL database engine written in Java. This allows you to quickly retest the execution using slightly different values and settings. I have written a Swing Application and I am using H2 database in embeded mode. Create a new project. This tutorial assumes that you're starting from scratch and thus covers every single step necessary towards a working JSF web page. It is open source and free to use. The majority of Cúram clients are federal governments and local authorities who are in charge of providing social welfare payments. Embedded and server modes are available. WebDSL Eclipse Plugin 1. If you are using Eclipse Scout and you want to connect to a database using the SqlService you need to include the JDBC driver in your application. Spring Boot makes it especially easy to use an in-memory database - because it can create the configuration automatically for H2, HSQLDB, and Derby. Just a courtesy question; what's your position on using this code in a premium plugin? I'm considering whether to release my FlightPaths plugin as premium (along with a free Lite version), and I'm using your code for the database stuff. Notice: Undefined index: HTTP_REFERER in /home/yq2sw6g6/loja. If you're not aware of how to check the MySQL connectivity from NetBeans, you can check out this post. The instance is not linked to the database instance we have already created – that is done at connect time according to the JDBC connection string used. Steps to connect with H2 database with Eclipse. This may include preparing the database schema. It can be embedded in Java applications or run in the client-server mode. Als Schnittstellen zur Ansprache der mit dem System betriebenen Datenbanken stehen SQL und JDBC zur Verfügung. Below are few properties we need to mention so that our H2 database is accessible over the web. Java Jdbc Tutorial with H2 Embedded database h2 embedded database url,h2 embedded database url,h2 embedded,h2 embedded,h2 embedded database,h2 embedded database,h2. It demonstrates how to create and run a simple JPA application in Eclipse. For this you can use Apache Derby. The form will have Next and Previous to scroll through the data. Open Eclipse IDE and Select Database Perspective (Windows >> Open Perspective >> Other). August 15, 2019 — 0 Comments. You can also review the test results in the index. Tools and Technologies used in this article : Hibernate Core 4. This article provides an introduction to the H2 Java SQL database. Derby will be still included with Payara 5 but will no longer be the default database. Derby is an open-source, freely available, pure Java database. H2 also has a smaller disk footprint; the size of a jar file is around 1. Testing, Database. sonar ant task using h2 instead of mysql to connect. Eclipse 2018-099 H2 Database H2 is the open source Java SQL database. To set up a database connection using Eclipse IDE, follow this procedure: Collect the information necessary to connect to your target database. Developing Using Eclipse You’re developing using the default lift_proto. In server mode, java application and H2 database run in different JVM or machine. Querying the Embedded H2 Database of a Spring Boot Application Ever wanted to execute a query on the in-memory H2 database in your Spring Boot application? It's actually very easy to do so - and you can even set up a web client. You can also use Gradle. On systems using a 1. H2 Database Engine License: EPL 1. 0 ( Eclipse Public License ). Below are few properties we need to mention so that our H2 database is accessible over the web. ‘Cause it doesn’t use an identical copy of the production database. First will be created a base starting project from Eclipse, then a very simple controller will be added returning a string as view content, and finally will be show how to serve an html file from the controller. If your database vendor provides a JDBC driver jar as an OSGi bundle then you can deploy it directly into Felix Console. How to use H2 shell H2 is one of the fastest database which comes under modified version of the MPL 1. You will of course need a text editor. This article provides an introduction to the H2 Java SQL database. Every visitor can sign the guestbook by filling a simple form. H2 is one of the popular in memory database and Spring Boot provides very easy configuration for an in memory database like H2. We often use the H2 database for testing purposes with its in-memory database feature. db H2 database, and you would like to use a tool to look at the tables. Note that, H2 InMemory Database is a relational DBMS written in Java. Instructions: Extract SirsuspectSMS. We often use the H2 database for testing purposes with its in-memory database feature. Service Resiliency With Spring Cloud Netflix Hystrix. The left pane displays the execution history. Choose the Derby client driver (10. spring boot, spring cloud. DBCP provides support for JDBC 2. apk to your device storage Install Eraser Software Solution Joemel E. So insted of using. Add the jars Add H2 jar present in the same bin folder to the…. If you are using Eclipse Scout and you want to connect to a database using the SqlService you need to include the JDBC driver in your application. It strives to be very simple and easy to use, avoiding both the tediousness of using JDBC directly and the heaviness of a full-blown ORM. JODB (Java Objects Database) is an open source object-oriented database. Steps to disconnect database through eclipse. Click on 'clear' to clear the console. Eclipse DTP: Configure H2 Datasource using Data Source Explorer. The following is not a pure unit test and neither is it a pure integration test. To use it in embedded mode, you need to: Add the h2*. Test case (using SQLFiddle with Oracle): create table test(x number(15,3));. You know, handling form data represented in HTML page is a very common task in web development. How do I create a H2 database inside a java project in Eclipse? Ask Question 3. The Eclipse Web Tools and Data Tools Projects deliver a feature-rich environment for developing Java EE database-driven web applications. Therefore you can easily embed h2 database into your application. I'm still a noob in JavaFX, I can print the content of the table that I query, the problem is that I want the content to be placed inside the tableview. 4; Mockito 1. 0, configure it for use with a database, employ its functionality to design dynamic reports and charts, and create. Remember an in-memory database is created/initialized when an application starts up; and destroyed when the application shuts down. Securing the code against the SQL injections and easier coding due to difficulties with double and single quotes. The DTP News and Views blog is Brian Fitzpatrick's (aka "Fitz") window on the world. xml files are attached). The H2 server does not need to run for this example. I used the Deployment Manager interface to configure a Websphere Application Server 8. Demo PreparedStatement Set Timestamp: 25. H2 Database Tutorial. This saves the database to a location in the file system, and utilizes an H2 feature that allows multiple processes to connect to the same database. The query results appear in the SQL Results view. Disk based and in-memory databases and tables are supported. 0 Hello World With Activiti 5. It can be embedded in Java applications or run in the client-server mode. It's possible to update the information on H2 Database Engine or report it as discontinued, duplicated or spam. CoreException: El archivo no existe para la herramienta externa llamada Open h2 web console. Last Updated on Tuesday, October 22, 2019 - 11:36 by Andrew Vojak. Here we are showing implementation for SQL Statement and PreparedStatement using H2 Embedded Database with disk/file system. The original developer, Thomas Mueller, also developed the Java database engine Hypersonic SQL (1998 - 2001), which is the origin of HSQLDB. Here we will learn to connect to any Database (Supported) using Eclipse IDE. Add the h2*. Complete user registration system using PHP and MySQL database. It can be easily integrated with Spring which we are going to look at in this tutorial. Project Description. Choose the Derby client driver (10. Introduction to H2 Database. How do I create a H2 database inside a java project in Eclipse? Ask Question 3. I am fairly new to Eclipse & Java and currently work on a project where I need to implement my first database. Als Schnittstellen zur Ansprache der mit dem System betriebenen Datenbanken stehen SQL und JDBC zur Verfügung. H2 Database 1. This tutorial provides step-by-step instructions on how to create a Web application that uses the Java persistence application programming interface (JPA) version 2. 4; Mockito 1. apk to your device storage Install Eraser Software Solution Joemel E. To know more about testing with TestNG in general, please refer our TestNG Tutorials. integrate liquibase in junit – using hibernate JPA with in memory h2 database; use mockito to inject the entity manager in a JUnit test; Execute liquibase db. Zero Con guration Zero Maintainance Easy to use for Learning, POCs and Unit Tests Spring Boot provides Simple Con guration to switch between a real database and an in memory database like H2 Create PDF in your applications with the Pdfcrowd HTML to PDF API PDFCROWD H2 H2 is one of the popular in memory databases. Here JdbcSQLNonTransientConnectionException exception occurred because trying to connect H2 database through application while it's already connected through eclipse. Here, we are going to create a simple example of hibernate application using eclipse IDE. In this example we will search the book from database. It is very fast and small (about 1 MB), and supports embedded, server, and clustering modes. So download SQL-WorkBench and install for running the SQL Queries. The list of alternatives was updated Oct 2018. Main Site / Home / Documentation / Videos / Forum / Contact Us / Blog / Search / Setting up Eclipse. Eclipse IDE would look like below. bat script on Window or h2-web-console. You will add code to the project to connect to a database using Spring JDBC. By continuing to use this website, you agree to their use. Using MySQL with a Simple AMP project The Maven Alfresco SDK can be configured to use MySQL, rather than the default database which is H2. Configure the project. I also created an acceptance tests framework based in Selenium. jar to the classpath. xml which is a template for configuring MySQL as Database. You know, handling form data represented in HTML page is a very common task in web development. The Database configuration page in preferences (Timekeeper > Database) allows you to configure where the database for the current Eclipse instance should be kept. This is the Eclipse version of the JPA Web App tutorial. Server -tcpShutdown tcp://localhost:909 Basic setup to use H2 in unit testing -To use H2 in unit test cases, we might want to extend H2DBEnabledTestCase class, which starts the H2 server in setup method so that during test run database could be available and stops server in tearDown method. After creating the database type the command "use ;" For creating a new table, refer this page. After moving the ISAM database files into one location, creating a new datasource, selecting the location of the database files and defining the format of each table, i use an application called ‘ODBC Test’ to execute some test queries via the data source. The demo web application manages a basic guestbook page. Description: This CSS example demonstrates how to apply multiple classes to an element. Step 1 − Registering the JDBC database driver. Resare, MIT +639077640336 [email protected] Pagination in Servlet and JSP. You will create a simple project with Spring Boot. Here I show you how to unit test LogActionListener class. Tools/Technologies used: Maven Spring Eclipse MySQL or H2 database (You can also use other RDBMS like Oracle, Sybase, etc) Step 1: (Create Spring JDBC project using. Sonar uses a Derby or H2 as default database. Create MySQL dump of a database/table. MyEclipse's rich set of database and persistence features enable you to rapidly develop database-centric applications using Java EE, Spring, Hibernate, POJOs, or combinations thereof. 1 application. This database can be used in embedded mode, or in server mode. August 18, 2019 — 0 Comments. Please note that JNDI resource configuration changed somewhat between Tomcat 5. To use it in embedded mode, you need to: Add the h2*. Why is in memory database required? Let’s consider a cenario when you want to do a quick proof of concept(POC) and using a traditional database involves a lot of overhead. 4; Mockito 1. Learn how to integrate an H2 database into your Spring Boot Project with Spring Initializr. Create Connection Profile: Here we will create profile for connecting to DB. もっとも、H2 Databaseの場合には 組込モード というのがあるので、その場合は別途インストールするのではなくて、Javaアプリが稼働しているのと同じJavaVM上でDBを稼働させJDBCで直接アクセスします。その辺については、下記ページを参考にしてください。. H2 Database Engine License: EPL 1. The latest JAR could also be found on a Maven repository. We need to - Create Spring Boot project from spring Initializer with required dependencies. In this post I am going to show you how you could implement an embedded database within a Java application. x comes after version 2. Visualize o perfil de Nelson Gomes, JAVA SE 8,PMP, ITIL, Certified no LinkedIn, a maior comunidade profissional do mundo. Create a simple project 3. 0: Categories: Embedded SQL Databases: Tags: database embedded sql:. Download the Platform-Independent Zip. See Apache Derby. Why is in memory database required? Let's consider a cenario when you want to do a quick proof of concept(POC) and using a traditional database involves a lot of overhead. Using the H2 Database Console in Grails We've switched the in-memory development database in Grails from HSQLDB to H2 for 1. For the example in this article, switch to the Data Source Explorer view in Eclipse. H2 database connection parameters are displayed and some automatic checks are performed on driver, url, connection, version information. 2" I'm running Bonita BPM 7. $ mv h2 ~/bin/ We move the installation directory to a destination of our choice. This article provides an introduction to the H2 Java SQL database. apk to your device storage Install Eraser Software Solution Joemel E. Remember, when using H2 in embedded mode, you can only have a single connection open. Derby is an open-source, freely available, pure Java database. Use mysql database table I know that activiti uses a h2 database by default, but I want to use a mysql database instead. Activiti will take care of the transactions. Embedded and server modes are available. This tutorial walks you through the process of creating a simple database web application using Eclipse WTP/DTP, Tomcat, and the Derby database engine. My Job is: I've build the above job and created zip folder, then extracted the folder also. This will make sure that you will have properties loaded from database as well as any additional configuration that you can safely put in application. Also features easy setup program. H2 is an open-source lightweight Java database. I'm still a noob in JavaFX, I can print the content of the table that I query, the problem is that I want the content to be placed inside the tableview. In this tutorial, we will learn how to connect Spring MVC application to the database using annotation and Java-based configuration. An example of testing your hibernate code using in-memory database in absence of physical database. Download H2 databaseDownload H2 database from - H2 download, I downloaded the platform independent version. Spring Boot H2 Database Configuration Example. jar to repository/component/lib 3. Consider writing your integration testing's, where you might need to insert or retrieve the records from the database and for this use case we will not be able to run it on production site or on our local database as it may change the state of the database. [2] The disc footprint (size of the jar file ) is about 1. 111, H2 in-memory database can run inside the Google App Engine. Die H2 Database Engine, kurz H2, ist ein in der Programmiersprache Java geschriebenes relationales Datenbankmanagementsystem. An H2 in-memory database is used by default. By continuing to use this website, you agree to their use. How to create a simple EJB3 project in Eclipse (JBoss 7. Connecting H2 In-Memory database and Spring Boot Spring Boot provides out-of-box support for H2. The two jdbc:script tags specify the database schema that should be created and then the SQL to be run against that schema to populate the initial records. History The development of the H2 database engine started in May 2004, and first published in December 2005. Note that the H2 database is in the embedded mode. Add the h2*. It is open source and free to use. SQL Workbench/J contains predefined JDBC drivers with sample URLs for connecting to the database. In this example, I will configure the Spring Boot to use the H2 as an In-memory Database, which means we don't need to install the H2 database. Some people disagree and don’t call these unit tests, but integration tests. 'Cause it doesn't use an identical copy of the production database. Creating a new H2 database instance; Selecting a database instance for existing Kura components; Enabling the TCP Server; Using the Web console; Changing the password; Persistence Modes; Starting from version 3. alpha4 in 5 steps On August 2, 2010 by Joram Barrez With 15 Comments - Activiti , bpm , bpmn With the 5. Hibernate uses JavaBean classes to represent database tables in memory. How do I create a H2 database inside a java project in Eclipse? Ask Question 3. Now, I’ve bought a NAS from QNAP, so I plan to migrate all my H2 data from laptop into NAS. The syntax is as follows:. Creating Hello World Application using Spring MVC on Eclipse IDE In this tutorial we will go into some detail on how to set up your Eclipse IDE environment so that you can develop Spring MVC projects. It's possible to update the information on H2 Database Engine or report it as discontinued, duplicated or spam. Step 2: Update pom. Every visitor can sign the guestbook by filling a simple form. Let's first start by opening http//start. Project setup. I used the Deployment Manager interface to configure a Websphere Application Server 8. Here I show you how to unit test LogActionListener class. To use the Eclipse IDE for development, please see Eclipse Setup. From Eclipse, under the sql folder, open up the CreateTables. The original developer, Thomas Mueller, also developed the Java database engine Hypersonic SQL (1998 - 2001), which is the origin of HSQLDB. Question: Tag: java,database,jdbc,h2 I am converting old h2 databases (with the h2. Those scenarios are follows: a. H2 is one of the popular in-memory databases written in Java. I am fairly new to Eclipse & Java and currently work on a project where I need to implement my first database. To use H2 in EclipseLink, use the platform class org. Configure Activiti Explorer for the H2 Database. The H2 Console is a visual tool helping you administer the H2 database. Learn how to install BIRT V2. In our example we will create a batch application which will read data from a CSV file and write into H2 database. 1, Hibernate 4, and HSQLDB in a Maven project using Eclipse (with Maven Integration for Eclipse) as an editor. These are parameterized SQL statements. The Java H2 Database is a great low resource option to implement as a database in your Java application. So in the above post, we saw how we can create restful API using Spring rest, Spring Data JPA and H2 database with Spring Boot. Open Eclipse IDE and Select Database Perspective (Windows >> Open Perspective >> Other). Once installed, three build steps are made available: "Evaluate liquibase changesets", "Generate Liquibase dbDoc", and "Rollback liquibase changes". The h2 database is a high-performance, low profile, Java native database engine, created as a successor to the widely used HSQLDB. As we use the embedded mode as our default database, we automatically use the username "sa" (without quotes) and an empty password to connect to the database in the embedded mode. It can be embedded in Java applications or run in the client-server mode. This may include preparing the database schema. apk to your device storage. For creating the first hibernate application in Eclipse IDE, we need to follow the following steps:. Create Connection Profile: Here we will create profile for connecting to DB. SQLite Manager - Firefox addon. Instead of using H2 in-memory database, we want to use the IBM Db2 for i database. x is an improved and hardened version of the persistence engine of 1. Monitor database connections graphically with JBoss and WildFly Today I will show how to use a graphical GUI to trace the execution of your Database connection pool running in JBoss AS or WildFly with ton of useful info at your hands. As shown in the screenshot there are a lot of threads which are blocked by the h2 Engine within a REST call. Introduction to H2 Database. H2 is one of the popular in memory database and Spring Boot provides very easy configuration for an in memory database like H2. In the first example, we connect to an in-memory H2 database. Window → Preferences → General → Network Connections and make sure the option “Use this proxy server for SSL” is checked → Apply → OK → restart Eclipse. It is very fast and small (about 1 MB), and supports embedded, server, and clustering modes. Eclipse 2018-099 H2 Database H2 is the open source Java SQL database. Here I show you how to unit test LogActionListener class. So, use H2 when you want to do a quick POC - Proof Of Concept as using persistent database like Oracle or SqlServer involves a lot of overheads. Embedded and server modes are available. Using Eclipse CDO as a lightweight ORM solution in web applications Introduction For one of my projects I had to decide for an object relational mapping (ORM) solution to be used in a web environment. Eclipse Luna; First, create the parent project. This is project about generating electricity by using vertical blades in the form of tree. Re: Changing from H2 database to MSQL database loaone seleka Sep 6, 2012 4:51 AM ( in response to tmmaluleke ) Yes i use the ant start. H2 Database Engine was added by mer30hamid in Jul 2011 and the latest update was made in Nov 2019. sql,database,h2. In some tables of the database I have a problem with the stricter engine. Depending on how you use and configure the plugin, you may need to install a database server, and potentially your target schema. The bean-validation quickstart demonstrates how to use CDI, JPA, and Bean Validation in JBoss Enterprise Application Platform Server. This article provides an introduction to the H2 Java SQL database. The Java H2 Database is a great low resource option to implement as a database in your Java application. It includes an embedded H2 database and JPA to serve books, which are randomly generated on startup. In this example, I will configure the Spring Boot to use the H2 as an In-memory Database, which means we don't need to install the H2 database. Another way is to develop database in another language but use a Java library to access the database. Some GIT basics mainly for me to remember. Create Spring Boot Application using start. Hi to all, I would like to ask the following: In my html task form, a drop-down list of default values is loaded from an html code in Eclipse. Go to New -> Others… and choose Maven Project under Maven. H2 is an open source embedded database built on java ships in a single. This feature is only supported in the Ultimate edition. Add the h2*. Click Save Password to save the password for the database server login. If you’re using H2 you should use DB_CLOSE_ON_EXIT=FALSE to do so. These components provide the same functionalities offered by the HSQL based DbWireRecordFilter and DbWireRecordStore components, but using the H2 database. Close all the applications that using H2 (web console, etc) Then add the AUTO_SERVER=TRUE to the end of the location in h2 console and also in java program (which you already have done) 文章来源: How to run H2 database in server mode?. Add the jars Add H2 jar present in the same bin folder to the…. So download SQL-WorkBench and install for running the SQL Queries. using Groovy and Grails with various grails plugins (grails-ui plugin, spring-acegi plugin), GSP and Tag Libraries. Unlike other Open Source In-Memory Database, there is no default DB Editor Tool within H2. Setting workspace and memory usage in eclipse Feb 13 by venkidwaraka When using eclipse, we can set the memory usage and workspace target at the eclipse shortcut itself. I encourage you to research how to use H2 in TCP mode (like a regular database) because it's hard to control when Eclipse opens/closes connections to the database. Now that you have the index fixed you should be able to find your favorite resources with Open Type, Auto-complete, Open Resource, etc. Just a courtesy question; what's your position on using this code in a premium plugin? I'm considering whether to release my FlightPaths plugin as premium (along with a free Lite version), and I'm using your code for the database stuff. The are a number of ways to use a connection in DTP. sonar ant task using h2 instead of mysql to connect. H2 database is the open source Java SQL database. H2 is an open-source lightweight Java database. It is recommended to use test specific configurations using @TestConfiguration annotation. Eclipse JUNO Service Release 2; TestNG 6. To use H2 in EclipseLink, use the platform class org. So download SQL-WorkBench and install for running the SQL Queries. Configuring jBPM 6 to use a non-default Database The jBPM 6 full installer out of the box ships with the H2 Database for saving the Process Persistence data. Spring Boot can auto-configure embedded H2, HSQL, and Derby databases. The support includes such features as enhanced code completion and better retrieval of database objects (introspection). The datasource provides database connections to our application. Though it is not mandatory and we can use mockito to mock the database interactions. We will see now our sample properties file and its output. You will create a simple project with Spring Boot. If your database vendor provides a JDBC driver jar as an OSGi bundle then you can deploy it directly into Felix Console. I used the Deployment Manager interface to configure a Websphere Application Server 8. These are parameterized SQL statements. Please let us know if you have used DBCP and its JDBC 3. Save your project. In this post, we will create our first Spring MVC project with the all to familiar “Hello World” sample program. The majority of Cúram clients are federal governments and local authorities who are in charge of providing social welfare payments. 187; Let’s begin. In H2, this feature is called 'disabling literals'. 1) and Eclipse (2019-03). This is the Eclipse version of the Quick Start with JPA tutorial. Also learn how to set up CRUD methods in Java and how to use JDBC. db H2 database, and you would like to use a tool to look at the tables. Right click on H2DB database. Briefly - my workaround: just download the h2 v1. If you are using Eclipse Scout and you want to connect to a database using the SqlService you need to include the JDBC driver in your application. Most drivers accept additional configuration parameters either in the URL or through the extended properties. Monitor database connections graphically with JBoss and WildFly Today I will show how to use a graphical GUI to trace the execution of your Database connection pool running in JBoss AS or WildFly with ton of useful info at your hands. forName ("org. 4 and one of the cool features this provides is a web-based database console.