In addition to the MySQL support, it would be great, if WebMatrix would support PostgreSQL databases too.

Native support or the possibility to expand the program functionality via plugins so third parties would develop a wrapper for those databases.

It would be nice if we could manage mongo db inside webmatrix

Since MySQL and SQL Server are supported, for those of us who have to write to Oracle DBs, adding in support for ODP.NET and PL/SQL would be fantastic.

I have mysql database that i can change with any program.
I made new php simple site, connected mysql database, when im trying to create new database im getting en error about syntax. If im creating table in for example phpmyadmin and then trying to change in webmatrix everything is ok.
Any suggestion to this?
Thanks.
Alexei, best regards

It would be great if I could just create and host a mysql database right from webmatrix without third-party programs.

When I have mysql db, and enter to any table I can delete any row in this table. But after DB/Table refresh it appear like was not removed..

Right click table , select definition an you can edit table, HOWEVER no way to set the row value as uniqe, no way to change identity seed, and when you create relation between tables there is no way to set rule for the relation ex. cascade delete, etc. - all this is available when you open same db in visual studio, the editor there allows you to do all that, so my guess it should be easy to add to webmatrix too

right click on table > copy to clipboard >
- short name
- long name
- insert statement
- update .....

I would be glad if it were possible to synchronize databases. Just so you do not have to touch it to an external device that can be carried out from the WebMatrix

In the databases view there is no way to insert multiline tekst into table fields.

Please make it possible to insert multiline tekst into the fields.

It would be nice if we can do copy-paste (or drug and drop) of the table data between two data bases (i.e. sdf files) including the format definition as well the contents. This is usefull when we import the table templates from multiple examples.

This is great stuff, but no options with SQl server logins, i mean choosing login users.

Не удалось создать базу данных.

Unable to connect to any of the specified MySQL hosts.

MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts.
в MySql.Data.MySqlClient.NativeDriver.Open()
в MySql.Data.MySqlClient.Driver.Open()
в MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
в MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
в MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
в MySql.Data.MySqlClient.MySqlPool.GetConnection()
в MySql.Data.MySqlClient.MySqlConnection.Open()
в Microsoft.WebMatrix.DatabaseManager.MySqlDatabase.MySqlDatabaseProvider.CreateDatabase(String adminConnectionString, String databaseName, String userName, String password)
в Microsoft.WebMatrix.DatabaseManager.IisDbManagerModuleService.CreateDatabase(DatabaseConnection databaseConnection, String configPathState)
в Microsoft.WebMatrix.DatabaseManager.Client.DBManagerController.CreateDatabase(ProviderInfo providerInfo, DatabaseConnection databaseConnection)
в Microsoft.WebMatrix.DatabaseManager.Client.DBManagerController.<>c__DisplayClassa.<AddDatabase>b__6()
в System.Threading.Tasks.Task.InnerInvoke()
в System.Threading.Tasks.Task.Execute()

An error occurred.

"C:\\Program Files (x86)\\nodejs\\node.exe" "C:\\Program Files (x86)\\nodejs\\node_modules\\npm\\bin\\npm-cli.js" "install" "mysql" "--json"

Error: EPERM, open 'C:\Users\mike\AppData\Local\Temp\npm-5796\1347568485418-0.6367941724602133\package\test\integration\Query\results\test-long-fields.js'
{ [Error: EPERM, open 'C:\Users\mike\AppData\Local\Temp\npm-5796\1347568485418-0.6367941724602133\package\test\integration\Query\results\test-long-fields.js']
errno: 50,
code: 'EPERM',
path: 'C:\\Users\\mike\\AppData\\Local\\Temp\\npm-5796\\1347568485418-0.6367941724602133\\package\\test\\integration\\Query\\results\\test-long-fields.js' }

Please try running this command again as root/Administrator.
50 errno

Failed: npm reported an error.

NodeNpm.NpmException: Failed: npm reported an error.
at NodeNpm.NpmApi.Install(INpmPackage package)
at NodeNpm.NpmPackageManager.InstallPackage(INpmPackage package)
at Microsoft.WebMatrix.NpmGallery.CachingPackageManger.InstallPackage(INpmPackage package)
at Microsoft.WebMatrix.NpmGallery.PackageViewModel.Install()
at System.Threading.Tasks.Task.InnerInvoke()
at System.Threading.Tasks.Task.Execute()

I don't know if it was the upgrade to version 2 but I no longer have the option to add a new table definition within the middle of other fields. The only option I have is to tab and add a table definition at the end. I no longer see the column menu to add a column item. What should I do to correct this? I hope I do not have to rekey all 100+ items in my table to get one field into a new location. Please assist....

Please add an option for creating a new database on the server of a host or anything besides locally. It would make it a lot easier.

I've just installed Webmatrix 2 on my Windows 7 64bits system and I'm playing around from W3school tutorials.
Everything goes well until I try to create SQL Server Compact database, either from the link in right pane and from the New database button in the ribbon. Then Webmatrix stops working.

Any idea

Sincerely yours

Jean-Philippe