Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 22

Displaying posts with tag: firebird (reset)

Open Database Camp - Accommodation and Sponsoring
+4 Vote Up -0Vote Down

The Open Database Camp 2011 is shaping up nicely.
The logistics is being defined and local and international volunteers are showing up for help. (Thanks, folks!)
If you want to start booking, there is a list of hotels in the Accommodation page.
And don't forget to sign up in the Attendees list.
Local travel information will be released as soon as we finish cranking up the plan.
Open Database camp is free, but we still have expenses to get the job done.
We need






  [Read more...]
The Sign Of Eth Is Rising In The Air
+0 Vote Up -0Vote Down

Brief pause of that Sudoku series :  I’m working on my object-relational mapping framework code-named Eth.

It’s vaguely similar to Glorp but much simpler and not as intelligent as Glorp.  This time, the resurrection of my framework is more like… a rewrite from scratch.  It all started on VAST, then I ported it to Dolphin then Squeak and now Pharo.  Hopefully, now I will spend more time writing it than porting it! Also, it will exclusively support Pharo.  I also decided to write some SUnit tests to make sure I can properly handle PostgreSQL, MySQL and Interbase for the first version.  But I am also planning on supporting SQL Server, Oracle, DB2,

  [Read more...]
Here Again
+0 Vote Up -0Vote Down

I’m back in the blogosphere!

This blog will focus on Smalltalk (mostly Pharo, Squeak, Dolphin, VAST and VW), databases (usually MySQL, PostgreSQL, SQL Server, DB2, InterBase and Firebird), algorithms and open source tools.  I’ll throw in some literature, music and mathematics occasionally.

Requirements to enjoy this blog : an interest in problem solving, a database and a Smalltalk environment!


OpenSQL Camp Portland OR, 14-15 Nov 2009
+2 Vote Up -0Vote Down

OpenSQL Camp Portland 2009 is coming up on the 14th and 15th of November. Eric Day (of the Drizzle project) is the lead organiser this time around.

I went to the first edition in Charlottesville VA last year which was organised by Baron Schwartz (Percona). It was a great event, like other unconferences but with specific focus on database technologies. Monty (MySQL), Brian (Drizzle), Richard (SQLite), Jim (Interbase/Firebird/Falcon), Bruce (PostgreSQL) were all these, as were various storage engine builders. Very interesting, and lots of informal fun. If you’re anywhere near, do go!

Even though noone from our gang is able to make it to this one, Open Query is sponsoring this event – for all the above reasons. It rocks and deserves every support.

OpenSQLCamp 2009 presentation videos are online and free!
+4 Vote Up -0Vote Down

In record time, less than a week after the conference (thanks to the free Pinnacle Video Spin and YouTube), all 11 videos that were taken at OpenSQLCamp Europe are online.

For those who missed the sessions, or just want to relive the fun!

Almost all the sessions were filmed; regrettably Darren Cassar’s Securich – MySQL user administration and security made easy! and Stephane Combaudon’s Minimizing data access with covering indexes were not.

The YouTube videos have the descriptions and resources from the official conference pages, and links to pages. If there is more information to add (for example, the slides from

  [Read more...]
Log Buffer #151: a Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

Welcome to the 151st edition of Log Buffer, the weekly review of database blogs. We’re going to take a fast tour through the best blogs from the week gone by, beginning this time, with Oracle.

Jonathan Lewis writes, “It occurred to me recently that I might be making casual use of terms that weren’t necessarily very well known to the less experienced user. So I’ve decided to build a glossary of terms – and I’ll try to add to it from time to time whenever I have a few minutes.”

Jonathan might want to add “Method R” to the glossary. Cary

  [Read more...]
Log Buffer #145: a Carnival of the Vanities for DBAs
+2 Vote Up -0Vote Down

Welcome to the 145th edition of Log Buffer, the weekly review of database blogs.

MySQL

Since MySQL was surely the belle of the bloggers’ ball this week—why, everyone was talking—let’s begin with it.

Baron Schwartz started something with his post examining why MySQL might not benefit from having a mother ship. Dean Ellis of niflheim responded, arguing that everyone needs the MySQL mothership. And that got Sheeri’s Cabral’s attention—she took

  [Read more...]
Log Buffer #140: A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

This is the 140th edition of Log Buffer, the weekly review of database blogs. Welcome.

Let us begin with Oracle this week. Dan Norris illustrates how to start database services automatically after instance startup. He says, “Services are an essential component for managing workload in a RAC environment. If you’re not defining any non-default services in your RAC database, you’re making a mistake.”

Vivek Sharma published his tale of, Latch: Row Cache Objects causing huge performance

  [Read more...]
Log Buffer #117: A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

Welcome to the 117th edition of Log Buffer, the weekly review of database blogs.

For those of you who don’t know me, my name is Nicklas Westerlund, and I’m a MySQL DBA with The Pythian Group. This is my first time writing Log Buffer, and I hope I’ll do it right.

Let’s start off with SQL Server, where Simon Sabin asks if you know what concurrency is and how to improve it. And on SatisticsIO, Jason Massie focuses on the

  [Read more...]
Log Buffer #116: A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

Welcome to the 116th edition of Log Buffer, the weekly review of database blogs.

This was the week of Oracle Open World (OOW), Oracle’s gigantic annual get-together in San Francisco — always the heaviest week in Oracle blogs, so let’s start there.

For day-by-day coverage of OOW on the ground, I recommend Doug’s Oracle Blog: OOW Day 1, OOW Day 1.5, OOW Day 2,

  [Read more...]
Log Buffer #114: A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

This is the 114th edition of Log Buffer, the weekly review of database blogs.

I am sorry to say that this log buffer was supposed to be edited by Dave Edwards, but he’s suffering from severe and long-lasting tooth pain and until his root canal is done he’s KO’d by a killer combo of painkillers and the pain that the painkillers can’t kill. I’ve been there myself, twice, and here’s a tip Dave. It hurts until the dentist takes out the needle. Then the pain goes away while he digs. The pain comes back that night. The next morning it’s worse than ever, unbelievably, writhingly bad. But later that afternoon, blisssssssssssss. :-) Good luck man.

This Log Buffer has been generated in a completely automated way with the help of the incredibly awesome

  [Read more...]
Random selection, with a bias ...
+0 Vote Up -0Vote Down
Say you want to randomly select your employee of the month, but not so randomly, better, you'd like to give your best employees a bigger chance to be selected based on their rating.This is just an example, you could be randomly displaying ads from your customers, but giving an higher chance to be displayed to those who are paying more, there can be a million other example, but I hope you got the
Has them all
+0 Vote Up -0Vote Down
A question that pops up frequently on Devshed forums is "How can I get all products that are available in Red and Green colors?" or "How can I find out which customers bought this book and that CD?", solution is simple and I'll provide an example here, it can be made more complicate at your option, but it all boils down to a where and an having condition.Say we have a table that lists all
Data load speed test
+0 Vote Up -0Vote Down
I've run some data load tests with various databases using DBMonster, so connecting to databases through JDBC on a WindowsXP personal computer.Here are the results, in both cases I loaded 100 rows in the parent table and 1000 in the child table, with foreign keys enabled.Firebird 2.1 with Jaybird 2.1.3 and DBMonster 1.0.3 (And Java .6)Table structure is:CREATE TABLE GUYS(GUY_ID Integer NOT NULL,
Log Buffer #96: a Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

This is the 96th edition of the weekly review of database blogs, Log Buffer.

Let’s start this one in SQL Server Land, with a question from Dennis Goboshould SQL Server have the CREATE [OR REPLACE] PROCEDURE syntax? There are, he writes, advantages: “When scripting out a database you don?t have to generate if exists…..drop statements,” and disadvantages: “I can overwrite a proc without even knowing it.” Of course, the commenters have opinions of their own, and the piece becomes a straw poll for the desirability of that syntax as a feature.

Aaron

  [Read more...]
Log Buffer #92: a Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

Welcome, readers, to the 92nd Log Buffer, the weekly review of database blogs.

Brian “Krow” Aker started an interesting blog-thread with his post, The Death of Read Replication, the crux of which is that object caches, such as memcached, make the DBMS itself a little less central, particularly in “Web 2.0″ scenarios. “What does this mean? Less database servers. Bringing down your load means you push off the load to another tier. . . . Why do I need to go through MySQL at all… unless I just want it as a backup or for ad-hoc reporting?”

Ronald Bradford responds with

  [Read more...]
Two basic indexing tips ...
+0 Vote Up -0Vote Down
Here are two basic tips for proper indexing ...Don't mess with datatypes, too often people refer to an attribute defining it as one datatype in a table and as another in different tables, this actually prevents index usage in joins (forget about FKs for this time ;)) See an example here. You could declare a function based index as a workaround, but why don't we all try to make it right?Put
Log Buffer #89: A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

Welcome to the 89th edition of Log Buffer, the weekly review of database blogs.

Welcome, welcome everyone.

In writing this week’s Log Buffer, I’ve had a chance to sit down and read some excellent posts on all sorts of platforms. The depth and breadth of what’s available to house and retrieve data is astonishing.

Many of you who have read my posts will know that I’m a fan of vegetables. They are something most of us don’t eat enough of. Come on DBAs! I think we need to make a collective effort to get healthy. We need you to keep all these systems alive. I say this because I have a new found appreciation for the work we do day in and day out.

Six

  [Read more...]
Simulating procedural logic
+0 Vote Up -0Vote Down
Sometimes I see people having great difficulties in describing how to fetch data for a report.They are unable to reason by sets and tend to describe things in procedural terms.Here I'm posting a small example of how you can write a query that reproduces that procedural reasoning and lets the optimizer do the work of translating it into efficient SQL.Say someone has a table structure like this, a
Log Buffer #87: a Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down
Welcome the the 87th of Log Buffer, the weekly review of database blogs. First up, a couple of items responding to news about H-Store, the new database technology. Nigel Thomas of Preferisco wonders if H-Store is a new architectural era, or just a toy? Too much information, in turn, asks, Is H-Store the future of database [...]
Log Buffer #86: a Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down
Welcome to the 86th edition of Log Buffer, the weekly review of database blogs. Let’s jump right in. MySQL This was the week in which Sun Microsystems’ acquisition of MySQL went through. Wow, that didn’t take long at all! Zack Urlocker reports on the celebration at MySQL AB when the deal was completed, and [...]
New challenges, new synthax
+0 Vote Up -0Vote Down
This post wants to be:1. A quick glance at the new "common table expression" (aka hierarchical queries) in Firebird 2.12. A call to action for other opensource databasesSo, on with 1., Firebird recently added another great feature, common table expressions (CTE) which, to my eye at least, boils down to hierarchical queries.This is basically the ability to efficiently and easily query hierarchical
Showing entries 1 to 22

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.