Bubba|two

Discuss development on Bubba
Tim
Posts: 36
Joined: 16 Jun 2007, 03:18
Location: Australia

Re: Ah, meet the next gen

Post by Tim » 30 Jul 2008, 07:46

zhaeon wrote:On the flipside, MySQL has marketshare.
If you like something that is widely used try SQLite http://www.sqlite.org/mostdeployed.html instead of MySQL :o

SQLite is not a universal solution (don't use it for gigabytes+ of data), but if you need to quickly deploy a medium size data-driven website or use a local SQL file store, its performance and ease of use are difficult to beat - It also has native support by PHP 5 and Python. Downsides of SQLite are no GRANT/REVOKE (but would you use it on a simple web site?), VIEWS are not directly updateable (but can be done with triggers), triggers must be FOR EACH ROW, No FOREIGN KEYS (use triggers). You can probably tell that I am a fan :) Probably because I use C and Python.

You are right about Informix, I was involved in a large deployment on the MIPS platform in the 1980s - It was one of the most horrid jobs I have ever been given.

carl
Posts: 474
Joined: 07 May 2008, 04:41

Post by carl » 30 Jul 2008, 09:35

A reason we have for using MySQL is the use-case of a non-über-techie developing an own web-page on the bubba. Probably the most known SQL-server for that person is MySQL.
/Carl Fürstenberg, Excito Software Developer
http://www.excito.com
support@excito.com

Tim
Posts: 36
Joined: 16 Jun 2007, 03:18
Location: Australia

Carl - MySQL

Post by Tim » 30 Jul 2008, 11:29

carl wrote:A reason we have for using MySQL is the use-case of a non-über-techie developing an own web-page on the bubba. Probably the most known SQL-server for that person is MySQL.
Interesting commercial choice (not a criticism). I note that you are going to use Lighthttpd in BUBBA|TWO. So do we infer that you have sacrificed the most well known web-server (Apache), so that you then have the resources left to Run MySQL? :) - Please note that I actually prefer Lighthttpd to Apache. It, like SQLite, is designed for ease of use on small devices where resource allocation may be a problem.

A cynical person might infer that the main reason that you are using MySQL is because it is Swedish? (Joke!). I know we 'all' like MySQL, but for a newbie SQLite is easier (trust me) - It is a single file installation that is normally included in the standard PHP5 install so you don't even have to configure it.

I do have a legitimate reason for my caution concerning MySQL, whilst it is made available under a GPL licence, commercial distributions can require that a commercial licence is purchased from MySQL (and now, presumably, Sun). I used to write (and sometimes distribute) commercial software, so the licence was not suitable for me. The normal SQLite licence is 'Public Domain'.

So can you confirm that we, as users, are covered by a commercial licence if we use MySQL for any (potentially commercial) purpose?

Binkem
Posts: 388
Joined: 10 Jul 2008, 02:26

Post by Binkem » 30 Jul 2008, 15:57

For me as a server noob its helpful that the bubba|two will run mySQL. I want to run my current (WordPress-based) site on the bubba. I know that there is a WordPress for SQlite, but keeping WordPress up to date and using add-ons is easier using mySQL.

carl
Posts: 474
Joined: 07 May 2008, 04:41

Re: Carl - MySQL

Post by carl » 01 Aug 2008, 17:19

Tim wrote:
carl wrote:A reason we have for using MySQL is the use-case of a non-über-techie developing an own web-page on the bubba. Probably the most known SQL-server for that person is MySQL.
Interesting commercial choice (not a criticism). I note that you are going to use Lighthttpd in BUBBA|TWO. So do we infer that you have sacrificed the most well known web-server (Apache), so that you then have the resources left to Run MySQL? :) - Please note that I actually prefer Lighthttpd to Apache. It, like SQLite, is designed for ease of use on small devices where resource allocation may be a problem.

A cynical person might infer that the main reason that you are using MySQL is because it is Swedish? (Joke!). I know we 'all' like MySQL, but for a newbie SQLite is easier (trust me) - It is a single file installation that is normally included in the standard PHP5 install so you don't even have to configure it.

I do have a legitimate reason for my caution concerning MySQL, whilst it is made available under a GPL licence, commercial distributions can require that a commercial licence is purchased from MySQL (and now, presumably, Sun). I used to write (and sometimes distribute) commercial software, so the licence was not suitable for me. The normal SQLite licence is 'Public Domain'.

So can you confirm that we, as users, are covered by a commercial licence if we use MySQL for any (potentially commercial) purpose?
The MySQL commercial license is only required if you want to use MySQL is a product and you cant/wont follow the GPL or any appropriate FOSS licenses. As this is not the case for us (We are trying to follow the GPL to both the letter and the spirit), a commercial license isn't required, nor is it wanted (It would add a neat sum of 500$ to the cost per unit).
/Carl Fürstenberg, Excito Software Developer
http://www.excito.com
support@excito.com

Tim
Posts: 36
Joined: 16 Jun 2007, 03:18
Location: Australia

Re: Carl - MySQL

Post by Tim » 01 Aug 2008, 20:12

carl wrote:The MySQL commercial license is only required if you want to use MySQL is a product and you cant/wont follow the GPL or any appropriate FOSS licenses. As this is not the case for us (We are trying to follow the GPL to both the letter and the spirit), a commercial license isn't required, nor is it wanted (It would add a neat sum of 500$ to the cost per unit).
Thanks Carl. That is good...
/Tim

carl
Posts: 474
Joined: 07 May 2008, 04:41

Re: Carl - MySQL

Post by carl » 17 Aug 2008, 07:47

Tim wrote:
carl wrote:The MySQL commercial license is only required if you want to use MySQL is a product and you cant/wont follow the GPL or any appropriate FOSS licenses. As this is not the case for us (We are trying to follow the GPL to both the letter and the spirit), a commercial license isn't required, nor is it wanted (It would add a neat sum of 500$ to the cost per unit).
Thanks Carl. That is good...
/Tim
There have been a change in the software setup; At least initially, we will ship with apache instead of lighttpd, due to a problem with lighty and uploading of files.

/Carl
/Carl Fürstenberg, Excito Software Developer
http://www.excito.com
support@excito.com

Hammer
Posts: 124
Joined: 02 Oct 2007, 13:37

Post by Hammer » 19 Aug 2008, 03:26

Nooo! Apache hasn't worked out for me on the Bubba 1, haven't been able to do any web site design at all.

This means I will have to reconsider my pre-order and perhaps go for a QNAP TS-509.

*sigh*

carl
Posts: 474
Joined: 07 May 2008, 04:41

Post by carl » 19 Aug 2008, 09:49

Hammer wrote:Nooo! Apache hasn't worked out for me on the Bubba 1, haven't been able to do any web site design at all.

This means I will have to reconsider my pre-order and perhaps go for a QNAP TS-509.

*sigh*
We are going to do everything to make lighttpd work, though in the short term, to allow file upload via the web interface, lighty made it not possible.

/Carl
/Carl Fürstenberg, Excito Software Developer
http://www.excito.com
support@excito.com

solsson
Posts: 5
Joined: 24 Feb 2007, 07:49

Post by solsson » 01 Sep 2008, 02:56

Is it easy to switch between lighthttpd and apache on port 80, and still run bubba's web-based tools?

I need to host a Subversion repository, which requires Apache2. As with the choice of database, I hope there is an easy way for users to switch, so we can stop fighting about which one is the best :) Switching is easy in Debian, so it all depends on the compatibility of the bubba packages.

/Staffan

Post Reply