2. PHPRunner Tips and Tricks
  3. How to store projects in your own database in Version 11.
This topic is locked

How to store projects in your own database in Version 11.

9/16/2024 12:54:06 PM
PHPRunner Tips and Tricks
Sergey Kornilov

Requires build 42408 or better of PHPRunner 11 or ASPRunner.NET 11.

Supported databases are MySQL, SQL Server, Postgre.

  1. Open version 11 of PHPRunner or ASPRunner.NET. Export projects you want to transfer to your own database. To do so you need to open the project, click Project -> Export. Leave all the default settings and export. Close the project, open the next one and export. This only needs to be done once. By default projects exports are stored in C:\runnerapps folder.


  2. Create an empty database. In my example it is a MySQL database named runnerprojects.


  3. Run version 11 of the software, create a new project and connect to this empty database. Close without saving.


  4. Open file C:\Users\<username>\AppData\Roaming\phprunner\userSettings.config in any text editor and find the connection you just made in the software.



{
"connString": "mysql;localhost;root;;;runnerprojects;;1",
"lastAccess": "Mon Sep 16 2024 12:31:46 GMT-0400 (Eastern Daylight Time)"
}

Copy the connection string.

  1. Open file C:\Users\<username>\AppData\Roaming\phprunner\programSettings.config in any text editor.

Under projectDatabase section change useBuiltinDatabase to false, paste your connection string there. This is how it is going to look.

"projectDatabase": {
"useBuitinDatabase": false,
"connectionString": "mysql;localhost;root;;;runnerprojects;;1"
},
  1. Start the software. You will be offered to create necessary tables in the project database. Click 'Create'.

img alt

This is it. You are now working with your own projects database.

  1. Now you can import the projects you exported on step 1. If you forgot to export project, you can modify programSettings.config again, setting useBuiltinDatabase to true and exporting your projects.


  2. Now you need to import View/Edit plugins into your new projects database. This article explains how this needs to be done:
    https://asprunner.com/forums/topic/30499-Version-11-Frequently-Asked-Questions
    This is also something that only needs to be done once.



Enjoy!

J
 		Jan K. van Dalen 9/16/2024

Hi, what a welcome news.

With that said, in view that we use both PHPRunner and ASPRunner.net, can both products share a single database?

Thanks
Sergey Kornilov 9/16/2024

Yes, you can store both ASPRunner.NET and PHPRunner projects in the same database but they will appear togther on the list. You can probably add PHP or ASP to the project name to avoide the confusion.

J
 		Jan K. van Dalen 9/17/2024

Thank you ... great feature
C
 		Chris Whitehead 9/18/2024

Great feature and works great.

I want to share projects between 2 computers, not to be worked on at the same time, just a laptop and a desktop by the same user, I can see I could have server just for the DB but the reason behind this is so I can work on the desktop and then work on projects when I'm away from home so wouldn't be able to access the projects unless I had them on a webserver, any ideas on which DB would be best for just syncing the files?

Dalkeith 9/18/2024

Can I just clarify - Does this mean that if we want we will be able to Isolate a project to an individual database? PS thanks for the newsletter very useful
C
 		Chris Whitehead 9/18/2024

@Dalkeith9 I would think yes but might be more fiddly, so they can all be a different DB but it might mean swapping the config files for each one, I'm thinking this more paves the way for multi dev from one DB server.
S
 		salus2 9/20/2024

Very cool feature. I can defintely see many advantages to this approach. Got me thinking, though, are there any instructions available on how to connect to and interact with the BuiltinDatabase?
Thanks