--- title: "Ebube Okorie (@kelviniot) | Hashnode" description: "Web3 Developer. Read the latest articles by Ebube Okorie on Hashnode." url: "https://hashnode.com/@kelviniot" --- @kelviniot # Ebube Okorie @kelviniot · Joined December 2021 Web3 Developer ### [Into The Weeds: ADVANCED SQL FEATURES](https://kelviniot.hashnode.dev/into-the-weeds-advanced-sql-features?utm_source=hashnode&utm_medium=feed) When interacting with Databases, modern JS frameworks have kind of made it standard to work with ORMs. ORMs like Knex.js, Lucid in AdonisJS. These ORMs are very helpful with schema type safety, migrations, clean code, abstractions. But are these abst... 3 min read · [kelviniot.hashnode.dev](https://kelviniot.hashnode.dev/into-the-weeds-advanced-sql-features?utm_source=hashnode&utm_medium=feed) [Dec 26, 2023](https://hashnode.com/posts/into-the-weeds-advanced-sql-features/658a1e0aa3d1345338fe4dd2) ### [Optimizing your web app using PWA features.](https://kelviniot.hashnode.dev/optimizing-your-web-app-using-pwa-features?utm_source=hashnode&utm_medium=feed) Progressive web apps are built with the philosophy of progressively enhancing the performance of your web application. So your application probably works just fine currently, but you are now thinking of ways to make your application more perfomant, m... 3 min read · [kelviniot.hashnode.dev](https://kelviniot.hashnode.dev/optimizing-your-web-app-using-pwa-features?utm_source=hashnode&utm_medium=feed) [Sep 30, 2023](https://hashnode.com/posts/optimizing-your-web-app-using-pwa-features/6517af1ed6300bdf4d31442a) ### [The Building Blocks of Programming: An In-Depth Look at ASTs](https://kelviniot.hashnode.dev/the-building-blocks-of-programming-an-in-depth-look-at-asts?utm_source=hashnode&utm_medium=feed) An AST(Abstract Syntax Tree) is a data structure used to represent the syntax of most programs during compilation. It is used to represent the structure of a program. This is helpful for tools like compilers, code linters, and interpreters. Most to... 3 min read · [kelviniot.hashnode.dev](https://kelviniot.hashnode.dev/the-building-blocks-of-programming-an-in-depth-look-at-asts?utm_source=hashnode&utm_medium=feed) [Sep 18, 2023](https://hashnode.com/posts/the-building-blocks-of-programming-an-in-depth-look-at-asts/6507d0deee13edaa3522c03b) ### [SMPP - the protocol for sending sms between devices.](https://kelviniot.hashnode.dev/smpp-the-protocol-for-sending-sms-between-devices?utm_source=hashnode&utm_medium=feed) WHAT In simple terms, SMPP (short messaging peer to peer) is the protocol which makes sms possible. Just like HTTP, SMTP… SMPP is also an open, industry standard protocol. It enables flexible exchange of data between devices also known as ESME(Extern... 3 min read · [kelviniot.hashnode.dev](https://kelviniot.hashnode.dev/smpp-the-protocol-for-sending-sms-between-devices?utm_source=hashnode&utm_medium=feed) [Sep 12, 2023](https://hashnode.com/posts/smpp-the-protocol-for-sending-sms-between-devices/6500a23608cb1d30c5bf22ba) ### [Layer Zeros on the Blockchain](https://kelviniot.hashnode.dev/layer-zeros-on-the-blockchain?utm_source=hashnode&utm_medium=feed) WHAT ARE LAYER ZEROS Layer zero’s are basically core infrastructures that enable blockchains to be built on them. It is like the road that enables blockchains to function. Layer zero’s can provide the mechanisms and tools for building blockchains and... 2 min read · [kelviniot.hashnode.dev](https://kelviniot.hashnode.dev/layer-zeros-on-the-blockchain?utm_source=hashnode&utm_medium=feed) [Jul 3, 2022](https://hashnode.com/posts/layer-zeros-on-the-blockchain/62c1f96ac0401b3dcbcfb3c6)