UseMySqlDatabase()

Got an idea for enhancing PureBasic? New command(s) you'd like to see?
User avatar
DoubleDutch
Addict
Addict
Posts: 3220
Joined: Thu Aug 07, 2003 7:01 pm
Location: United Kingdom
Contact:

Re: UseMySqlDatabase()

Post by DoubleDutch »

Coder14: Would the Maria lib not work, you should be able to bundle that.
https://deluxepixel.com <- My Business website
https://reportcomplete.com <- School end of term reports system
User avatar
DoubleDutch
Addict
Addict
Posts: 3220
Joined: Thu Aug 07, 2003 7:01 pm
Location: United Kingdom
Contact:

Re: UseMySqlDatabase()

Post by DoubleDutch »

Freak: I don't mean include the whole maria database system - just the interface lib (that will also let you interface to MySql).
https://deluxepixel.com <- My Business website
https://reportcomplete.com <- School end of term reports system
coder14
Enthusiast
Enthusiast
Posts: 327
Joined: Tue Jun 21, 2011 10:39 am

Re: UseMySqlDatabase()

Post by coder14 »

DoubleDutch wrote:Coder14: Would the Maria lib not work, you should be able to bundle that.
@DoubleDuth: Checked it out after reading yours posts about it and downloaded it too. But I cannot find any static library in the package. I also cannot find a Mac version for it.

Is it true that using the libmysql.lib in my program infringes the license?
User avatar
DoubleDutch
Addict
Addict
Posts: 3220
Joined: Thu Aug 07, 2003 7:01 pm
Location: United Kingdom
Contact:

Re: UseMySqlDatabase()

Post by DoubleDutch »

https://deluxepixel.com <- My Business website
https://reportcomplete.com <- School end of term reports system
coder14
Enthusiast
Enthusiast
Posts: 327
Joined: Tue Jun 21, 2011 10:39 am

Re: UseMySqlDatabase()

Post by coder14 »

Thanks for that. Unfamiliar territory!

I downloaded the 64bit msi package and that contained the lib and dll (earlier one was the zip package). But after the substitution

Code: Select all

;Import "libmysql.lib"
Import "libmariadb.lib"
my program waits forever at

Code: Select all

If mysql_real_connect(...)
It basically does not authenticate. Any idea why?


Alternatively, is it possible to connect to a remote SQLite database? Like it is done with PostgreSQL:

Code: Select all

If OpenDatabase(0, "host=remoteHost port=5432", "user", "password")
:?:
User avatar
DoubleDutch
Addict
Addict
Posts: 3220
Joined: Thu Aug 07, 2003 7:01 pm
Location: United Kingdom
Contact:

Re: UseMySqlDatabase()

Post by DoubleDutch »

I've no idea why it didn't work.

sqllite has to be local I think.
https://deluxepixel.com <- My Business website
https://reportcomplete.com <- School end of term reports system
Fred
Administrator
Administrator
Posts: 18162
Joined: Fri May 17, 2002 4:39 pm
Location: France
Contact:

Re: UseMySqlDatabase()

Post by Fred »

If it's LGPL, we could try to add a DLL support for it.
User avatar
DoubleDutch
Addict
Addict
Posts: 3220
Joined: Thu Aug 07, 2003 7:01 pm
Location: United Kingdom
Contact:

Re: UseMySqlDatabase()

Post by DoubleDutch »

:)
https://deluxepixel.com <- My Business website
https://reportcomplete.com <- School end of term reports system
User avatar
captain_skank
Enthusiast
Enthusiast
Posts: 639
Joined: Fri Oct 06, 2006 3:57 pm
Location: England

Re: UseMySqlDatabase()

Post by captain_skank »

Native mariadb/mysql conectivity is something I'd gladly pay hard earned cash for.

Just sayin :)
Fred
Administrator
Administrator
Posts: 18162
Joined: Fri May 17, 2002 4:39 pm
Location: France
Contact:

Re: UseMySqlDatabase()

Post by Fred »

Don't hesitate to make your offer in PM :)
User avatar
captain_skank
Enthusiast
Enthusiast
Posts: 639
Joined: Fri Oct 06, 2006 3:57 pm
Location: England

Re: UseMySqlDatabase()

Post by captain_skank »

Actualy in all seriousness Fred, and at the risk of upsetting people, I think registered users should pay for major revison upgrades.

So for example this next release would be version 6 and the charge would be 50% to 75% of the current purchase price.

Minor revisions / bug fixes ( 6.1, 6.2 etc ) would be free.

This would guarantee the PB team a revenue stream of sorts and would maybe aid planning future PB development.

I'll buy PB again if you roll in mariadb support and will happily part with cash as i stated above.

PB is my language of choice and is ceratainly worth paying more for imho and I'll happily buy PB again if you roll in mariadb support.

Roll in IMAP suport and i'll buy another copy as well :)
sys64802
Enthusiast
Enthusiast
Posts: 105
Joined: Sat Sep 12, 2015 6:55 pm

Re: UseMySqlDatabase()

Post by sys64802 »

captain_skank wrote:Actualy in all seriousness Fred, and at the risk of upsetting people, I think registered users should pay for major revison upgrades.
Just donate and don't ask Fred to become a liar.
You can donate without limits. Act now.
HanPBF
Enthusiast
Enthusiast
Posts: 570
Joined: Fri Feb 19, 2010 3:42 am

Re: UseMySqlDatabase()

Post by HanPBF »

Donation: how much for what???

Missing -> Microsoft SQL Server access ("only" ADOMate), ORACLE access ("only" oci.dll), etc.

Yes, ADOmate and OCI.dll work well, but native PB support would be great!

Same with a current WebGadget? WebKit possible?

Or continuously sell the additional non LGPL libs as add-ons.
It's nothing wrong with that; so even license fees can be routed through to vendor.
User avatar
captain_skank
Enthusiast
Enthusiast
Posts: 639
Joined: Fri Oct 06, 2006 3:57 pm
Location: England

Re: UseMySqlDatabase()

Post by captain_skank »

sys64802 wrote:
captain_skank wrote:Actualy in all seriousness Fred, and at the risk of upsetting people, I think registered users should pay for major revison upgrades.
Just donate and don't ask Fred to become a liar.
You can donate without limits. Act now.
Not sure where i'm calling anyone a liar in my statement.

I want the PB to continue and I don't see that donations are the way to go.

I would like to see PB add functionality that users request ( where feasable ) and am happy to pay for it, but why should only one person 'donate' and others get something for free. Everyone paying for the next major version seems more egalitarian to me.

And if a user doesn't want to pay for the next major edition becasuse they won't use a new feature, then they can stick with the version they have.

Or have a premium addition where users can pay extra for additional functtionality, like most other commercial languages.

It's just my opinion however. :)
sys64802
Enthusiast
Enthusiast
Posts: 105
Joined: Sat Sep 12, 2015 6:55 pm

Re: UseMySqlDatabase()

Post by sys64802 »

captain_skank wrote: Not sure where i'm calling anyone a liar in my statement.
This is not a rhetoric question and you shouldn't ignore it: what are you talking about ?
sys64802 wrote: Just donate and don't ask Fred to become a liar.
I'll explain it further: "don't ask Fred to become a liar" is different from "don't call Fred a liar".
If you ask Fred to change the license from "updates free forever" to "pay for each update" you are asking him to become a liar.
PureBasic.com wrote: The updates are unlimited, unlike most other software out there. This means than when you buy PureBasic you will get all future updates for free, on this web site
captain_skank wrote: I want the PB to continue and I don't see that donations are the way to go.
Just donate more. If you would like Fred to get more money then donate, talk about PB to other people and try to bring more users here, just don't try to screw the current users who found the license appealing.
captain_skank wrote: I would like to see PB add functionality that users request ( where feasable ) and am happy to pay for it, but why should only one person 'donate' and others get something for free.
Ah ! You say you want to donate BUT ONLY if other people donate too because you don't like they get for free the same things you think you are buying.
That's why are called donations. You donate as a token of your appreciation to the project, the people, the concept. You are not buying new features, but you can ask and hope for them.
So just donate if you want to inject more money in Fred's pockets and don't make excuses or petty arguments.
captain_skank wrote: Everyone paying for the next major version seems more egalitarian to me.
No, it isn't.
Many people have certainly chosen PB over something else because there were not (there are not) further costs beyond the initial registration.

To promise free update forever it's a good way to build an initial user base easily and faster, this in turn create a larger community supporting a product which needs a community since it's compatible only with itself.

But if you promise free updates forever and than backpedal on that you are a liar. No ways around this.

You say you want to shell more money for PB, but only if you can force everyone else to do the same. I really hope you don't succeed.

The only thing Fred could do without becoming a liar, is to make new rules for potential new customers.
They are not users of the product so they have no rights and he's not tied to them by a previous license.

But this could hardly work well, because previous users would inevitably rub that to the face of new users every time a new update come out instead of keeping their mouths shut as they should.

You for example wouldn't like that if you were a new user, it's evident.

So it can be tried but at this stage I find this a bad idea.

Would have been different if this was clear from the start:

I'm writing a new programming language ! Beta is open and when 1.0 will come out every beta tester who contributed in some way (I'll be the judge) will get a lifetime license as a thank you !
(this way you are buying beta testers, as you need them)

The 1.0 is out ! You can register to the product for 100$ and you'll have lifetime updates if you register in the next 12 months ! After that everyone will have to pay 30% of the current full price for every update.

So you get beta testers, some of them are rewarded with a FREE product forever, some early (paying) adopters will make the bulk of the new starting community and get free updates forever, and the rest will finance the project in time.

If ones doesn't want this and makes a different choice like Fred did, then if he changes his mind you can call him liar, and many people have any right to be very, very upset.
captain_skank wrote:And if a user doesn't want to pay for the next major edition becasuse they won't use a new feature, then they can stick with the version they have.
And why he should ? He has any right to have free updates forever. If YOU don't like this and want a different license, you should pay for him too.

So take the shortcut and donate for him too.

You have a different view, that's fine as long you can make your view work without changing the current license for other people.

It's not important if someone else agrees with you, I could even agree too for what you know, but if just one people does not that's enough, unless you pay the upgrades for him too.

Just donate and don't envy who doesn't.
Post Reply