- Common MySQL Queries — a useful reference.
- MySociety’s Next 12 Months — two new projects, FixMyTransport and “Project Fosbury”. The latter is a more general tool to help people organise their own campaigns for change.
- riak — scalable key-value store with JSON interface. (via joshua on Delicious)
- Notes from NoSQL Live Boston — full of juicy nuggets of info from the NoSQL conference.
ENTRIES TAGGED "MySQL"
MySQL, MySociety, NoSQL DB, and NoSQL Conference Notes
Database expert Ronald Bradford on the pros and cons of migrating from Oracle to MySQL
Ronald Bradford has been guiding DBAs through key aspects of database integration for years. In this Q&A, he discusses the pros and cons of migrating from Oracle to MySQL (hint: it's not just about cost savings). He also weighs in on how Oracle's acquisition of Sun will shape the future of MySQL and its community.
Data Exploration, Evidence-Based Coding, API to the English Language, Dual Licensing
- Toiling in the Data Mines — Tom Armitage describes the process that Berg calls “material exploration”. Programmers very rarely talk about what their work feels like to do, and that’s a shame. Material explorations are something I’ve really only done since I’ve joined BERG, and both times have felt very similar – in that they were very, very different to writing production code for an understood product. They demand code to be used as a sculpting tool, rather than as an engineering material, and I wanted to explain the knock-on effects of that: not just in terms of what I do, and the kind of code that’s appropriate for that, but also in terms of how I feel as I work on these explorations. Even if the section on the code itself feels foreign, I hope that the explanation of what it feels like is understandable.
- Bits of Evidence — Slides for a talk, “What we actually know about software development and why we believe it is true”. (via Simon Willison)
- Wordnik API — definitions, frequencies, examples APIs. See the announcement from the Web 2.0 Summit.
- The Peculiar Institution of Dual Licensing — Brian Aker eloquently describes why he feels that dual licensing is anti-open source. Brian obviously has considerable experience informing this opinion–his years as Director of Technology for MySQL.
Historic Cartography, MySQL Futures, Timewarping GDB, Open Source Werewolves
- Milestones in the History of Thematic Cartography — This resource provides a comprehensive view of the history of cartography, with examples of maps created throughout the ages and background information about the contexts within which those maps, visualizations and map making technologies were created. Explore each time period, click on the images and stories found throughout each time line, and read more about the history of creating thematic maps as a means of visualizing data. (via Titine on Delicious)
- Interview with Larry Ellison (Infoworld) — Asked about MySQL, “No, we’re not going to spin it off,” even if asked to by the EU, Ellison said. Lots of detail and interesting tidbits in this interview. (via timoreilly on Twitter)
- GDB and Reverse Debugging — GDB version 7.0 (due September 2009) will be the first public release of gdb to support reverse debugging (the ability to make the program being debugged step and continue in reverse). (via Hacker News)
- A New Self-Definition for FOSS — There was this clamour in the past to get companies to open source their products. This has stopped, because all the software that got open source sucked. It’s just not very interesting to have a closed source program get open sourced. It doesn’t help anyone, because the way closed source software is created in a very different way than open source software. The result is a software base that just does not engage people in a way to make it a valid piece of software for further development. I don’t agree entirely with this quoted piece, but there’s a lot to what he says. Open source is not a silver bullet–hell, most people don’t even know what the werewolf is. Open sourcing doesn’t magically make developers appear, open sourcing doesn’t magically make a market appear. Your closed source problems still exist after you open source because it’s. not. about. you. It’s about the users and their comfort, abilities, and freedoms. (via Simon Willison)
At OSCON in 2006, I followed sessions that discussed how open source companies would fare when big corporations come in. Back then there were only a handful of examples of big companies purchasing small open source companies. Three years later, we've witnessed MySQL AB get swallowed by Sun, only to have Sun be swallowed by Oracle. Now there are…
Scientists, Scammers, Satellites, and Safe Havens
- Scientists Without Borders — “Mobilizing Science, Improving Lives”. mobilize and coordinate science-based activities that improve quality of life in the developing world. The research community, aid agencies, NGOs, public-private partnerships, and a wide variety of other institutions are already promoting areas such as global health, agricultural progress, and environmental well-being, but current communication gaps restrict their power. Organizations and individuals do not always know about one another’s endeavors, needs, or availability, which limits the ability to forge meaningful connections and harness resources. This situation is especially striking in light of the growing realization that integrated rather than focused approaches are crucial for addressing key challenges such as extreme poverty and the glaring health problems that accompany it. See also Geeks Without Borders, but is there anyone running a program that sends geeks into the field where they’re needed? I know a lot of open source folks who have been volunteering around the world in poor nations, but I haven’t found a site that coordinates this. Can anyone point me to such a thing?
- The Psychology of Being Scammed — UK government report into the psychology of scammers’ victims. Lots of insights into successful scams (parallels drawn to finance or startups left as exercise to reader) and some counter-intuitive findings like Scam victims often have better than average background knowledge in the area of the scam content. For example, it seems that people with experience of playing legitimate prize draws and lotteries are more likely to fall for a scam in this area than people with less knowledge and experience in this field. This also applies to those with some knowledge of investments. Such knowledge can increase rather than decrease the risk of becoming a victim. (via Mind Hacks)
- GPS Accuracy Could Start Dropping In 2010 (Tidbits) — the Air Force has had difficulty launching new satellites. The GAO has calculated – using reliability curves for each operational satellite – that the probability of keeping a 24-satellite constellation in orbit drops below 95 percent in 2010, and could drop as low as 80 percent in 2011 and 2012. (via geowanking)
- Open Database Alliance — an attempt to provide a safe home for MySQL given the Oracle acquisition of Sun. [...] a vendor-neutral consortium designed to become the industry hub for the MySQL open source database, including MySQL and derivative code, binaries, training, support, and other enhancements for the MySQL community and partner ecosystem. The Open Database Alliance will comprise a collection of companies working together to provide the software, support and services for MariaDB, an enterprise-grade, community-developed branch of MySQL.
In the Jonathan Schwartz interview at the Web 2.0 Expo in San Francisco yesterday, I screwed up. After learning we weren't set up for audience Q&A with microphones, I thought, "well then, I'll just suggest to the audience that they twitter questions @timoreilly, and I'll check my phone during the interview." I kept checking, but no questions. Bummer. Not…