database – stlplace

Reading Time: < 1 minute

I am teaching a database course this semester at a local university. It seems install MySQL on Windows is not very straightforward. Something I didn’t realize as personally I am on the Mac for a while.

I looked around and summarized the following choices.

Local MySQL vs online databases – Top 9 free online databases

2) Other: Univ of Arkansas (I have not verified) – “Instructions on how to use web-based free-hosted RDBMS.zip” – from Instructor Resources

3) AWS – RDS

Please be aware of the potential cost! Similar for Azure and GCP. Setup alert or monitor so that we don’t get surprised.

Or Google cloud (again a sample cost alert)

Similar for Azure

Rule of thumb: when you give the credit card information to a public cloud provider, always set a budget, and a cost alert. Because we don’t want any surprises in the bills.

Personally if I am the person who is in charge of a company’s cloud bill, for both dev (experiment) and production. I will be like Cory Quinn.

Some corrections to Hibernate tutorial

Reading Time: 2 minutes Hibernate logo
I was referring to the First application at Hibernate (Jboss) offical documentation. I found some problems when doing the exercise: just want to share some of my findings so others may benefit.

1) dependency version missing: there are already some some discussions on the Hibernate discussion forum, such as this one and that one. I followed the first one: added the version numbers as suggested and the problem went away.

2) jdbc driver can not be found, the fix is to

mvn install:install-file -DgroupId=hsqldb -DartifactId=hsqldb -Dversion=1.8.1.2 -Dpackaging=jar -Dfile=/path/to/your/hsqldb.jar

in my case (mac) this is /Users/major_xu/Downloads/hsqldb/lib/hsqldb.jar

I saw discussion on this one, too, the suggestion is to “add classpath for hsqldb.jar”. But I don’t know how to do it in maven command line.

3) misc: there are a lot other corrections: