First post-babies release, this is a “pull requests integration” release, plus a few fixes (including the infamous race-condition fix that was omitted in 1.5.8).
A huge effort has been put over several months to make this version work on 2.x and 3.x flavors of Python, and except a few broken tests (due to an incompatible test helper) you should be able to officially install and use the library on python 3 as of today.
I’ve noticed the important amount of open tickets on the bug tracker, and unfortunately my available time is shrinking those days due to family business 😉 I’ve set myself the goal to fix one ticket a week, which should keep me busy until 2014 (if nothing else breaks in the meantime). That’s why help is more than ever welcome on fixing bugs, and adding missing features; I’ll do my best to be more reactive in the future when it comes to pull requests (once again, all my apologies to all the great people who have submitted patches for the last six months and must have thought they would never hear a word from me).
Thanks again to all the contributors, especially the ones who have been kind enough to include unit tests in their patches, so I don’t have to spend time making sure they did not break anything ;-)Image
Apologies to all the people who were awaiting for some openpyxl news, my wife and I have been quite busy those last months 😉
Meet Dorian and Gabriel, my two “first borns”. They are in an excellent shape, and their parents as well (well, as much as someone who didn’t sleep a full night for a month can be).
Raising newborn twins being a quite demanding job, I’ve stepped back from my work, and also from my opensource contributions for the moment. Hopefully we start to get used to our new life and I should be able to resume my activities soon.
As I’m currently merging 2.x and 3.x branches of openpyxl, I now need to perform tests over all existing Python releases known to man. I decided to install a new Ubuntu VM to perform the the tests, but I struggled during 2.4 installation.
Tried pythonbrew, which was a very disappointing experience as nothing worked as it was supposed to.
Then I tried to build from source myself, but here again the GCC version available on ubuntu 11.10 is apparently no longer able to compile original python sources.
Here is how I did it :
download RPM version for Fedora here : http://www.python.org/download/releases/2.4/rpms/ (direct link)
Then, do not try to use the driver directly from Access (almost gave up the whole thing doing this way) but instead go to your Control Panel > ODBC Sources
Create a new source (DSN) from here, pointing to your SQLite file (tested with a SQLite3 database, using the SQLite3 ODBC driver)
Start Access, create a new database (tip: if you want to keep Access 2003 compatibility under Access 2007, replace the .accdb extension by .mdb in the “new filename” box
Go to External Data > ODBC Sources > System sources and select the DSN you just created at previous step
You’ll be prompted to select which tables to import, then start import
It did not preserve Foreign Keys at my first trial, I saw an option somewhere during the DSN configuration, but didn’t try it. As the driver is working perfectly, this option might as well.
If it spits a reserved error” or says the database is encrypted or is not a valid database, then you didn’t follow the sequence and are probably trying to add the DSN from the Access ODBC dialog. Remember, it has to be done system wide or it won’t work.
Although I like the current tone of the Adimian website, with the nice black and white contrast, I still feel it needs a more cheerful image, because you can be serious in your job and yet retain some sense of humor.
So I’ve been sharping my Inkscape skills (don’t laugh) and produced this nice fellow:
Actually, I noticed I was wasting plastic cups every day at the coffee machine, so I thought “let’s buy a mug”, and as I don’t like the idea of someone else accidentally drinking in my cup, I then thought I’d better customize it, say with my company logo. It definitely sounded too serious, so I decided to draw a mascot for the company, and to put it on the cup instead.
Took a few hours to get the shape and the colors right, I know he’s plain ugly and any one-handed monkey could have done better, but well, I made it so I’m proud of it 😉
Next step: find a printer with large supplies of lime-green ink !
Those days I’m in southern France, in a small (15 sq.meters) flat originally rented for my wife who’s working at the local museum.Even if I’m here to cheer her up, I still have to get some work done, but obviously there is no room for a large desk (nor for any desk actually), an external 24″ monitor, or my beloved wireless keyboard and trackpad.
There is not even a decent table, we have to put our dishes on a stool and eat in the sofa. In those conditions, I’ve been trying two configurations: the standing desk and the lap desk.
putting an expensive laptop on top of plastic candy boxes, next to an open window is … stressful
The lap desk
Pros (compared to placing the laptop directly on your lap)
comfy, veery comfy
prevents lap burns
greatly improves wrist position and angle
you can move around the house (seated on the couch -> seated on the armchair -> laid on the couch)
as the couch/armchair is much softer than the usual office chair, you can stay seated much longer before feeling tired
(not sitting properly in the couch is) bad for your back
(being seated too straight in the couch is) bad for your neck
(not moving your bum for 4 hours straight is) bad for your knees
(not changing your posture for several hours is) bad for your shoulders
As I couldn’t find any affordable cardboard boxes to build my poor man standing desk, I opted for the Logitech N550 lap desk which is an excellent product. It keeps the laptop cool, and the additional speakers have more bass and power than the internal ones. This version is for 14″ laptops at best, the N700 and Comfort Lapdesk are slightly larger, but the foam shape is different (it ends with a ‘^’, while the N550 is like a ‘<‘) and I find it more comfortable this way.
I’ve also looked at different brands and models, but the Logitech are the only ones that I find soft enough and properly engineered, for example, CoolerMaster makes ugly all-plastic stuff intended for overheating laptops, with giant fans, but no foam, no cushion of any kind. Not suitable when you need to work several hours a day.
To avoid neck and shoulders pain, it’s important to be properly seated, and moving around the flat for 1 minute every 2 hours keeps your knees from hurting.
It won’t replace my casual desk at home, but I definitely won’t work with my laptop on my lap anymore, and after one full week in this position, I found that I could work for 4-5 straight hours without notice, like in good days at my office desk. Totally worth it !