Looks like I have fewer and fewer excuses not to try an open source database.
The only problem I can think of with using triggers to refresh materialized views, is that you cannot defer the refresh. It's rare, but some people do not want their M.V.'s refreshed in near-real-time. They prefer a daily full refresh.
Also, how easy is it to manage this approach? Does the dba have to setup custom triggers on each of the underlying tables, or does pgSQL automatically generate and enable the triggers?
The concept of deterrence is just pure B.S. Deterrence simply does not work. It never has, and it never will. Why? Because most felons commit their crimes without first stopping to consider the consequences. The ability to consider the consequences requires an informed, sane and sober mind, and few felons possess all three qualities at the time during which they commit their crimes.
Idiots like Sherriff Arpaio know that deterrence does not work. They do it because they want to mete out further punishment, beyond the convict's actual sentence. They feel, quite incorrectly, that they have the right and/or duty to make prisons and jails living hells for the inmates.
We need to do something to stop this. Most people are indifferent because they have no family members or loved ones behind bars. But take it from me: it can happen to you; it can happen to anyone. When you least expect it, someone you know will screw up and get thrown in prison. You won't feel so indifferent then.
A friend of mine was recently arrested. After booking, he was thrown into a large holding cell that has 30 bunk beds. At the time, the cell contained almost 70 suspects. Soon after he entered the cell, a riot broke out inside it, and he was forced to fight for his life. He witnessed suspects bashing each other's skulls against the wall and against the floor. A few of his fellow inmates could not handle the terrifying stress, and began sobbing. These delicate souls were then sexually abused by other suspects.
During that same weekend in incarceration, my friend witnessed the brutal beating of a suspect by three armed guards. The suspect had not assaulted anyone, but was being verbally abusive to the guards. The suspect lost consciousness, a lot of blood from a nasty head wound, and had to be carted to the infirmary.
Where did all this happen? Good ole NYC.
All of this happened in front of multiple surveillance cameras. I would surely like to review those tapes myself, but the general public is not allowed access to them.
What do you all suggest we do? Perhaps a public oversight committee that reviews the prison/jail surveillance tapes? This committe might be comprised of responsible citizens, selected via a process similar to jury duty selection.
Dang. That's nice. Thanks for the info. At this point, I really should R.T.F.M.
While we're at it, how about materialized views? A lot of my clients, particularly those with data warehouse db's, really need materialized views to solve complex performance issues.
Point-In-Time Recovery is extremely important, and was the one major factor that prevented me from seriously considering PostgreSQL in a production environment. However, please bear in mind that such a feature requires extensive testing, i.e., crashing your db in every conceivable way, and then recovering it quickly AND consistently (in consistent mode.) So I will still wait and see about this feature.
Tablespaces are also a key feature. The nicest thing about tablespaces is: each schema can have its own tablespace. This makes maintenance much, much easier, allowing you to isolate the data for each of multiple applications or developers. You can also use it to isolate mission-critical data within the same schema, which in many cases can keep your app running, even if you lose a non-critical portion of your database.
Savepoints are nice, but I've never had to use them. And altering column data types is nifty, but not really useful in the real world.
companies do not need to have extraterrestrial land rights to motivate space colonization. land rights are for settling or avoiding claim disputes. the massive cost of such endeavors will initially limit the competition to only a handful of players, so there will not be any such disputes initially.
not until people and companies begin colonization en masse, will we see a need for issuing such legal rights.
ca always has and always will be the absolute worst software company on the planet. they blow chunks, spewing worthless products all over our computers for years and years.
this is very cool, but also very scary: that scientists can artificially produce a nasty disease. if the good guys can do it, so can the bad guys, eventually.
Way back in the day, when I was working as a co-op, sub-junior coder hacking my way through 8086 assembly on an IBM AT, I found myself playing around with a (then) brand new Hercules High Resolution Graphics Adaptor. 640x480 baby! With 2 colors: green, and dark green.
I had read somewhere that, if programmed directly and incorrectly via assembly code, one could well and truly hose the adaptor. Being a curious little monkey, and not a little bit mischievous, I decided to see if it was true. I sent the mysterious instructions to the Hercules card, and nothing happend, at first. Then I started to smell something burning, something very stinky and plastic-like. Suddenly I noticed small wisps of smoke rising from the back of the computer. I had indeed fried my employer's graphics adaptor! Too cool.
both my father and i were DoD software engineers, me as a developer, and he as a tester. i do commercial stuff nowadays, and dad's retired. we both know, for a cold hard fact, that no national security- or defense-related software ever goes into production without passing the most rigorous reviews and testing, throughout its entire lifecycle. from functional descriptions, through design reviews, code walkthroughs and acceptance testing, everything is closely monitored and recorded.
so, please explain to me again how open source terrorists are going to slip their malware under our noses?
Always check both the feedback score and the positive feedback percentage. I look for 99% positive feedback, with a score of more than 100. If you're doing business with someone who has a score of 15 or 20, and you send that person a money order for $1,100, then you are begging to be ripped off.
the final stabilization will be left up to the companies that provide Linux distributions.
i am concerned that this means that, in order for us to get stable kernels in the future, we have to pay our favorite distro. someone please explain how woefully incorrect i am.
most of the massive speedup claimed in the article is likely due to basic performance tuning, the kind that usually happens during a large scale migration of this sort. i am sure they had at least one senior oracle dba on hand, who made sure that the new db is tuned to the nines.
The IRS has strict guidelines for determining status as an employee. These guidelines are a result of M$ trying to pass off employees as contractors, or vice versa, in order to finagle their taxes some years ago. The guidelines mention something about whether or not you are required to use the equipment furnished by the employer/client. I seem to recall that, if you have to furnish your own equipment, then the IRS considers you a contractor, not an employee.
Well, um, what you have is something we technology professionals call a database. More specifically, it sounds like you have a data warehouse. You need to think about things like mean-time-between-failure (MTBF) and mean-time-to-recover (MTTR), system response time, dollar cost of downtime, etc. Or, maybe you should just step aside and let the grownups handle this? Hmm?
Seriously, though, if you want cheap online backups, go with IDE RAID. It's slower than SCSI, but a lot faster than the other options.
The one thing that, for me, stands out on the DFJ website is the statement that they do not sign NDA's. And their excuse for not signing NDA's is weak: that it would create a deluge of legal documents. Oh too bad. You have millions and millions of dollars, yet you cannot afford a small legal staff to proofread the NDA's.
At least they could provide their own NDA, or offer an industry standard NDA which both parties can sign. Or they could post some guidelines for NDA's, such as number of pages, number of words, parameters of liability, required paragraphs, etc.
Slashdot Mirror
This is some next level s**t, y'all. It's got my wheels turning...
Just goes to show you: No good deed goes unpunished.
I really appreciate your input. I will pass it along to that friend of mine (it's not me, I swear!)
The only problem I can think of with using triggers to refresh materialized views, is that you cannot defer the refresh. It's rare, but some people do not want their M.V.'s refreshed in near-real-time. They prefer a daily full refresh.
Also, how easy is it to manage this approach? Does the dba have to setup custom triggers on each of the underlying tables, or does pgSQL automatically generate and enable the triggers?
Idiots like Sherriff Arpaio know that deterrence does not work. They do it because they want to mete out further punishment, beyond the convict's actual sentence. They feel, quite incorrectly, that they have the right and/or duty to make prisons and jails living hells for the inmates.
We need to do something to stop this. Most people are indifferent because they have no family members or loved ones behind bars. But take it from me: it can happen to you; it can happen to anyone. When you least expect it, someone you know will screw up and get thrown in prison. You won't feel so indifferent then.
During that same weekend in incarceration, my friend witnessed the brutal beating of a suspect by three armed guards. The suspect had not assaulted anyone, but was being verbally abusive to the guards. The suspect lost consciousness, a lot of blood from a nasty head wound, and had to be carted to the infirmary.
Where did all this happen? Good ole NYC.
All of this happened in front of multiple surveillance cameras. I would surely like to review those tapes myself, but the general public is not allowed access to them.
What do you all suggest we do? Perhaps a public oversight committee that reviews the prison/jail surveillance tapes? This committe might be comprised of responsible citizens, selected via a process similar to jury duty selection.
While we're at it, how about materialized views? A lot of my clients, particularly those with data warehouse db's, really need materialized views to solve complex performance issues.
Tablespaces are also a key feature. The nicest thing about tablespaces is: each schema can have its own tablespace. This makes maintenance much, much easier, allowing you to isolate the data for each of multiple applications or developers. You can also use it to isolate mission-critical data within the same schema, which in many cases can keep your app running, even if you lose a non-critical portion of your database.
Savepoints are nice, but I've never had to use them. And altering column data types is nifty, but not really useful in the real world.
Btw, does PostgreSQL have row-level locking yet?
this is such a non-story. if i want to read pseudo-science, i'll browse cnn.com.
not until people and companies begin colonization en masse, will we see a need for issuing such legal rights.
ca always has and always will be the absolute worst software company on the planet. they blow chunks, spewing worthless products all over our computers for years and years.
this is very cool, but also very scary: that scientists can artificially produce a nasty disease. if the good guys can do it, so can the bad guys, eventually.
in the words of the late, great philosopher, Robert Marley: "tru dat be, mon."
btw, to qualify in the "Abused but Working" category, i must add that the adaptor continued to function, albeit in a crippled mode.
I had read somewhere that, if programmed directly and incorrectly via assembly code, one could well and truly hose the adaptor. Being a curious little monkey, and not a little bit mischievous, I decided to see if it was true. I sent the mysterious instructions to the Hercules card, and nothing happend, at first. Then I started to smell something burning, something very stinky and plastic-like. Suddenly I noticed small wisps of smoke rising from the back of the computer. I had indeed fried my employer's graphics adaptor! Too cool.
ok, you're right. but your scenario applies to all types of software, not just open source.
a: no.
you missed my point entirely. and where did this brainwashing stuff come from?
so, please explain to me again how open source terrorists are going to slip their malware under our noses?
Always check both the feedback score and the positive feedback percentage. I look for 99% positive feedback, with a score of more than 100. If you're doing business with someone who has a score of 15 or 20, and you send that person a money order for $1,100, then you are begging to be ripped off.
i am concerned that this means that, in order for us to get stable kernels in the future, we have to pay our favorite distro. someone please explain how woefully incorrect i am.
most of the massive speedup claimed in the article is likely due to basic performance tuning, the kind that usually happens during a large scale migration of this sort. i am sure they had at least one senior oracle dba on hand, who made sure that the new db is tuned to the nines.
The IRS has strict guidelines for determining status as an employee. These guidelines are a result of M$ trying to pass off employees as contractors, or vice versa, in order to finagle their taxes some years ago. The guidelines mention something about whether or not you are required to use the equipment furnished by the employer/client. I seem to recall that, if you have to furnish your own equipment, then the IRS considers you a contractor, not an employee.
Seriously, though, if you want cheap online backups, go with IDE RAID. It's slower than SCSI, but a lot faster than the other options.
At least they could provide their own NDA, or offer an industry standard NDA which both parties can sign. Or they could post some guidelines for NDA's, such as number of pages, number of words, parameters of liability, required paragraphs, etc.
So, where can I find a partner with sales and marketing skills?