A special thanks goes to Speedment for sponsoring last week's Wednesday Morning Coffee at Breadtalk. Speedment is an open source Object Relational Mapper (ORM). An ORM makes it easy for Object oriented programmers and programs to persist objects to a traditional SQL database. Speedment is an accelerated ORM. So aside from simplifying the database mapping, Speedment speeds up query response times. It's also a graph database,so it specializes in large datasets, and excels with data where relationships between nodes are queried.
This little hare is Spire, the Speedment mascot. I've installed Speedment several times, and it's very effective for projects where there will be lot's of queries on your data, and where relationships are important. It's a honor to have a company that understands the importance of relationships sponsor our coffee.
Showing posts with label speedment. Show all posts
Showing posts with label speedment. Show all posts
Sunday, May 24, 2015
Monday, August 11, 2014
Running Speedment ACE on Amazon EC2
Speedment ACE is a Graph Database Converter, and a powerful software development tool. A Graph Database is a NoSql database that performs best when the relationships between nodes of your data are the most important (and frequently accessed) part of that data.
Speedment ACE builds a Graph Data Grid (GDG) automatically, either from existing tables, or using the Ace Front end to generate those tables. A great way to check out Speedment ACE is to install it on Amazon Web Services. Here's how to get going with Speedment in 10 easy steps.
1) Create an AWS MySql Instance.
Note the database endpoint, name, username and password then connect form a MySql client.2) From the Speedment Programmer's Guide,
Create a test schema and sample users table:
CREATE SCHEMA speedment_test;
USE speedment_test;
CREATE TABLE `speedment_test`.`user` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(45) NOT NULL,
`surname` VARCHAR(45) NOT NULL,
`email` VARCHAR(45) NOT NULL,
`password` VARCHAR(45) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `Index_email`(`email`),
INDEX `Index_name`(`name`)
) ENGINE = InnoDB;
3) Create an AWS Windows Instance
Be sure to associate the instance with a key pair so you can connect using a Windows RDP Client. Then in the AWS Console, Launch your new instance, and generate a password using your private key. Also make not of the IP address of your new instance.4) Connect to your new Windows Instance using an RDP client.
If you have Google Chrome, you can use the 2X Client for RDP/Remote Desktop.5) Internet Explorer on your new EC2 Windows Instance will ask you
to add every URL you visit for your permission. You may want to install another browser to avoid this.6) Download and install the JSDK 1.7.
After installing set the JAVA_HOME environment variable to the bin directory where the 'java' executable is located.7) Download and unzip the Speedment Ace Front End .
Run it from the ace.bat file located in the bin directory.8) After registering, Create a new Project.
9) Right-click on the new project and select “Add DBMS”.
Add the info from the DB instance we created in step 1.10) Starting on page 28 of the Speedment Programmer's Guide,
you can now explore capabilities of the Speedment Ace front end. This includes the ability to generate code for rapid application development, and building a Graph Data Grid (GDG), the core of Speedment's optimization capabilities.
Labels:
amazon ec2,
Data Science,
database,
graph database,
graph search,
nosql,
speedment,
speedment ace
Subscribe to:
Posts (Atom)
Popular Articles
-
Today's Tech Talk Tuesday is virtual, we'll do a live one next week. Learn how to code with R like DataFrames in Julia. And see...
-
In computer science and specifically machine learning , programmers have been trying to simulate the behavior of the brain since the late...
-
Cloud Computing has graduated from being a technology buzzword to being an essential part of any business or organization. Let's take a...
-
Top 10 Cloud Apps for your Business introduced apps often used from the cloud. There are several vendors to chose from when implementin...