[Valentina-studio] Feature list for Valentina Studio Admin 1.0

[Jochen Peters]

Hi Ramin,

> Sorry Jochen I didn't send this earlier. I'm just catching up to email.
>
> Great list of features you have so far. I had a few more suggestions. I
> haven't tried the latest version of Studio, so I don't know if these 
> are
> already there or not. If they are, or they're just plain stupid, please
> ignore me (:-)
>
> - Export/Import to XML.
- Dump/Load Dump XML is already implemented.

> - Dump/Restore in text format (for database replication/backup).
You can choose between XML and SQL Dump - both results in text files
Ramin, this is kernel functionality which can be easy used in vStudio.

> - Display detailed statistics on databases, tables, users, processes, 
> etc.
Yes - we have a detail view right now which shows table count , field 
and method count and
several other properties.
What should be added here in case of server db is some statistic about 
users and processes - we have talked about that before.

> - Add/remove compression and/or encryption.
Already implemented.

> - Ability to copy/paste table data and structure from one databases 
> into
> another.
Yes - i will add this to the feauture list because it is not explicitly 
mentioned there.

> - For server DB, I don't know if there will be users and privileges, 
> but if
> so, then it would be nice to be able to manage them too.
Yes - see above.

> And in the "would be nice" category:
> - Add-on tools to do database analysis, validate tables, compact DB, 
> etc.
Already implemented.

> - Ability to specify an XSLT 'filter stage' during import/export so 
> data can
> be transformed.
I am working right now on export/import - yes - we will have some 
filters here - at least
like in the current ODBC Utility.

> - Web-based interface to studio (a la PHPMySqlAdmin).
Hhhm - there is already a PHP module for Valentina available - so i 
think this
is not a vStudio feauture.

> - At least on Windows, a COM interface to Studio so it can be embedded 
> in
> apps or browser and/or scripted.
Yes, of course!
We will have AppleScript on Mac and COM on Windows!

>
-- 
Best regards,
Jochen Peters
PIIT GmbH

------------------------------------
http://www.valentina-db.de