Table Prefix option when installing OSC

[Guest]

I am about to start my own mod to do this, but if it's already been done, or is going to be implemented in a new version on OSC, I'd like to know before I dig this thing apart.

 

I'd like to be able to add a database table prefix at install time so I can run more than one osc shop from a single database. (I believe this may be pretty common for today's web hosting packages.)

 

If anyone would like to get involved with this, or knows of a contribution that already does this, please email me.

 

Thanks,

Will "BassFace" Inglis

[Guest]

I'm about 90% done with modifying the Install process to include a table prefix option and have it automatically modifying/rewriting the oscommerce.sql file to reflect the prefix before database creation.

 

Anyone interested or have any ideas on how to proceed from here? Or am I the only one with a single database at my disposal? :P

[mhormann]

I second the idea in general.

 

With many providers, you can just have one database per account, and there just 'might' be more than osC. :-" And I DO agree that not just everybody can be as lazy as me... just buying some more accounts and only using their database connectors :rolleyes:

 

Should probably be made part of the core, in one of the next MSs.

[Guest]

Not sure if this is worth continuing right now. As you mentioned, this should be a part of the core for the next release (all the other OS carts are doin' it, it's cool :blink: ). Another reason for adding this in at the next release version is this: Even if I get OSC running with the table prefixes, if I add even one mod that creates a db table, it'll most likely break at least some of the app. I think I read here that at this point, it is expected that current mods will no longer work anyway, so just add the prefix thing in now so devs can re-work their mods to include it from the start.

 

(I may still continue to do this mod for my own purposes and to learn more about OSC. Doubt I'll release it to the public, though, for reasons stated above. I'd feel really bad if my mod broke a bunch of people's stores!)

[Guest]

Not sure if this is worth continuing right now. As you mentioned, this should be a part of the core for the next release

Before you're sure it'll be in the next release, check the development workboard. I don't know one way or the other, but assuming a new feature doesn't get it there. :)

 

(I may still continue to do this mod for my own purposes and to learn more about OSC. Doubt I'll release it to the public, though, for reasons stated above. I'd feel really bad if my mod broke a bunch of people's stores!)

That's too bad. I'm sure that others here could benefit from your work. If it's just messing up someone's store that you're worried about, don't be. Just write up decent installation instructions and remind folks to back up first.

 

-jared

[Guest]

OK, I have completed the mod. B) If anyone would be interested in testing this (sort of a beta test) please email me. Ive made it to be used as a fresh install, where a table prefix is added right along with the database name, user name, etc during the install process. Further details if your interested of course! :thumbsup:

[Guest]

Before you're sure it'll be in the next release, check the development workboard.  I don't know one way or the other, but assuming a new feature doesn't get it there.  :)

 

This is in the MS3 CVS right now.

[Guest]

Any idea when this new release will be released? And where are you finding this info about it? Thanks!

[Guest]

No idea when it will be released. Probably middle of next year at the earliest.

 

As for where I get the information, there are numerous threads about it in the development and news forums plus I am on the status updates and CVS commits email lists. You can download a CVS version of what is done so far by visiting here: http://www.oscommerce.com/community/cvs

 

Daily snapshots are created but unless you track the commits list, you don't know when the public CVS has changed. I am currently running the snapshot from Dec 06 on my local development server. Not ready for production, not even close but good enough to test and work with locally.

[DJF]

OK, I have completed the mod.  B)  If anyone would be interested in testing this (sort of a beta test) please email me.  Ive made it to be used as a fresh install, where a table prefix is added right along with the database name, user name, etc during the install process.  Further details if your interested of course!  :thumbsup:

<{POST_SNAPBACK}>

 

 

Yes I would be interested in trying your mod.

DJF

[DJF]

Yes I would be interested in trying your mod.

DJF

<{POST_SNAPBACK}>

 

 

I received and installed the table prefix mod tonite. It worked exactly as I had hoped for, and now my database tables for the OSCommerce are grouped and easily separated from other unrelated tables.

It was easy to do and worked first time.

Thanks

[Guest]

Any Chance of this coding please, I know this post is over a year old plus the rest, but very interested.