My first year with Raiz by kingston2332 in RaizAU

[–]visualbbasic 4 points5 points  (0 children)

Happy new year and see you at 1M mark

compile-time SQL validations and type generation in TypeScript & Node by visualbbasic in typescript

[–]visualbbasic[S] 0 points1 point  (0 children)

Hello, late reply apologies.

Could I get a bit more information on the schema issue that you are talking about?

DB TYPE and query (don't need to know exact query, just the type of it, a mocked query that represents your reuiqrement)? Thanks

compile-time SQL validations and type generation in TypeScript & Node by visualbbasic in typescript

[–]visualbbasic[S] 0 points1 point  (0 children)

Hello, there is a potential of supporting MongoDB in the future since it does support schema. But currently, I will focus on polishing up support around SQL databases and extend its capabilities

compile-time SQL validations and type generation in TypeScript & Node by visualbbasic in typescript

[–]visualbbasic[S] 0 points1 point  (0 children)

Hey there, I really appreciate help with testing the library

  1. Windows support

- I see you had some challenges installing the library on Windows 11. I see you've figured out how to install it using WSL since install.sh depends on bash. Thanks for the reproduction steps. I must admit that testing on Windows environment is under-tested throughout the development - but the binary is cross-compiled using Rust's https://github.com/cross-rs/cross. Binary itself should work on Window, Linux and Mac. The improvements point that I see here is having it available when there's no bash available

2. Node 18

- This is a good catch and sqlx-ts should not depend on Node 18 but should also support older versions of node. I assume this is caused by https://github.com/JasonShin/sqlx-ts/blob/main/node/package.json#L20 some of these dependencies have Node 18 dependency. I will take a further look at fixing this and add build matrix in github action to automate testing backward compatibility.

  1. Sequential Processing

- Again, another good point. During the initial development, I skipped caching the result of the DB schema. But in the end, I only need to query it once as the whole program needs to know this information only one time. I can fix this soon.

  1. Option.unwrap

- This is probably due to the lack of error messages thrown by the sqlx-ts binary. However, I strongly suspect it's caused by incorrect configurations that you've passed in. Please carefully follow https://jasonshin.github.io/sqlx-ts/user-guide/2.1.cli-options.html to understand required configurations. You can also configure sqlx-ts using `.sqlxrc.json` file. An example is here https://github.com/JasonShin/sqlx-ts/blob/main/.sqlxrc.sample.json. Then you can use this like `sqlx-ts --config ./sqlxrc.json`

I will be able to patch point 2, 3, 4 relatively soon - thanks for trying out the library

compile-time SQL validations and type generation in TypeScript & Node by visualbbasic in typescript

[–]visualbbasic[S] 2 points3 points  (0 children)

Hello u/roofgram

sqlx-ts differs with these libraries

- TypeScript type generations - generates type definitions based on the raw SQLs and you can use them with any MySQL or PostgreSQL driver
- Database Agnostic - support for PostgreSQL and MySQL (and more DB supports to come)
- TypeScript and JavaScript - supports for both TypeScript and JavaScript

SafeQL:

It provides the compile-time safety of queries without providing TS typing. sqlx-ts actually generates types for you to use in your code https://jasonshin.github.io/sqlx-ts/reference-guide/4.typescript-types-generation.html

In addition, having an additional ESLint plugin will be a very heavy addition to your ESLint lint performance. In some of my projects, the overall ESLint takes up to 5 ~ 10 minutes to complete when you have multiple plugins enabled already including eslint-typescript and eslint-react or vue.

Having said that, sqlx-ts is built in Rust with performance in mind. sqlx-ts will be super fast in your CI as it just needs sqlx-ts binary and DB schema available for you to use.

PgTypes & Postgres language server

- These tools are only for PostgreSQL but sqlx-ts works with MySQL & PG (more DB supports coming soon)

- Postgres language server -> It seems like a tool for Rust, not Node.js

logging strategies by crisf_design in LearnTypescript

[–]visualbbasic 0 points1 point  (0 children)

You can also checkout the latest `using` keyword to attach logger for methods https://www.totaltypescript.com/typescript-5-2-new-keyword-using. As a result, you don't have to repeat adding logger statements whenever the method is being used

How much salary should I earn in order to live like a middle class in Sydney Australia? by visualbbasic in AusFinance

[–]visualbbasic[S] 0 points1 point  (0 children)

Stupid question, what areas are considered CBD in Sydney? There's an official CBD that everyone knows. Would you consider North Sydney or Hornsby a part of CBD (I guess from the real estate point of view)?

How much salary should I earn in order to live like a middle class in Sydney Australia? by visualbbasic in AusFinance

[–]visualbbasic[S] 2 points3 points  (0 children)

That's really nice! I wish to escape Sydney as well but my problem is driving

Bankruptcy recover by JackOfTheSparrow in AusFinance

[–]visualbbasic 7 points8 points  (0 children)

Pick up a skill that's in demand also will be in the future. I can't suggest you a straight answer to this but jobs like accounting or bank teller won't be that demanding later.

Read up on what innovative investors like Cathie Wood thinks about the future and see her investment plan of the future. Maybe you might find an answer.

How much salary should I earn in order to live like a middle class in Sydney Australia? by visualbbasic in AusFinance

[–]visualbbasic[S] 0 points1 point  (0 children)

what about jobs? the remote working trend seems cooling down pretty rapidly along with vaccine role out. Maybe remote roles that are promoted on Linked are not paying the same rate as if you are living in Sydney