The Impaler

Washington, D.C., USA

Currently developing the awesome HotRod ORM for MyBatis.

Over the eons, I have tried numerous front-end and back-end Java technologies. I love to build scalable, low-maintenance applications with high database performance.

top accounts reputation activity subscriptions

Does MySQL support partial indexes?

mysql sql database indexing relational-database asked Mar 20, 2018 at 23:44

stackoverflow.com

10 votes

Does PostgreSQL implement multi-table indexes?

sql postgresql indexing query-performance multi-table asked Aug 7, 2020 at 18:00

stackoverflow.com

9 votes

Post-apocalyptic Movie where Gasoline Was Very Scarce

story-identification movie asked Jul 17, 2021 at 19:06

scifi.stackexchange.com

8 votes

Does INTERSECT have a higher precedence compared to UNION?

sql union intersect asked May 20, 2019 at 15:39

stackoverflow.com

8 votes

Should we use sequences or identities for our primary keys?

sql database postgresql db2 primary-key-design asked Apr 6, 2018 at 15:56

stackoverflow.com

7 votes

Create a Java annotation for warnings - @NonOptimal

java annotations compiler-warnings asked Aug 19, 2020 at 15:07

stackoverflow.com

6 votes

Does the SQL type TIME WITH TIMEZONE make sense?

sql ansi-sql-92 type-mapping asked Mar 2, 2020 at 15:06

stackoverflow.com

6 votes

How do I make a table read-only in PostgreSQL

sql postgresql constraints asked Jul 16, 2018 at 17:20

stackoverflow.com

6 votes

Oracle - Partially nullable composite foreign key

sql oracle foreign-keys asked Sep 13, 2018 at 18:24

stackoverflow.com

5 votes

Pi 4 performance against x86 - CI/CD server with Java/Maven

pi-4 server java software-development benchmarking asked Jul 9, 2020 at 3:05

raspberrypi.stackexchange.com

Top Answers

181

VirtualBox Cannot register the hard disk already exists

stackoverflow.com

Isn't SQL A left join B, just A?

stackoverflow.com

Best practices on primary key, auto-increment, and UUID in SQL databases

stackoverflow.com

How to see my table column is foreign key or not in H2 database

stackoverflow.com

How do I comment out an XML section that has comments inside?

stackoverflow.com

SQL Shift column down 1 row

stackoverflow.com

Oracle - Partially nullable composite foreign key

stackoverflow.com

Create two tables whose foreign keys reference each other

stackoverflow.com

NOT DEFERRABLE versus DEFERRABLE INITIALLY IMMEDIATE

stackoverflow.com

How to escape apostrophes from user input

stackoverflow.com

ORA-00984: column not allowed here in oracle sql

stackoverflow.com

PostgreSQL - One-To-One - which approach is "better"?

stackoverflow.com

Does using REFERENCES without FOREIGN KEY still create a foreign key?

stackoverflow.com

H2 - Create unique index with two columns

stackoverflow.com

Get All elements from Table A that do not have a foreign key entry in table b

stackoverflow.com

DATEDIFF in DB2 query

stackoverflow.com

Plot Graphs in MySQL?

stackoverflow.com

Oracle SQL auto increment for char

stackoverflow.com

Generic SQL predicate to use for keyset pagination on multiple fields

stackoverflow.com

PostgreSQL: unique constraint or unique index

stackoverflow.com

postgresql - datetime: does postgresql have datetime type like in mysql?

stackoverflow.com

Oracle PL/SQL: count(*) between 2 tables

stackoverflow.com

MySQL MariaDB Server Raspberry Pi remote access

stackoverflow.com

What's the difference between WHERE and FILTER (WHERE) in PostgreSQL?

stackoverflow.com

How to select the second highest salary row without using limit function in SQL?

stackoverflow.com

There a way to have primary key ids without any gaps

stackoverflow.com

SQL Increment based on another column

stackoverflow.com

Pi 4 performance against x86 - CI/CD server with Java/Maven

raspberrypi.stackexchange.com

Invalid Character during my SQL Plus Insert Statement

stackoverflow.com

Best data type for PostgreSQL datatime type

stackoverflow.com