![]() ![]() The software would operate on crucial data about the ship’s valves (for routing around pipe ruptures), and their stack had included Informix, which unfortunately stopped working whenever the server went down. ![]() Back in the year 2000, Hipp was working for Bath Iron Works, a shipbuilding subsidiary of defense contractor General Dynamics, and was building software for a Navy destroyer (the USS Oscar Austin). The story begins in a shipyard in Bath, Maine (population: 8,329). “SQLite reads and writes directly to ordinary disk files.”īut crucially, it’s also open source, which leads Bell’s podcast to an intriguing question: What happens if your fun side project ends up powering the world? And the host promises that, along the way, the interview will explore the dilemma which still haunts the open source movement today: How to survive becoming core infrastructure for the world.īell points out that SQLite is now installed in everything from web browsers to commercial airplanes, as well as popular software like iMessage and WhatsApp.īut the software was born out of Hipp’s frustration with a database that was installed on a battleship. “Unlike most other SQL databases, SQLite does not have a separate server process,” its official page explains. Because it’s contained in a library of C code, SQLite can be easily embedded into other software, and it’s fully self-contained. In a little more than two decades, it’s become the most widely deployed database in the world, according to the official webpage at - partly due to its simplicity. Motorola wanted to license it for phones, so he gave them the biggest $ figure he could think of: $80K □ Will print an origin if Messages put one there on download.Last week Adam Gordon Bell brought a special guest onto his podcast Corecursive: Richard Hipp, the main author of SQLite.ĭev invented the most popular database, SQLite, to eliminate server risk on a US battleship. (I don't know the rules for what goes in there and what doesn't, so it might not be complete - but there's a fair amount in there)īut actually you can see some information about the contact and conversation in theįile's extended attributes: $ xattr -lp :kMDItemWhereFroms Note that iMessage attachments tend to live in: ~/Library/Containers//Data/Library/Messages/Attachments/. The converted files are in HTML, more easily readable and hopefully more archive-friendly, but the sqlite approach to attachment linkage looks sensible. ~/Library/Application Support/Adium 2.0/Users/Default/Logs/ This person appears to have a more polished solution (no disrespect intended to the extremely useful SQLite scraper above):Īdium transcripts are generated from your logs and stored in: Select rowid from message where cache_has_attachments=1 and handle_id=( Select attachment_id from message_attachment_join where message_id in ( Select filename from attachment where rowid in ( ![]() #Retrieve the attached stored in the local cache Select ROWID from chat where guid='iMessage - $1') Select handle_id from chat_handle_join where chat_id=( Select is_from_me,text from message where handle_id=( )Įcho "Enter a iMessage account (email of phone number i.e +33616.) " #Parameter is a iMessage account (email or phone number i.e. If you know the iMessage account of your contact here is a bash script of mine to retrieve text + images. ![]()
0 Comments
Leave a Reply. |