Upgrade SQLx dependency to 0.6.x

[billy1624]

Motivation

Upgrading SQLx dependency as well as the downstream dependencies such as time, uuid, bigdecimal, etc.

Tasks

• Upgrade to SQLx 0.6.x
• Upgrade to time 0.3.x
  • Support time 0.3.x #788
• Upgrade to uuid 1.x
  • Bump Uuid version to 1.0.0 #689

Additional Information

Potential Breaking Changes

• Sqlite chrono::DateTime<FixedOffset> timezone fix launchbadge/sqlx#1618
  SQLite chrono::DateTime<FixedOffset> timezone fix
  • DateTime<FixedOffset> will be stored in SQLite with the correct timezone instead of always in UTC.
    This was flagged as a "potentially breaking change" since it changes how dates are sent to SQLite.
• pool fixes and breaking changes launchbadge/sqlx#1901
  Pool fixes and breaking changes
  • Renamed PoolOptions::connect_timeout to acquire_timeout for clarity.

[tyt2y3]

Is there a PR for this yet?

[billy1624]

No active PR at the moment :P

[tyt2y3]

0.9 release definitely depends on this

[Sytten]

Yeah agreed, needs an update to time. I am wondering if chrono support should be just removed, its basically deprecated.
It's a bit annoying that when using sqlx-postgres, chrono gets added automatically and also the CLI defaults to chrono without a flag for time.

[tyt2y3]

Regarding unwanted dependencies, I think we can take advantage of ? dependency and solve that

[tyt2y3]

sea-query and sea-schema is already upgraded to sqlx 0.6 and released
@billy1624 sea-orm side can assign to you?
Or you'd need help from Ivan?

[tyt2y3]

I am wondering if chrono support should be just removed, its basically deprecated

I also don't oppose to change the default in SeaORM if a lib is deprecated. However is there an authoritative source for this information?

[Sytten]

Well its not dead but no release in two years and unpatched vulnerability. The current master is very different from the current release. You can keep it with the ? Thats true.

[ikrivosheev]

sea-query and sea-schema is already upgraded to sqlx 0.6 and released
@billy1624 sea-orm side can assign to you?
Or you'd need help from Ivan?

@tyt2y3 did you mean me?

[tyt2y3]

sea-query and sea-schema is already upgraded to sqlx 0.6 and released
@billy1624 sea-orm side can assign to you?
Or you'd need help from Ivan?

@tyt2y3 did you mean me?

Haha yes

[billy1624]

Yeah agreed, needs an update to time. I am wondering if chrono support should be just removed, its basically deprecated. It's a bit annoying that when using sqlx-postgres, chrono gets added automatically and also the CLI defaults to chrono without a flag for time.

Hey @Sytten, do you mean generate entity with datetime field defined with time types?

• #661: Add flag to sea-orm-cli to generate code for time crate #724

[billy1624]

sea-query and sea-schema is already upgraded to sqlx 0.6 and released @billy1624 sea-orm side can assign to you? Or you'd need help from Ivan?

Yes, please! I've created a PR for this but it's still WIP. Please check #834 and see if you have anything to add. Just feel free to push commits to the branch.

I'll get back and work on it tomorrow. Thanks! :D

[billy1624]

Hey everyone, #834 is ready for review! :)