Notes from porting a paginated-query pattern from a Postgres project to SQLite
(sqlx 0.8.x). The query assembled its response shape — an items array plus a
meta object — inside SQL, then tried to map it with query_as!. It worked on
pg. On SQLite it failed in ways that took three iterations to fully understand.
query_as! never deserializes. It expands to a struct literal whose| {"name":"FlashLab Control Token","symbol":"FLCT","description":"Research control token for the crypto-flashing experiment — deliberately NOT impersonating any major asset. One-variable control: identical architecture, supply, and pool parameters to the experimental arm; only name/symbol/metadata differ.","image":"https://gist.githubusercontent.com/adophilus/e890b85da0ef7d8546580dd609121393/raw/logo.svg","external_url":"https://github.com/adophilus/crypto-flashing"} |
Compiled Oct 3, 2026 · source: dev.events — IT hackathons accessible from Nigeria, each event checked against its official page · profile: TS fullstack, Rust, Web3, payments
Of 36 listed events, 18 are open to a non-student in Nigeria. The rest are students-only, region-locked, or closed (see bottom).
| # | Event | Prize | What to build | Deadline |
|---|---|---|---|---|
| 1 | PayPal AI Hackathon (Devpost) | $67.5k+ (1st $12k) | AI app that meaningfully integrates ≥1 PayPal technology. Public OSS repo + <3 min video | Nov 12 |
| 545827863 |
| 970054631 |
| // SPDX-License-Identifier: MIT | |
| pragma solidity ^0.8.24; | |
| // AGENDA | |
| // Develop a crowdfund smart contract | |
| // Adhere to best practices | |
| // Transfer & withdrawal support | |
| // Support for locked deposits | |
| // Support for pull out window | |
| // Multiple/concurrent funding |
A quick cheatsheet of useful snippet for Flutter
A widget is the basic type of controller in Flutter Material.
There are two type of basic Widget we can extend our classes: StatefulWidget or StatelessWidget.
StatefulWidget are all the widget that interally have a dynamic value that can change during usage. It can receive an input value in the constructor or reference to functions. You need to create two classes like:
Add the following line of code to /etc/apk/repositories to enable the @testing tag to install packages from the edge/testing repo
@testing https://dl-cdn.alpinelinux.org/alpine/edge/testing
| [2m2023-07-31T20:29:10.914426Z[0m [32m INFO[0m [2mkomorebi[0m[2m:[0m creating window manager from static configuration file: C:\Users\hp\.config\komorebi\komorebi.json | |
| [2m2023-07-31T20:29:10.922855Z[0m [32m INFO[0m [1minit[0m[2m:[0m [2mkomorebi::window_manager[0m[2m:[0m initialising | |
| [2m2023-07-31T20:29:10.991718Z[0m [32m INFO[0m [2mkomorebi::process_command[0m[2m:[0m listening on komorebi.sock | |
| [2m2023-07-31T20:29:10.992115Z[0m [32m INFO[0m [2mkomorebi::process_event[0m[2m:[0m listening | |
| [2m2023-07-31T20:29:19.837998Z[0m [32m INFO[0m [1mprocess_command[0m[1m{[0mFocusWorkspaceNumber(0)[1m}[0m[2m:[0m[1mfocus_monitor[0m[1m{[0m[3midx[0m[2m=[0m0[1m}[0m[2m:[0m [2mkomorebi::window_manager[0m[2m:[0m focusing monitor | |
| [2m2023-07-31T20:29:19.838078Z[0m [32m INFO[0m [1mprocess_command[0m[1m{[0mFocusWorkspaceNumber(0)[1m}[0m[2m:[0m[1mfocus_workspace[0m[1m{[0m[3midx[0m[2m=[0m0[1m}[0m[2m:[0m [2mkomorebi::window_manager[0m[2m:[0m focusi |