stlplace

Tag: database

  • Setup RDMS for learning

    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.

    1. 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 minutesHibernate 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:

    (more…)