AnyhowStep

Results 105 comments of AnyhowStep
trafficstars

Document MySQL, PostgreSQL, SQLite differences regarding auto increment and multi-insert

Given the following `INSERT`s, 1. implicit autoincrement 1. implicit autoincrement 1. explicit autoincrement to 999 1. implicit autoincrement 1. implicit autoincrement The following IDs get generated, + MySQL: 1,2,999,1000,1001 +...

Document MySQL, PostgreSQL, SQLite differences regarding auto increment and multi-insert

Actually, fuck it. The moment an INSERT or REPLACE statement inserts more than one row, we shouldn't bother with setting `lastAutoIncrementId`. It's just too complicated and too hacky. ----- Or......

Document MySQL, PostgreSQL, SQLite differences regarding auto increment and multi-insert

I decided to make it an entirely new issue, even. https://github.com/AnyhowStep/tsql/issues/93

Describe `ROUND(x)` WTFs

Well, not really a WTF. It's just that there are so many different ways to round numbers. https://en.wikipedia.org/wiki/Rounding#Round_half_to_even

Investigate SQLite ORDER BY outer query column not allowed

The above is a contrived example. But there may be valid use cases. Like not using `EXISTS()` and using stuff like `U.other / T.other`

Use a package name other than tsql

`twinql`? Like "twinkle". **Checks npm** Nope. [Already taken](https://www.npmjs.com/package/twinql)

Use a package name other than tsql

`ts-ql`? It hasn't been taken yet but I don't quite like the hyphen. And it's still too close to T-SQL

Use a package name other than tsql

`periwinql`? Like "periwinkle". Doesn't seem to have been taken yet.

Use a package name other than tsql

`sprinql` (sprinkle)?

Use a package name other than tsql

This library is basically a query builder (at its core) with a bunch of ORM-like features built on top.