The Impaler

The Impaler has asked 10 questions and find answers to 27 problems.

Stats

About

Currently developing the awesome HotRod ORM and microservices apps.

Over the eons, I have tried numerous front-end and back-end technologies. I love to build high performance, low support applications.

The Impaler questions

How do I make a table read-only in PostgreSQL
Does PostgreSQL implement multi-table indexes?
Oracle - Partially nullable composite foreign key
Insert empty string in Oracle [duplicate]
Does MySQL support partial indexes?
Create a Java annotation for warnings - @NonOptimal
Does INTERSECT have a higher precedence compared to UNION?

The Impaler answers

Combining two tables with date ranges into one table
Does using REFERENCES without FOREIGN KEY still create a foreign key?
Get count for each group, but stop counting after N result rows in each group
Oracle - Partially nullable composite foreign key
Complex recursive SQL to produce hierarchical data
Does MySQL support partial indexes?
WHERE vs. HAVING performance with GROUP BY
Create a Java annotation for warnings - @NonOptimal
How to see my table column is foreign key or not in H2 database
Generic SQL predicate to use for keyset pagination on multiple fields