Florian Pieper | OCI | Ociswap

Building Ociswap - The Front Page of @radixdlt ⚡️ Breaking DeFi barriers 🐈

[Florian Pieper | OCI | Ociswap @f_pieper]

@beemdvp If you have an questions feel free to ask.

There is quite a bit to unpack 😂

[Florian Pieper | OCI | Ociswap @f_pieper]

@a_vaunt @theBullishBit @0xResearch @Ian_Unsworth @smyyguy @defi_kay_ @salveboccaccio @KaitoAI We kind of planned for Xian already by having a very self contained architecture with one pool normally not interacting with other components (potentially hot shards). So sharding will be easy and every pool could live in its own shard.

[Florian Pieper | OCI | Ociswap @f_pieper]

@daan_xrd Keep in mind you always need to jump the next shiny thing. Immediately 😂

[Florian Pieper | OCI | Ociswap @f_pieper]

@dazligth @xstelea @lu5st @astrolescent @timanrebel Yes 🔥

[Florian Pieper | OCI | Ociswap @f_pieper]

@xstelea @lu5st @astrolescent @timanrebel We have a preview swap endpoint

https://t.co/UTBQ0f9Ad6

This should do what you need 👌

Cool thing is that it also supports reverse swap routing giving the output amount instead of input amount 👌

[Florian Pieper | OCI | Ociswap @f_pieper]

@xstelea @lu5st @astrolescent @timanrebel We have a preview swap endpoint

https://t.co/UTBQ0f9Ad6

This should do what you need 👌

Cool thing is that it also supports reverse swap routing giving the output amount instead of input amount 👌

[Florian Pieper | OCI | Ociswap @f_pieper]

Will be awesome to have deep liquidity for all the top 50 on @ociswap soon 🥳

[Lukas @lu5st]

Ready to rock and roll with our upcoming @getanthic integration—now fully end-to-end! 🔥

https://t.co/x0wGkAgZOZ

[Florian Pieper | OCI | Ociswap @f_pieper]

When paginating SQL queries, the optimal page size for max throughput is probably much higher than you'd expect.

We only saw diminishing returns after hitting 10K rows per query!

Don't underestimate how fast modern computers have become. Your DB can handle it 💪

[Florian Pieper | OCI | Ociswap @f_pieper]

@NFIBTYF https://t.co/noDKPkDuFd

[Florian Pieper | OCI | Ociswap @f_pieper]

@NellySayon Thanks 👌 That's what I was originally looking for 🤣 but overlooked the table.

So yeah, using resource_holders it simplifies to the following query while having much better performance 🥳

[Florian Pieper | OCI | Ociswap @f_pieper]

You can get all holders of a token including their balance from the #Radix Gateway database using this SQL query 🤓

[Florian Pieper | OCI | Ociswap @f_pieper]

@0x_Qayzi https://t.co/noDKPkDuFd

[Florian Pieper | OCI | Ociswap @f_pieper]

@NellySayon Thanks 👌 That's what I was originally looking for 🤣 but overlooked the table.

So yeah, using resource_holders it simplifies to the following query while having much better performance 🥳

[Florian Pieper | OCI | Ociswap @f_pieper]

@NellySayon Thanks 👌 That's what I was originally looking for 🤣 but overlooked the table.

So yeah, using resource_holders it simplifies to the following query while having much better performance 🥳

[Florian Pieper | OCI | Ociswap @f_pieper]

@agct194721 @ociswap However, as an alternative to just burning OCI it could actually make more sense. Or maybe even in combination with regular fee burning.

Will think about and keep it mind. Always really happy to read when someone brings up good insights and ideas. Thank you 👌

[Florian Pieper | OCI | Ociswap @f_pieper]

@agct194721 @ociswap Thanks for your feedback 🙂. Protocol owned liquidity is interesting actually. I considered using it before we really started with the Babylon implementation of Ociswap. The reason why we moved away from it a bit is that you are buying liquidity and renting is imo more effective.

[Florian Pieper | OCI | Ociswap @f_pieper]

@agct194721 @ociswap You are welcome, sorry for the late reply was a bit busy with Anthic lately 🙂

[Florian Pieper | OCI | Ociswap @f_pieper]

@3mul4t0r 🤪

[Florian Pieper | OCI | Ociswap @f_pieper]

@proof_of_paul @ociswap @lu5st Thank you 🥳

Our integration with Anthic is ready to make a big SPLASH - bringing deep liquidity for wrapped assets to Ociswap 🚀

[Florian Pieper | OCI | Ociswap @f_pieper]

@Adam_XRD @ociswap only 👋😂

[Florian Pieper | OCI | Ociswap @f_pieper]

@daan_xrd 😂