Page 1 of 1

Can OC 3.0.3.6 support interfacing with other databases?

Posted: Mon Apr 24, 2023 5:26 am
by jrr
I've hunted the extensions and didn't see anything like what I wanted there. Probably missed something I'm sure!

What I am trying to do is to list a group of parts that have certain specifications.

The specifications could easily be listed in a DB or possibly a spreadsheet, but what I would like to see if something like:
------------------(part listing)------------------
Light Bulb part number: 89
Specifications
Voltage: xx
Wattage: yy
Candlepower: zz
Base Style: aa
Bulb Style: bb
and so on:
----------------(end of listing)-----------------
All those specification values (xx, yy, ...) would be in a lookup table and the data would be inserted when the potential customer is looking at the particular light bulb/transistor/resistor/etc.

I suspect I need a developer at this point.

I do think this is an extension that would help a large number of OC users who want to sell parts - so perhaps a developer would like to work with me in designing this and my site could be the guinea pig for a nominal cost?

Or this would be for just my business's use only and I would pay accordingly for the full ownership rights to the developed extension.

If that is how these things work out around here.

Thanks!

John :-#)#
OC 3.0.3.6
phpMyAdmin
PHP 7.3.33

Re: Can OC 3.0.3.6 support interfacing with other databases?

Posted: Mon Apr 24, 2023 8:32 am
by straightlight
If secondary databases are enlisted in the same environment, you could simply use the PDO library that is also available from the core. However, an extension does need to be developed for this since you are looking to gather specific listings.

Re: Can OC 3.0.3.6 support interfacing with other databases?

Posted: Wed Apr 26, 2023 1:41 pm
by jrr
straightlight wrote:
Mon Apr 24, 2023 8:32 am
If secondary databases are enlisted in the same environment, you could simply use the PDO library that is also available from the core. However, an extension does need to be developed for this since you are looking to gather specific listings.
How busy are you these days?

John ;-#)#

Re: Can OC 3.0.3.6 support interfacing with other databases?

Posted: Wed Apr 26, 2023 7:13 pm
by SohBH
Product specifications can be entered as attribute.
There are ready made extensions available to filter by attribute.
Let me know if you need any further assistance with web design for it.

Re: Can OC 3.0.3.6 support interfacing with other databases?

Posted: Wed Apr 26, 2023 10:17 pm
by straightlight
jrr wrote:
Wed Apr 26, 2023 1:41 pm
straightlight wrote:
Mon Apr 24, 2023 8:32 am
If secondary databases are enlisted in the same environment, you could simply use the PDO library that is also available from the core. However, an extension does need to be developed for this since you are looking to gather specific listings.
How busy are you these days?

John ;-#)#
Sent you a PM.