User Name
Password

Go Back   Planetarion Forums > Non Planetarion Discussions > Programming and Discussion
Reload this Page Database Licences
Register FAQ Members List Calendar Arcade Today's Posts

Reply
View First Unread View First Unread  
Thread Tools Display Modes
Unread 8 Dec 2004, 09:56   #1
Dante Hicks
Clerk
 
Join Date: Jun 2001
Posts: 13,940
Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.
Database Licences
Not a strictly technical query, but software licence related :

We're getting an application based on an Sybase (SQL) backend. Sybase will run on a server obviously, and then various machines will have clients installed on them to use said database. For each machine we're installing the application on, we need a SQL licence (or for each user) which costs something like £120 per person.

The database will contain some general information that will be useful to a far wider range of people than just the users (maybe 300 people to see the data, only about 10 actual proper users). Could I (legally) just use a PHP/Apache style solution to ODBC to the db for simple read queries so all 300 could see some of the data without buying 300 seperate licences?

Sorry this is such a stupid question, but I'm genuinely unsure how restrictive these licences are.
Dante Hicks is offline   Reply With Quote
Unread 8 Dec 2004, 10:16   #2
sayonara
Shai Halud
 
sayonara's Avatar
 
Join Date: Aug 2001
Location: Sunny Leeds \o/
Posts: 2,127
sayonara is just really nicesayonara is just really nicesayonara is just really nicesayonara is just really nicesayonara is just really nice
Re: Database Licences
What exactly does the license cover?
__________________
meow
sayonara is offline   Reply With Quote
Unread 8 Dec 2004, 19:33   #3
Supernova9
m u p p e t
 
Join Date: May 2001
Location: Whenever Wherever
Posts: 477
Supernova9 is infamous around these parts
Re: Database Licences
Quote:
Originally Posted by Dante Hicks
Not a strictly technical query, but software licence related :

We're getting an application based on an Sybase (SQL) backend. Sybase will run on a server obviously, and then various machines will have clients installed on them to use said database. For each machine we're installing the application on, we need a SQL licence (or for each user) which costs something like £120 per person.

The database will contain some general information that will be useful to a far wider range of people than just the users (maybe 300 people to see the data, only about 10 actual proper users). Could I (legally) just use a PHP/Apache style solution to ODBC to the db for simple read queries so all 300 could see some of the data without buying 300 seperate licences?

Sorry this is such a stupid question, but I'm genuinely unsure how restrictive these licences are.
I don't think you can. I read the Sybase licence agreement (you can find it easily at sybase.com), and specifies you need concurrent user licences for everyone who wants to access the database at any point. You wouldn't need to purchase 300, probably only 50, because not all 300 possible people will use it at once. However, I don't think you can legally use a workaround like you suggested.

Licencing agreements are horrific to decipher sometimes - I work as a Software Compliance Manager, and so part of my job is this bollocks. Companies often make it intentionally difficult to decipher, so that people buy more than they need, just in case, and thus company makes more money.
__________________
Supernova9 is offline   Reply With Quote
Unread 8 Dec 2004, 19:43   #4
Dante Hicks
Clerk
 
Join Date: Jun 2001
Posts: 13,940
Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.
Re: Database Licences
How utterly gay. I suppose I could just do a 24hr dump to MySQL or a .CSV file.
Dante Hicks is offline   Reply With Quote
Unread 8 Dec 2004, 22:33   #5
NEWSBOT3
NEWSBOT
 
Join Date: Dec 2000
Location: The enby cave!
Posts: 4,872
NEWSBOT3 needs a job and a girlfriendNEWSBOT3 needs a job and a girlfriendNEWSBOT3 needs a job and a girlfriendNEWSBOT3 needs a job and a girlfriendNEWSBOT3 needs a job and a girlfriendNEWSBOT3 needs a job and a girlfriendNEWSBOT3 needs a job and a girlfriendNEWSBOT3 needs a job and a girlfriendNEWSBOT3 needs a job and a girlfriendNEWSBOT3 needs a job and a girlfriendNEWSBOT3 needs a job and a girlfriend
Re: Database Licences
Quote:
Originally Posted by Dante Hicks
How utterly gay. I suppose I could just do a 24hr dump to MySQL or a .CSV file.

you can ODBC connect to mysql databases.
jsut need the driver, which is on the mysql site.
__________________
[20:27:47] <nodrog-aawy> **** i think my housemate just caught me masturbating
[11:25:32] <idimmu> you are a little piggy arent you
[13:17:00] <KaneED> i'm so closet i'm like narnia
__________________
Pretty parks and funky scrap metal things here
NEWSBOT3 is offline   Reply With Quote
Unread 8 Dec 2004, 22:34   #6
Dante Hicks
Clerk
 
Join Date: Jun 2001
Posts: 13,940
Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.
Re: Database Licences
Yeah I know, that side of things isn't a problem. It's the Sybase side of things I'm worried about (which the program has to run on unfortunately).
Dante Hicks is offline   Reply With Quote
Unread 9 Dec 2004, 14:56   #7
Supernova9
m u p p e t
 
Join Date: May 2001
Location: Whenever Wherever
Posts: 477
Supernova9 is infamous around these parts
Re: Database Licences
Quote:
Originally Posted by Dante Hicks
How utterly gay. I suppose I could just do a 24hr dump to MySQL or a .CSV file.
Yeah, that would be fine, they can't restrict what you do with data access once it's outside their software's storage.

Now imagine dealing with scenarios like this 5 days a week, especially when it's always software that you've never heard of and you don't have a clue who licenses or manufactured it because it's so specialised (Oh the joys of working for the Met Police!)
__________________
Supernova9 is offline   Reply With Quote
Unread 9 Dec 2004, 17:46   #8
NEWSBOT3
NEWSBOT
 
Join Date: Dec 2000
Location: The enby cave!
Posts: 4,872
NEWSBOT3 needs a job and a girlfriendNEWSBOT3 needs a job and a girlfriendNEWSBOT3 needs a job and a girlfriendNEWSBOT3 needs a job and a girlfriendNEWSBOT3 needs a job and a girlfriendNEWSBOT3 needs a job and a girlfriendNEWSBOT3 needs a job and a girlfriendNEWSBOT3 needs a job and a girlfriendNEWSBOT3 needs a job and a girlfriendNEWSBOT3 needs a job and a girlfriendNEWSBOT3 needs a job and a girlfriend
Re: Database Licences
Quote:
Originally Posted by Dante Hicks
Yeah I know, that side of things isn't a problem. It's the Sybase side of things I'm worried about (which the program has to run on unfortunately).
how very shit
__________________
[20:27:47] <nodrog-aawy> **** i think my housemate just caught me masturbating
[11:25:32] <idimmu> you are a little piggy arent you
[13:17:00] <KaneED> i'm so closet i'm like narnia
__________________
Pretty parks and funky scrap metal things here
NEWSBOT3 is offline   Reply With Quote
Unread 9 Dec 2004, 18:30   #9
GReaper
The BOFH
 
GReaper's Avatar
 
Join Date: Mar 2001
Posts: 463
GReaper has a brilliant futureGReaper has a brilliant futureGReaper has a brilliant futureGReaper has a brilliant futureGReaper has a brilliant futureGReaper has a brilliant futureGReaper has a brilliant futureGReaper has a brilliant futureGReaper has a brilliant futureGReaper has a brilliant futureGReaper has a brilliant future
Re: Database Licences
As Supernova9 says, the license limits concurrent users of the database at any one point in time.

If you're doing some sort of web based solution, then its very unlikely the number of concurrect connections to the database will be that high. Lets say 10 people have a page open, refreshing every 60 seconds. Unless all connect at the very same time then the chances are you'll only have one connection to the database at a time.

You could use some PHP script to limit access to the database to just one page loading at a time. Assuming most queries execute within hundredths of a second, then this wouldn't be a problem.

I'm not entirely sure if the license would allow this, as I'm a little confused with the license agreement.
GReaper is offline   Reply With Quote
Reply

« Previous Thread | Programming and Discussion | Next Thread »


Forum Jump


All times are GMT +1. The time now is 16:18.
Planetarion - Top

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2002 - 2018