Edit procedures/functions

[jankaraffa]

Hello,
All of our application logic currently resides in database procedures and functions. From an enterprise perspective, this approach divides team responsibilities and enables us to test backend features independently. Do you plan to support editing procedures and functions in LibreDB?

[cevheri]

Four open requests point at one missing abstraction.

Request	Reporter	Asks for	Actually blocked by
#710	nktnet1	Show views and materialised views on PostgreSQL	There is no object-kind concept
#765	ket000	Oracle with 43,512 tables and 910,000 columns freezes the UI on connect	There is no container level and no lazy loading
#778	jkaraffa-allegro	Edit procedures and functions	There is no source text and no DDL apply path
#773	-	Double-click a table for a data preview	There is no tree interaction model

[cevheri]

My Firt Decisions

Decision	Choice	Rationale
Scope	One model, three phases	The four requests share one gap
Tree shape	Full tree: containers, kind folders, objects, lazy per node	Industry standard, single model for every engine
First paint	Container list plus the active container expanded with kind counts	Small databases must not pay the large ones' cost
Escape hatch	Connection-level "do not scan on open" plus an explicit load action	#765 reporter's own stated preference
Migration	One large PR: DatabaseObject replaces TableSchema, getSchema() removed, major version	End-to-end verification of one coherent state beats debugging a half-migrated one
Acceptance	All 17 type-ids verified live before merge	The migration choice rests on acceptance testing, so acceptance is the load-bearing part
DDL authority	The database is the boundary, not the UI role	A user can already run CREATE OR REPLACE in the query editor; restricting the tree button adds no capability

[cevheri]

Phase 1: new schema/object browser(for now it only shows):
function, procedure, view, package, trigger, materialized views etc.. #811 (comment)

[cevheri]

Phase2: #820

[cevheri]

Phase3: #831

[cevheri]

completed with #811, #820, #831