Idea: Parity across database models

auraphp / Aura.SqlQuery

Independent query builders for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server.

MIT License

450 stars 83 forks source link

Idea: Parity across database models #158

Open designermonkey opened 6 years ago

designermonkey commented 6 years ago

A discussion of an idea more than an issue.

I just ran across an issue where I didn't realise the ON DUPLICATE KEY UPDATE didn't work on SQLite.

As there are ways to achieve the same thing in SQLite, would it be a good idea to try for feature parity across models and implement the database specific way of achieving the same result?

harikt commented 6 years ago

Hi there,

Are you looking for the replace functionality ? I believe depending on the drivers additional features are already in it. If you think something is missing please do send a PR.

designermonkey commented 6 years ago

I did not know about REPLACE, I will have a go with that.