Spent some time tweaking the Call Nextval dialog this morning. Finally got it just the way I wanted!
Totally forgot about Sequences when adding #PostgreSQL support. Finally got that done today!
The PostgreSQL Server Info panel in DataCollie is ready too! It's a v1, so features are a bit lean, but it covers all the essential metrics.
Here's the new #JavaFX #LinksOfTheWeek 🎉
www.jfx-central.com/links
Thanks to Igor Azarny, @maxiong.bsky.social, Anahata ASI, Artistic_Solution117, @frankdelporte.be, @starbuxman.joshlong.com @andresalmiray.com, Libán Bande González, Sombriks & Old_Assistance7!
Have a lovely #Java weekend!
PostgreSQL's privilege management is much more complex than MySQL's. Still, I'm making a little progress every day.
Built a MySQL server status dashboard from the limited metadata available.
#DataCollie #MySQL
Spent the past few days building user and privilege management for MySQL in DataCollie.
It’s a surprisingly complex module, with many layers of inheritance. MySQL 8 adds even more moving parts: dynamic privileges, role-based access control, and privilege inheritance.
Designing new DBA modules to make database management less of a chore. What’s missing in your current stack?
I’m working to make DataCollie ’s ER diagram experience the best in its class — both in capability and in how it feels to use.
#BuildInPublic #JavaFX
I’ve been working on ER diagrams for DataCollie, and it’s making real progress.
#JavaFX #BuildInPublic #Database
Finished the last two pieces of DataCollie’s SQLite support today: Query Console integration and Stella, my Data Agent.
Both are now done.
DataCollie has reached another milestone. 🚀
Spent tonight wrapping up DataCollie’s SQLite support, filling in the last pieces for table design: CHECK constraints and triggers.
SQLite support is almost done. 🚀
Leave it to the users to answer.
Tonight, I finished DataCollie’s SQLite index metadata support and management features.
One step closer to completing SQLite support. 🚀
