Domain: mysql.org
Stories and comments across the archive that link to mysql.org.
Comments · 59
-
Re:Anonymous Coward
I've used Eventum and it is a nice package. Here are some of the pros and cons that I found in using the software a couple of versions back.
Pros: Nice interface for management and non-developer types, can segregate by project, allows adding in custom fields, customization for workflow, supports e-mail for communications, upload of attachments, integration with some version management software, command line options for script processing.
Cons: If you don't have managers or non-developer types than probably overkill, doesn't allow viewing bugs across all projects, login has to be associated with e-mail address, doesn't allow viewing bugs unless you are logged in.
-
Sysadmins
As an 'expert' system administrator (albeit unpaid) I have four servers. One is running Microsoft Windows Small Business Server 2003, one is running Microsoft Window Server 2003, one is running Ubuntu Linux 5.10 (Server), and the other is running Apple OS X Server (10.4).
I can tell you now that when I first started my company, although I was a major advocate of Linux, I soon found that I did not have the time to maintain a then Gentoo or custom LFS distribution, Debian was far too heavy to pick up, and Slackware felt a little dated. So I took a look at Microsoft Windows Small Business Server 2003, liked what I saw, and bought a Dell PowerEdge 400SC with an OEM install.
At first Small Business Server was a breath of fresh air. It was easy to maintain, with a full complement of features, having been bundled with Microsoft Exchange, Microsoft SQL Server, and Window Sharepoint Services. I actually enjoyed - yes, enjoyed - using it.
Until backup stated to fail. Until my tape drive disappeared. Until the sharepoint website database got corrupted. Until exchange monitoring failed. Until the POP connector started to thrash the CPU. Until the Windows Update website failed to check for updates.
These things happened. I'm not saying that they wouldn't happed with another system, but that is not the point, since they happened to me, and that caused me grief, and time, and money to resolve. I ended up trying to build a new system based on Microsoft Windows Server 2003, since I already had Microsoft specific data (files and tables), but this proved even more difficult to maintain.
I struggled for eighteen months, and then decided to build an Ubuntu 5.10 server. I use Ubuntu on one of my laptop, and had gently learnt the apt- way, and liked it. I set up a server with similar features to the Small Business Server, using Postfix, MySQL, and Plone, and even went some ways to transferring my sharepoint data. It works. It hasn't failed yet.
I bet the guys who took part in the survey only set up a server, installed some applications, and patched it. I bet they didn't try running a business for 18-months, just to see what it was really like.
I must say that we recently purchased an Apple PowerMac, and were so impressed we are now looking at completely switching, hence the OS X Server. It is a dream to install and configure, but we are going to run it for several months until we are satisfied that it can do the job. -
A good DB and a pile of worthless junk
They also have a half-baked ticketing system that they promote alternatively as a PM tool or a bug tracker, which I narrowly avoided having to migrate to from Bugzilla.
-
Eventum
A bit of shameless self promotion (since I am the lead developer), check out Eventum.
It might not be the perfect fit for you, but it is stable and customizable. Right now it is lacking built in customer management features, instead it relies on a Customer API to integrate with other systems. Right now I am working on integration with Sugar CRM but do not yet have an ETA on when it will be released. -
Re:our brains aren't wired to think in parallel
My browser and other browsers are downloading this exact same page.. look it's parallel programming and no one had to do anything special.
I'm gonna bet there are a lot of groups and developers that completely disagree with that statement. I'm thinking of the Apache Group, MySQL developers, Perl developers, Slashcode developers, Linux developers, etc...
-
Re:so...
Sorry, I was not referring to the CLI interface at all. The only thing I have used that for is to import some databases from a PHPMyAdmin dump.
I'm using the GUI tools from the MySQL site:
http://mysql.org/downloads/gui-tools/5.0.html
I just assumed that most people- especially those familiar with SQL Server would be using the GUI. -
Eventum?
MySQL's trouble-ticket system Eventum was developed for internal/customer-facing use, and GPL'd.
http://eventum.mysql.org/wiki/index.php/Main_Page
Anyone tried it? -
EventumThis is a shameless plug since I am the main developer, but you should look at Eventum. It was developed for the MySQL AB support team, and then released back to the community. That last release was quite some time ago but development is active. It is PHP / MySQL based and installs on most systems in just a few minutes. Here are some of the main features:
- Auto-creation of new issues from email
- Email integration - With proper setup, once an issue is created you can use issue-1234@yourdomain.example.com to send email to everyone on the issues notification list. This can be helpful since it allows the issue tracking system to keep track of all communication on an issue without being intrusive.
- Command line interface - You can view details, change assignment, status, record time, etc from the command line instead of logging into the web interface.
- Flexibility - Eventum can be extended / customized using the workflow API (Basically you can add custom code to be called when a certain event happens). Eventum also can be integrated with a CRM system.
- Custom fields - You can define new fields from the web interface if you need a field Eventum doesn't provide out of the box.
</shameless plug> -
Re:Please explain
You might want to inform MySQL AB and tell them to update their page at http://www.mysql.org/doc/refman/5.1/en/se-falcon-
l imits.html which says "Foreign key support is currently not available." I'm sure they'll be thrilled to hear the news. -
Alpha limitations
http://www.mysql.org/doc/refman/5.1/en/se-falcon-
l imits.html
No foreign key support.
No "select for update".
Online backup is not supported.
Serializable isolation levels are not supported.
Yes, I'm fully aware that it is an alpha release. -
Re:Multiple different storage engines....
I realise your post doesn't say that Slashdot are using MyISAM, but just to make it clear, Slashdot are using InnoDB http://www.mysql.org/doc/refman/5.1/en/innodb-ove
r view.html. -
Re:Please explain
This is a real quick, detailess explanation, but explanation nonetheless... Essentially there are several options for "storage engine", each with its own set of features... The vanilla engine w/ MySQL is MyISAM, which among other things doesn't support transactions. In lieu of these shortcomings there is also the InnoDB engine, which does do transactions, etc.
The Falcon engine is from a renowned database developer, and as such has all sorts of neat features. -
What to do? read, Read, READ!Go the college route only IF you can afford it, and IF the college has a well developed and staffed CS/IT department. If it hasn't then you are just throwing away your money, which would be much better spent on a decent library of text-books. Assuming you decide to teach yourself then you'll need to learn a language or three. I'd suggest you learn what the OO paradigm is all about. These languages are pretty good implementations of it:-
- Smalltalk - The original OO language and programming environment
- Ruby - OO in a sane file oriented environment
- SQL - You'll need to store your data somehow
- C and C++ - Get these downloadable books FAQ & Tutorial.
-
Re:How OSS dooms itself to failure
I think you're trolling, but I'll bite. There are other, easier guides to follow for the installation of MythTV. The Wiki on MythTV is helpful, and so are the numerous forums for each distribution of linux. (At least, the ones where I've searched have been helpful).
I don't see how you can predict the death of OSS based on the documentation. The documentation for other OSS projects is just as convoluted (see MySQL or Apache's HTTP server) and they're not going away anytime soon. -
L(W)AMP is all you need
All of these are open source, built on LAMP, and run great on Windows.
HW & SW inventory: Winventory (http://winventory.sourceforge.net./
Trouble ticketing: Eventum (http://eventum.mysql.org/wiki/index.php/Main_Page ). The Anonymous Reporting Form is a time saver.
Cacti (http://www.cacti.net./ Graphs all parameters on your servers and routers.
Documentation: TikiWiki (http://tikiwiki.org/tiki-index.php). It has articles, FAQs and LDAP integration.
FreeMind (http://freemind.sourceforge.net/wiki/index.php/Ma in_Page). Mind maps are a FANTASTIC tool for documentation and you can publish them easily on a web server (get 0.8.1 beta3).
These are free, and get the job done.
SysInternals's tools (http://www.sysinternals.com./ Process Explorer and TCPView are the most useful, and there are many other great utils.
KiXtart (http://www.kixtart.org./ The best language for login scripts, and just about all your scripting needs on Windows.
Network Notepad (http://www.networknotepad.com./ Draw your nework diagrams here, and then publish them on your web server. -
Because....
......there are more dumb people than smart people in the world.
-
eventum
We recently starting using a tracking system, our QA person came in did some research and told us that the system with the simplest interface for the reporters was Eventum. So we have been using and it seems to work pretty well very customizable so you can hide all of the scary options if need be. http://eventum.mysql.org/
-
Re:This just in!!!
But let me know when I can download thousands of pirated games that run on Mac OS X.
Also, someone please let him know when he can download thousands of anti-spyware/trojan/virus packages to run with his pirated games.
Or let me know when I can run SQL Server 2000 or something comparable in power and flexibility on Mac OS X.
Ummm... okay, here's Oracle for OS X. Or maybe you prefer Sybase Adaptive Enterprise Server? Or if you want something free, but enterprise quality there's PostgreSQL. Or something free, flexible and fast that's decent enough to power slashdot there's mysql.
SQL Server is decent for small to medium-sized databases, but you're not going to be handling tables mesured in gigabytes in SQL server like in sybase, db2, or oracle. Not unless Microsoft really puts a lot more work into SQL Server and the memory management of Windows itself. -
Here are my facts...
As an 'expert' system administrator (albeit unpaid) I have four servers. One is running Microsoft Windows Small Business Server 2003, one is running Microsoft Window Server 2003, one is running Ubuntu Linux 5.10 (Server), and the other is running Apple OS X Server (10.4).
I can tell you now that when I first started my company, although I was a major advocate of Linux, I soon found that I did not have the time to maintain a then Gentoo or custom LFS distribution, Debian was far too heavy to pick up, and Slackware felt a little dated. So I took a look at Microsoft Windows Small Business Server 2003, liked what I saw, and bought a Dell PowerEdge 400SC with an OEM install.
At first Small Business Server was a breath of fresh air. It was easy to maintain, with a full complement of features, having been bundled with Microsoft Exchange, Microsoft SQL Server, and Window Sharepoint Services. I actually enjoyed - yes, enjoyed - using it.
Until backup stated to fail. Until my tape drive disappeared. Until the sharepoint website database got corrupted. Until exchange monitoring failed. Until the POP connector started to thrash the CPU. Until the Windows Update website failed to check for updates.
These things happened. I'm not saying that they wouldn't happed with another system, but that is not the point, since they happened to me, and that caused me grief, and time, and money to resolve. I ended up trying to build a new system based on Microsoft Windows Server 2003, since I already had Microsoft specific data (files and tables), but this proved even more difficult to maintain.
I struggled for eighteen months, and then decided to build an Ubuntu 5.10 server. I use Ubuntu on one of my laptop, and had gently learnt the apt- way, and liked it. I set up a server with similar features to the Small Business Server, using Postfix, MySQL, and Plone, and even went some ways to transferring my sharepoint data. It works. It hasn't failed yet.
I bet the guys who took part in the survey only set up a server, installed some applications, and patched it. I bet they didn't try running a business for 18-months, just to see what it was really like.
I must say that we recently purchased an Apple PowerMac, and were so impressed we are now looking at completely switching, hence the OS X Server. It is a dream to install and configure, but we are going to run it for several months until we are satisfied that it can do the job. -
What about a AoE and c-jbdc and maybe Mysql?
Storage with AtaOverEthernet. The cheapest Midium size storage...
And write a fs wrapper to acces clusterd jdbc proyect...
And mysql as file repository?
Ata Over Ethernet
http://freshmeat.net/projects/aoelinux/
Ata Over Ethernet tools
http://freshmeat.net/projects/aoetools/
c-jbdc
http://c-jdbc.objectweb.org/
Mysql
http://mysql.org/ -
Re:I call bull
"closed source has no real advantage on open source." -->Except for that little thing called "Developers getting paid"...
Since when does being "closed-source" mean "getting paid"? Yes, many companies base their model on closed source. Many others base their model on open source, and make plenty of money.
So wake up and smell the coffee! Times change, and your FUD-like statements are just so provably wrong.
Didn't you see the article yesterday on how open source drives down the cost of startup?
Don't imply F/OSS isn't good for business. It's just not good for your limited understanding of business. -
Re:Better than PostgreSQL?
This Sybase move now means that I can download and play with a serious database. It's a smart move because it means that I will be gaining skills in programming for that database engine, skills which are seriously marketable.
Okay, I have to comment on this. First, You've been able to download and play with a *serious* database for some time now. Second, Sybase...seriously marketable? Where? DB2, Oracle. Those are seriously marketable. Microsoft SQL Server to a lesser extent. Sybase to a lesser extent. More marketable than PostgreSQL and MySQL, probably in a commercial proprietary environment, yes. In the OSS world, no. Market share has a lot to do with the marketability of specific DMBS experience.
There are highly capable DBMS available already. From the ubiquitous PostgreSQL and MySQL to the less familiar Firebird, SAPDB, and Ingres, I'd say there's again almost too much choice in the OSS world.
This is a noteworthy announcement from Sybase, but nothing more than Score: 3, Interesting.
All that being said, it would be different if Sybase literally were to open source their product. The reason for this being that while they have diverged since 6.x, Microsoft SQL Server and Sybase were once one-and-the-same. The divergence is, I'm willing to bet, still a minority of the codebase. Making Sybase a drop-in replacement for SQL Server in an OSS environment would be killer.
-
Expect to see more of this...Expect to see more of this dual licensing stratergy, at least for now.
You can already see this in OpenOffice.Org and in MySQL. I am also attempting this in my EDL Language Project. I do not think it is a bad thing and will in the long term enrich free/open software.
Dual Licensing is a very good intermediatory from a proprietary to a free software environment.
-
2nd Opinion...At http://fsbench.netnation.com/ you'll find a nice python tool that will run Bonnie and/or IOzone with different parameters and stick the results in a MySQL database and make nice little tables from the data.
There is also some commentary and recommendations based on their results.
One more note about the tool... it's not well documented but works well when configured... note that you need a kernel that supports the filesystems to be tested (duh!), Use python 2.2, the database schema is somewhere in the comments.
-
Re:slashdotted =)Absoloutely correct. The webuser login should not even have PERMISSION to touch the tables directly -- all access to the DB should be via stored procedures. This eliminates the possibility of a SQL injection attack. Of course there are idiot developers out there who insist on using a crappy database which doesn't have stored procedures (or which has finally just introduced limited and buggy stored procedures in it's latest version).
For people who've never worked with a real database, stored procedures work kind of like SUID programs in Unix: they run with their OWNER's permissions instead of the calling user's permissions. This allows you to let a user manipulate a table in a very controlled manner. For example, in this (contrived) Transact-SQL example:
CREATE TABLE dbo.SecurityInfo(
Using this code, a web user will only be able to update his own password, assuming the client code manages the SessionCookie securely. This is as it should be.
UserName char(32) not null,
PasswordHash char(32) not null,
CONSTRAINT PK_SecurityInfo PRIMARY KEY CLUSTERED (UserName)
)
-- populated with cookie on successful user login
CREATE TABLE dbo.SessionInfo (
UserName char(32) not null,
SessionCookie char(32) not null
CONSTRAINT PK_SesionInfo PRIMARY KEY CLUSTERED (UserName, SessionID)
go
REVOKE select, insert, update, delete ON SecurityInfo FROM WebUser
REVOKE select, insert, update, delete ON SessionInfo FROM WebUser
go
CREATE PROCEDURE SetMyPassword (
@SessionCookie char(32) = NULL
@OldPasswordHash char(32) = NULL,
@NewPasswordHash char(32) = NULL,
@Success bit OUTPUT
) AS
UPDATE SecurityInfo
SET PasswordHash = @NewPasswordHash
WHERE UserName = (SELECT UserName FROM SessionInfo WHERE SessionCookie = @SessionCookie)
AND PasswordHash = @OldPasswordHash
IF @@ROWCOUNT = 1 AND @@ERROR != 0 SELECT @Success = 1
ELSE SELECT @Success = 0
GO
GRANT execute ON SetMyPassword TO WebUserHowever, if we had given the webuser SELECT and UPDATE permission on the SecurityInfo table, and had this code fragment in a PHP script:
$dbq = $db->execute("UPDATE SecurityInfo SET PasswordHash=$NewHash WHERE UserName = (SELECT UserName FROM SessionInfo WHERE SessionCookie = $SessionCookie) AND PasswordHash=$OldHash");
This leaves us open to a SQL injection attack. If the user were able to set $OLDHASH to"'bogushash'\nGO\nSELECT * FROM SecurityInfo\nGO\nSELECT * FROM SessionInfo"
due to a bug in the PHP script (or in PHP itself), they would now have complete control over the system. Not using stored procedures as an access control layer is asking to be hacked. -
Very Interesting
I have wondered for some time how much of an advantage the 2.6 kernel would be. This clearly shows--at least for dual Xeon systems--that the 2.6 kernel does some excelent stuff for Samba, and seems great for MySQL, while only marginally better for the other tests (and sometimes worse). Someone should do similar testing with various processors. I would be interested in seeing how different it is for the Pentium 4 (with hyperthreading) and Athlon XP, especially.
-
Re:Missing the point
Things are tight fisted because Sun wants a solid, CONSISTANT platform. This was a MAJOR REASON for the lawsuit that they fought and WON against Microsoft and their VM implementation
And, open-source software would be inconsistent because.......?
Inconsistent, like Apache?
or, perhaps, MySQL?
I get it. You mean inconsistent like this, this, or this?
Oh, the above aren't languages, like php or perl?
Eh, wait a minute. These are all *successful* projects, that are consistent?
If Sun were to open Java sources, it would be trivial to introduce a license (EG: GPL) that would largely offset forking of the codebase. Their best bet would be to pull a "QT" - open the source as GPL, then sell commercial licenses.
-
Do you want free software?
Perl.
Roxen WebServer (very intuitive, and GPL!).
Phew!! And that's a short list!! There are hundreds and hundreds and hundreds of open source, free-for-all applications.... so many it's almost absurd not to use them!! Go ahead and get them!
-
Re:DB?
Life would indeed be sweet if Sybase were to open the source for their free (as in beer) release of Adaptive Server 11.0.3.3 for Linux. 11.0 is a little long in the tooth in terms of features, but it's still FAR more mature than an inexplicably popular crappy toy database.
-
Many Failed, Mantis PrevailedAt SourceFubar we use Mantis exclusively for bug, issue, feature tracking. After evaluating about 15 other projects and products, commercial and non, we decided on Mantis. It is feature-rich, extensible, written in PHP, hooks to MySQL and other databases, and the developers are really a great bunch of people to work with. They are very receptive to patches, ideas, fixes, and anything else you can throw at them.
Mantis is actually getting me some contract work on the side, from Free Software developers on our projects who brought the notion of Mantis to their employers, who are talking to us about doing deployments of Mantis in their enterprise for customers and internal use.
The second-runner up out of the 15 we tried was a product called "Round-Up", written in Python. The reason it didn't win out over the top was the fact that it was written in Python (no flames, just that Python is more resource-hungry than PHP itself), and that the web-based interface wasn't anywhere near as mature as the Mantis interface.
Give it a try, you will most-certainly be impressed. I was, and still continue to be, to this day.
-
Try ProcmailAt least for organizing mail, procmail is the best way to go. It uses egrep-compatible regular expressions, scoring, and comes with header reformatting utilities, plus it integrates nicely with the unix environment.
Once you have procmail set up, it would be trivial to extract names and addresses into a MySQL database and use it from there.
Some argue procmail syntax is difficult to understand, but so do all beautiful, powerful languages appear to the benighted.
:) -
List of LuminariesI can't believe I haven't heard about this yet! I live in Tacoma, and admittedly I've never managed to make it to the LUG meeting here. You'd hope that some local papers, etc, would have meantioned this, but we are in the Microsoft Municipality here, so what can you expect.
I was looking at the list of speakers, and damn, it's impressive.
- Brian Hatch - author of Hacking Linux Exposed, Building Linux VPNs, and the Linux Security newsletter, talking about Linux Security
- Brian "Krow" Aker, slash guru and author of "Running weblogs with Slash" from O'Reilly and one of the Slashdot team, talking about how to optimize MySQL for high traffic websites.
- Dr Crispin Cowan of WireX, creator of things like StackGuard, FormatGuard, and Immunix
- Dr Tim Maher, a white camel award recipient and the guy who runs the Seattle perl user group, talking about shell and perl that should be seen by everyone, based on his upcoming book
This promises to be a really cool - I look forward to going up there this weekend!
-
Have you read their website
Either you haven't RTMed, or you didn't explain very well. The documentation has it here. Just make both masters and both slaves, and hope you don't trample on each other.
Now that you have the key to complete disaster, I will warn you since you obviously don't know this. This is a stupid idea. Hmm... that not harsh enough. If you were working for me, I'd reconsider your employment if you came up with this crazy idea.
You should never, ever, ever, ever, have more than one person working on the same schema while coding! Either the database will be driven by your code, which is a quick way to denormalize everthing, and wreck havok, or more than one person will drive the design, and will denormalize and wreck havoc.
Only one person (or group) should make decisions on a schema, and it should be done, *before* any coding is done. The database structure will lend structure to the program itself.
I was a DBA for Oracle at a small company. You wouldn't believe what those idiots (Andrew, you listening? :-)) wanted to do, and did when I went on vacation! Instead of coding properly, they added tables to make it easier. And then they wonder why the DB slows down on their queries. Or they want to know a concrete method (query or idea) of encapsulating all data of a certain type, and wonder why I can't do it, since they left so many holes in the system.
The database should be designed to handle the system. And that it much more important than coding. Both because of speed and structural reasons. The only time the database should be changed, is when there was a mistake in the original design, or the project it is for has changed dramatically.
So, their is a way to do it, but its on par with logging in as root all the time, so things are easier. Don't do it. -
Re:My fast, easy solution.
when you say big emails....I assume that you mean less that 16 MB to handle MySQL row limitation. We have users who want to send 30 MB messages. Damn artists.
Nope, This limitation disapeared ages ago..
Information can be found here here and here
I suggest opening up the config file (generally /etc/mysql/my.cnf) and ensuring everything like "max_allowed_packet" etc are > 50-ish MB.
David -
Re:My fast, easy solution.
when you say big emails....I assume that you mean less that 16 MB to handle MySQL row limitation. We have users who want to send 30 MB messages. Damn artists.
Nope, This limitation disapeared ages ago..
Information can be found here here and here
I suggest opening up the config file (generally /etc/mysql/my.cnf) and ensuring everything like "max_allowed_packet" etc are > 50-ish MB.
David -
Re:My fast, easy solution.
when you say big emails....I assume that you mean less that 16 MB to handle MySQL row limitation. We have users who want to send 30 MB messages. Damn artists.
Nope, This limitation disapeared ages ago..
Information can be found here here and here
I suggest opening up the config file (generally /etc/mysql/my.cnf) and ensuring everything like "max_allowed_packet" etc are > 50-ish MB.
David -
Re:Thousand compromised?
Keep in mind that Access XP includes a desktop version of SQL server
This is true, but you need to go back a couple years to get to the root of this (fscking stupid) idea.
Visio 2000 installs it by default as well. I can't remember if anything previous did, but that was my first encounter with this. I would love to buy a bag of whatever those in charge of making this idea a reality, but this is not a small thing. You need to consider the hundreds of thousadns (if not into the millions) that are running software that was created 2 or 3 years ago up to now (and the future holds suit as well).
Can someone please remind me why I have to keep using M$ garbage? OOo is a great package. There are MUCH better webservers out there, and there are MUCH BETTER SQL Servers out there.
I just don't get it... -
Re:RedHAT FreeBSD"which is useful for network router, apache httpd and nothing else: no Java...."
Jdk 1.3 of suns java virtual machine is %100 supported and installed by defualt on FreeBSD 4.5 and above
"no databases..." Uh,what?. Oh you want commercial support.
"no win32 support.."
Well let me know when wine and samba ever get ported. Oh wait they are. If you need win32 apps then use windows. Freebsd is not better then linux or vice versa in this.
But the most import thing is that FreeBSD is stable and linux lost this reputation during the 2.4 kernel series. I use to be a big linux supporter but its just not stable enough anymore to bet my job on. Hell on SMP even the 1.0x kernel is better. Sure it only runs on one processor but at least its VM doesnt crash and burn. In other words linux is moving backwards and not forward. In the server world reliability and security are more important then cool bleeding edge features. Also the FreeBSD developers do not rewrite the whole kernel during every release. They just carefully modify the existing code and add new features. This makes cautious IT managers feel alot better since you never have to worry about a totally new OS which has its own sets of quarks every few months. You know %90 of the kernel is unchanged with every .0 release. -
Re:Corrections, pointers, and cautions
Quick pointers to NFS U/GID space solutions:
* rpc.ugidd - easy, but insecure. can leak u/gid info to untrusted parties. only works with userspace nfs server in linux - don't know about other opsystems.
* use the same u/gids on every server - almost certainly not an option.
* use a shared PAM back-end, such as LDAP (what I use), MySQL, or PostgreSQL -
Re:Astoundedanother example of security through obscurity.
No. Mac may have some "security through rarity", but OS X is not obscured. Neither are its web services nor its SQL implementations.
So I have to ask, what are you talking about? -
Some thoughts...I have been struggling with these issues for awhile now, for various reasons. Why? Because I like Zope, but am, like most developers, more comfortable with relational data structures.
Zope uses an object database known as the ZODB. Some forms of many-to-many relationsships and such can be handled via the use of selection and multi-selection properties, which are designed to distinguish between a selected element and the list of available elements. The list of elements can be derived from a property on the current object, a property on a parent object, or be created via a method call - allowing for non-traditional (for OODBMS) cross-linking of objects. Of course, since this sort of thing is a workaround, no true relational links are created... 'Soft Relations' may be ok for MySQL, but in big application development, relationships must be enforced! Thus, the big-boys in RDBMS all enforce foreign keys (mysql does not)...
Of course, I've found that by careful creation of object heirarcies, very complex applications can be created on top of a OODBMS that are in fact more robust, in some ways, then the relational couterparts. The Bigest hurdle (Short-term) I see to OODBMS (including ones based upon XML [the ZODB can export objects as XML but they are stored differently internally]) is the lack of a true query and data manipulation language - like SQL. Sure, OQL exists, and is even technically a standard, but it A) sucks and B) is geared towards large java applications with huge amounts of active objects, not general purpose OODB queries. Thus, without such language, OODBMS are all disimilar in how one queries and creates/updates data, and in many cases, the only interface is a truely procedural one! Thus OODBMS are forced to use proprietary tools, and are locked into one system - not to mention speed of development (something normally associated with OO development and OODBMS in general) is hindered by the excessive amount of procedural calls one needs to simply query thier data...
Recently, an add-on to Zope addressed some of these issues. Called 'ZOQL' - it uses a SQL like syntax and allows for very discrete querying of the ZODB (something one had to do programatically using the 'ZCatalog' before) with all of the familar aggregate and comparison operators SQL users love... Of course, this _still_ doesn't address the issue of soft-relationships:
I think the bigest hurdle to OODBMS in the long term (tools like ZOQL are interfaces to existing systems, thus can be mplemented easily) is the lack of handling relationships. It seems that most RDBMS force a developer to think in Relational terms about the data, and most OODBMS force you to think in terms of objects... Most problems can be mapped to either of these domains, but you are forcing the data-model-type onto the problem. What is needed is a hybrid system, an 'Object-Relational' DBMS. This is to say that OODBMS system makers desist with the traditional OO idea that relations are of the following types:- Object A is a Object B
- Object A Has a/many Object B(s)
How does one do this in a hierarchal system? Well, the easy answer would be that each manufacturer object contains all the cars that manufacturer makes. Simple, right? WRONG. Why?
Because each car also has a body-type (compact, sedan, SUV, truck, van, etc...) - which in a relational database would simple by another lookup table, but in an OODBMS poses data management issues. Do we put body-type higher then manufacturer? If so, then we have to maintain the list of manufacturers for each body type, causing headaches. Or do we put body-type below manufacturer, causing us to need to maintain a seperate list of body types for each manufacturer - these lists of course need to match exactly if we ever plan on being able to search or do reports based upon all cars of a specific body type.
Sadly enough, this sort of seperate-enumeration-relationship isn't implemented (well) in any OODBMS I've found.
Take the ZOBD for example, its selection and multiselection lists Try to handle this situation, but fail because relational integrety is not maintained! That is to say, behind the scenes it's not a true reference to a value in the enumerated list, but just a text entry representing a value in the list. If the value in the list changes, the selection-property does not update, leaving you with the equivilent of MySQL's bastard-children, the orphaned records.
This sort of soft-relationship handling is Ugly and BAD for maintainaility, but OODBMS users are faced with two ugly choices each time they map such a relationship: Do I store this as a plain-text property and just update N records each time this changes, or do I map it into the hierarchy and deal with the headaches incurred by doing so...?
I don't think I've answered the question, but hopefully I've at least shed some light on the subject for members of both the OODBMS camps and RDBMS camps... Now if only a useful ORDBMS were to come along...
(Note that PostgreSQL and some other RDBMS actualy can be used in a semi-OO manner, but this is usually reserved for inheritable structures of data to be used for specific extensions to the data model - thus the SUV table inherits from the Cars table and adds some columns - but all other relationships SUV has will still be relational) -
Can't Slashdot MSNBCNote that the site linked to in the article is not falling prey to the much vaunted Slashdot effect despite the fact that it is served from a handful of commodity PCs (4 of them to be exact). The site can handle huge volumes of traffic due to the superior design of its operating system, Windows 2000, and the underlying database, MSSQL.
Unlike sites using alternative systems and shit databases, MSNBC doesn't break down daily. Microsoft serves it from cheap hardware to make a point, that Windows 2000 is the ultimate performer even under the most adverse conditions.
-
Re:Any step-by-step manuals out there?
Hi, and welcome to the club. I am glad that you are now considering the transition. Just to give some of my credentials: I am ungraduate at a fairly well known university, taking computer science. I also have about 3 years of summertime employment in ASP, VB, and minimal web server management.
Well now to the point. I have made the transition to linux environment about a year ago -- and I now consider myself an average user/admin. The main question in performing the transition is to ask yourself, how much unix/linux/BSD you already know. If the answer is none -- I recommend to not do an immediate transition, but instead get a separate computer, install a distro of linux, and just play with it, to get stuff figured out and working. This step will take a few weeks of devoted time. The main thing is DO NOT GIVE UP. Linux has all the features, but if you do not know where they are, stuff won't work. In which cases post questions to those who know. Or even better yet get a book. $50 will give you up front useful info on networking, and may tell you how to get the webserver running. I am using the book Using Linux, Sixth Edition SE. It has been a lifesaver, although it is oriented towards redhat, debian, and caldera versions.
Some usefel links:
RedHat Linux
Mandrake Linux
Debian
Linux Documantation Project
I recommend downloading (or purchasing) one of the distros above. The first two try to be really user friendly, and do a decent job at it. The third one is a bit more cryptic, but you will probably want that version for your real server, since it does not have a ton of annoying unnecessary flashy things, like graphical bootup. Besides the install the real diference is update management, which both redhat and mandrake do using rpm system. It is easy to figure graphical rpm. Once you get comfortable with that, consider using that book that yau bought, along with linuxdoc (the fourth link) to figure out how to get all that networking, like VPN, DNS, etc, using the configuration files -- the only good way of setting up the network.
After you figure out basic administartion, Try getting some simple pages to learn apache.
Apache web server
Perhaps a book on apache Perl and PHP programming might help. Do not actually know any specific titles. Basic idea is the same as in IIS. There is a public directory, similar to inetpub\wwwroot. where you can put the files. I believe that PHP is most similar to ASP. And since you did not use SQL server for database access, but Access, I assume that you do not need the speed of a full blown server. In this case MYSQL will do the trick. For something more significant you should check out Postgres db, or a commercial product such as db2. Learning these will take some time, but remember, these things have been written with an simplicity in mind. It just takes a little bit, to see where this simplicity is.
Well this msg is already too long. To sum it up, do not throw away your old system yet. Take time to learn linux, and in a little time you will possess the necessary skills to do transition. As for the tools that will make the transition for you, I have not heard of them, however they probably do exist. And starting somewhat anew is not always a bad thing. A lot of us hope that some version of windows will be written anew, but I doubt it will happen.
Well, good luck! The switch is not easy, but there are plenty of benefits in the long run. Do not give up, and you will see them soon. -
Re:Part of a bigger NuSphere/MySQL GPL issue
Also note the Support Page at MySQL.org -- it lists the companies offering support in alphabetical order which of course puts Abriasoft at the top, not MySQL AB. I haven't ever taken a look at the NuSphere version of MySQL, but if it comes without the source to any modifications they made to MySQL, then it would be in violation of the GPL, not just trademark law. If its clearly distributed (as it is on the mysql.org downloads page) as NuSphere MySQL, then it shouldn't be a problem.
-
Re:I'm a little confused here...
MySQL.org is definitely confusing. Go there. See if you can find any hint of who they are. I don't necessarily have trouble with them using the domain, but it is very difficult, if not impossible, to tell that they are not in fact the developers. If MySQL AB owns the trademark, then they definitely have a reason to complain. I don't, howevever, think the tone of their press release was justified.
(Is it me or is /. running really sporadic today?) -
Too funny!I go to mysql.org at 9:10 PST and I get this message:
Warning: Too many connections in
/usr/local/nusphere/apache/htdocs/phpwebsite-0.7.6 /mainfile.php on line 9 Unable to select database -
Re:Sounded harsh until I looked at mysql.org
Yes, I agree with this statement. When I went to mysql.org it really does look like it would be the standard website for the mysql distribution. In fact the only reference to the AB company on that website was the little blurb at the bottom that said "If you are looking for the MySQL AB company, click here." . This makes it sound like there simply referring you to some other commercial distribution of mysql. If a person did not know about mysql or the company behind it this website would not provide them with that information. In fact the licensing page isn't really even correct between the mysql.org and the mysql.com pages:
http://www.mysql.com/support/arrangements/policy.h tml
http://www.mysql.org/content.php?menu=18&page_id=6
bbh -
Re:Sounded harsh until I looked at mysql.org
From www.mysql.org...
If you are looking for the MySQL AB company, click here. If you came here looking for NuSphere, click here. -
Sounded harsh until I looked at mysql.orgI thought it sounded harsh too, until I looked at mysql.org. I couldn't find ANYTHING that suggested that their product wasn't the standard distro of mysql... The only thing I found on quick inspection was that in their licence section they say that if you modify the GPL code, "as we have" you must release it under a GPL compilent licece. There wasn't a link to mysql.com arround anywhere obvious.
I think that if someone did that to my project I'd be kinda peeved too... by not pointing people at the GPL portion of the project's main site, they are just asking for project splits. If I make a change, and I've only looked at mysql.org, I'd never know who to tell about my change to get it in the main distro....
---
-
Re:I'm a little confused here...NuSphere may not be 'obscure', but the mysql.org website seems a little deceptive. If I didn't investigate it more, I wouldn't have known the difference between mysql.org or mysql.com just by looking at the front page of the website. MySQL.org presents their website in a manner that does not give credit where credit is due.
For one, if you go to mysql.org you will find that it doesn't say whether it developed the software, it just says it's got mysql software available for 'free' download. But the mysql.com guy is correct, in that you cannot download any software without registering with mysql.org first. That indicates to me that it's not 'free' because now mysql.org has customer data to use to market their product to. Plus, it doesn't say: "Hey, we didn't write the software, mysql.com is where you can find that info. We just improved upon it." Besides, I don't think
.org websites should ever be for-profit businesses as that is not how that domain was intended to be used.