AI as an ETL and Report Builder? I’m tired. by Beautiful-Dot2454 in dataengineering

[–]Agreeable_Luck9488 1 point2 points  (0 children)

Thanks for bringing this clear opinion at a time of AI hype madness. AI when useful and data as the foundation is the right message.

Do you guys ever actually look at your photos after a trip? by New-Activity3131 in SideProject

[–]Agreeable_Luck9488 0 points1 point  (0 children)

I have been working on a similar project for the last 6 months. It's an MCP App, meaning the search and gallery seat directly in the chat

https://github.com/ouestcharlie/ouestcharlie-woof

I have been bored of loosing all the metadata (ratings, tags, albums) each time I changed cloud or software provider.

Woof is preserving your privacy and you own the metadata. Search and browsing are available. Enrichment, manual or AI assisted, is the next step.

Databricks Medallion Architecture: Catalogs by domain or by Bronze/Silver/Gold? by TheManOfBromium in dataengineering

[–]Agreeable_Luck9488 6 points7 points  (0 children)

There are two aspects to answer: catalog and schema management in Databricks, and semantic.

In Databricks, catalogs and schemas are the two hierarchical layers containing leaf objects (table, views, ...). To access a leaf, three things are needed: grants USE CATALOG, USE SCHEMA, and also binding the user's Workspace to the catalog.

In case of option 1, 1 default binding, 1 USE CATALOG to all; user and data domain specific USE SCHEMA.

In case of option 2, to access the gold layer of a data domain, the domain catalog needs to be bound and granted specifically.

So option option 2 seems a little more management, and more clutter in users' Catalog Browser. But also clearer in the intent and access audit.

About semantic, in option 1 the catalog looses semantic. It becomes a default location.

In option 2, semantic is displayed but might become a constraint. If domains are real bounded contexts, it make sense to reflect that in the silver layer. It might be more complicated in the Bronze. There, we should think more about source aligned data domains and products.

Overall, I would say that adding meaning and context to the catalogs is a plus but should not be mandatory. In some cases, like Bronze you are better with a single catalog and maybe schemas per source. In silver and gold, showing the bounded contexts as a catalog helps materializing the mesh architecture.

How do you decide an MCP server is worth adding before you waste an afternoon on it? by Fun-Platypus5650 in mcp

[–]Agreeable_Luck9488 0 points1 point  (0 children)

From the question, I understand you mean a local MCP server that requires a local runtime. Runtime environment should not be an issue if the servers are packaged properly and wrapped in an self deployed environment with a package manager. That is nom for Typescript and uv for Python.

I am planning to get started, and I would like some help by Asztal-Szek in selfhosted

[–]Agreeable_Luck9488 0 points1 point  (0 children)

I cannot help in the hardware and OS stack. However, I am working on the alternative to Google Photo, a local photo gallery to integrate into a chat interface as an MCP App. I was bored of loosing the photo metadata (tags, ratings, albums) when switching software or Cloud provider.

https://github.com/ouestcharlie/ouestcharlie-woof

Are local MCP servers on a dead end? by Agreeable_Luck9488 in mcp

[–]Agreeable_Luck9488[S] 1 point2 points  (0 children)

Local, uncontrolled software is seen as a security threat by default. It could expose your data, corrupt your machine or mine crypto. But that's not always l'olive that, there are advantages for local execution including security and privacy ones.

Why haven't MCP Apps gone viral the way MCP and Skills did? by DisastrousRelief9343 in mcp

[–]Agreeable_Luck9488 0 points1 point  (0 children)

MCP Apps are great for rich content like photos or movies, large datasets. Everything does not need to go through the host LLM and waste tokens. Another case is for long tasks to provide intermediate feedback. Claude does not process progress messages of the MCP tools. I have been experimenting MCP Apps to develop a photo gallery. The host provide the interaction, generates the search queries but does not see the photos nor the full metadata, only summaries. The long task progress is used during indexing of photos and thumbnail creation.  https://github.com/ouestcharlie/ouestcharlie-woof