For example I was told that oracle as no auto increment. Oracle has sequences; it’s just a different notation. The idea of a column value that’s automatically incremented on INSERT is certainly there. Oracle will have you add primary and foreign keys as constraints, separate from the table definition. PostgreSQL is the closest thing to … Read more
Dialect means “the variant of a language”. Hibernate, as we know, is database agnostic. It can work with different databases. However, databases have proprietary extensions/native SQL variations, and set/sub-set of SQL standard implementations. Therefore at some point hibernate has to use database specific SQL. Hibernate uses “dialect” configuration to know which database you are using … Read more
You want to look for a balance between simplicity and cleanliness, attractive features, and a platform that will allow you to write interesting and useful software (to yourself) as well as serve as a learning tool. (This last will keep you going and learning for a lot longer.) Here are some possibilities: Scheme. Probably the … Read more