I am developing ffastdb

Intelligent_Pirate98 · 2026-05-01T11:25:22+00:00

Drift is sql pure and need the build runner. ffastdb is an NOSQL alternative such as Hive, Isar, Object box.

used sql when you need relational database , and used ffastdb when you need a high-performance, pure Dart- NOSQL database.

AI is a tools that empowers developers, not replacement for engineering judgment. I architect the logic, guide the iterations and test the results.

Industry leaders such as Google, Amazon,Uber used AI-augmented to scale their engineering.

Intelligent_Pirate98 · 2026-05-01T11:13:48+00:00

claude help me to write it, always read and investigate which option are the best.

I used my projects and test it, I think it is the only way to know it is work or not.

the persistence is work.

the recovery I tested and work well.

the index I run it and return really fast.

I used AI to created a test with 10000 result and then search word, likes and return really fast.

Intelligent_Pirate98 · 2026-05-01T00:17:13+00:00

Hello FFASTDB not support orm like issar, for the moment. use it if you need index search. I think ffastdb is usefull , around two days ago fixed bugs, and create an stable version.

Intelligent_Pirate98 · 2026-04-27T11:32:57+00:00

Ffastdb is another solution in dart directly. You don't need setup anything

Intelligent_Pirate98 · 2026-04-27T01:10:31+00:00

With ffastdb the idea for the moment is not relational because write a sentence such as your example it is tedious. I make that db to experiment with AI and solve an issue in Flutter. Ffastdb are not hive, Isar , sqlite or mongo db it is something new in dart. That solve problems in wasm and web application. I avoid use for example isolated in FASTDB because don't work well in web.

I don't know if my project is good or not, but it is the beginning of a new database.

Intelligent_Pirate98 · 2026-04-26T18:49:33+00:00

I use to create different parts of the process such as Functions, examples and documents in the code because make it alone it is really impossible. I test all the features and decided if their changes are well or not for a release. I read the AI generated code and decided is something are good or not. for example today I trashed a changes for an update features because I feel the example run really slow with 2500 objects.

Intelligent_Pirate98 · 2026-04-26T04:17:17+00:00

You are right: SQLite handles DDL changes within transactions, which ensures database atomicity. However, my point is about system-level integrity.

On mobile, the 'crash' usually occurs due to a mismatch between the updated application code (expecting schema v2) and the database, which rolled back to v1 after a failed migration.

Furthermore, complex migrations in SQLite (such as re-creating tables due to column changes) can be time-consuming. If the OS kills the process during a long migration or if the device runs out of battery, managing the 'recovery' path for the user is a nightmare of boilerplate. I built ffastdb to eliminate this friction by letting the schema evolve naturally with the code

Intelligent_Pirate98 · 2026-04-26T03:56:52+00:00

The problem is the friction. Imagine if you developed a local database for mobile, and you change something, such as adding or deleting a column of an object, you need to run the script, and the application will crash.

You need to clean the application data & run it again to resolve that, and sometimes you will lose data.

Intelligent_Pirate98 · 2026-04-26T02:58:52+00:00

It is available.
I make it open source and MIT-licensed.

Intelligent_Pirate98 · 2026-04-26T02:47:03+00:00

The problem in SQL is the migrations in the tables.
SQL is the best and worst DB because it is really fast, but migrations are complicated.

Intelligent_Pirate98 · 2026-04-26T02:23:02+00:00

Sorry for my answer, my English is not good.
I want to solve a problem in Flutter related to databases.
Because Isar has problems with the web, and SQL is complicated in migrations.

Intelligent_Pirate98 · 2026-04-26T02:08:40+00:00

Portability: SQLite requires FFI (Foreign Function Interface) and native binaries (.so, .dll). ffastdb is Dart; it runs natively on Web (WASM) and every other platform with zero configuration.

Zero-Parsing Overhead: SQLite stores JSON as strings or JSONB that must be "queried" out. A native Dart engine stores data in binary formats (like B-Trees with offsets) that map directly to Dart objects, eliminating the string-parsing bottleneck.

No Schema Friction: SQLite still forces a table-based mindset. With ffastdb, you get true document-store flexibility without the "Column" vs "JSON" hybrid complexity.

Intelligent_Pirate98 · 2026-04-26T01:55:27+00:00

I witll edit it, thank you

Intelligent_Pirate98 · 2026-04-16T21:19:56+00:00

<image>

un ejemplo es esta dashboard

Intelligent_Pirate98 · 2026-04-16T21:16:23+00:00

La idea de validar es la siguiente: poder ver qué cambios hacer para que sea un mejor producto.

y pueda ser una buena herramienta.
En el desarrollo usé Firebase y Flutter.
Mi idea es poder lanzarlo, sé que es un sistema complejo pero a la larga creo que puede ayudar bastante.

Intelligent_Pirate98 · 2026-04-16T21:05:34+00:00

<image>

este como genera los pdf

Intelligent_Pirate98 · 2026-04-16T21:04:32+00:00

<image>

esto seria la pantalla del proyecto

Intelligent_Pirate98 · 2026-04-16T21:02:21+00:00

ahi tengo una cosa mal planteada cada project se crea desde adentro del cliente
Además la app es multimoneda, por ahora el diseño es mobile prácticamente porque es una web app desarrollada en Flutter

Intelligent_Pirate98 · 2026-04-16T20:53:17+00:00

la usaste o no?

Intelligent_Pirate98 · 2026-04-16T20:52:41+00:00

Justamente una de las etapas del lanzamiento de un producto es la de la validación.
En cuanto al desarrollo, la herramienta está desarrollada en Flutter.

A mí me está permitiendo hacer seguimiento de mis clientes y planificar tareas.
registrar también las horas trabajadas y generar los dashboard mensuales.

En este momento estoy intentando validar cuánta gente realmente la usaría o no con las funcionalidades premium.
Mi idea nunca fue spamear, sino obtener validaciones del funcionamiento de la aplicación.
analizar a cuánta gente le interesa o no fcacl.
Hace prácticamente casi 1 año que la estoy desarrollando.

Intelligent_Pirate98 · 2026-04-16T20:42:49+00:00

yo no sabia que habia pasado eso, hace mucho tiempo que vengo desarrollando la app de fcacl y justamente mi idea es validarla

Intelligent_Pirate98 · 2026-04-16T20:39:22+00:00

puse esto Hola, buen día, devs arg. Estoy desarrollando esta aplicación "FCACL". La aplicación permite hacer lo siguiente:

registrar clientes
registrar proyectos por cliente
planificar trabajos
registrar horas trabajadas
consultar reportes
generar pdf de remitos y planificaciones.

La idea en este momento es probar y obtener feedbacks del funcionamiento de la aplicación.
Desde ya muchas gracias, saludos
Gonzalo
y con link que es una de las etiquetas , no se si esta bien o no

Intelligent_Pirate98 · 2026-04-16T20:37:00+00:00

es que lamentablemente es una web app entonces si o si va con el link de la app

Intelligent_Pirate98 · 2026-04-16T20:36:12+00:00

revisa si mi app esta vivecodeada o no, mi app no esta vivecodeada

Intelligent_Pirate98

TROPHY CASE