<div id="popup_box_thanks" style="display:none" onClick="close_popup_thanks('popup_box_thanks', 'ts')"><br>Thanks for submitting your tip! All submissions are moderated by an editor before appearing online. We've reset the form so you can enter another tip. Or you can close the tip submission box. <div class="x_close" id="thanks_upper_right"><a href="javascript:void(0)" onmousedown="close_popup_thanks('popup_box_thanks', 'ts'); return true;">Close</a></div></div>
<div class="tbf_row"><div class="tbf_wide_extra_top not_bold">Please submit only technical tips that will help other TidBITS readers better use their Macs, iPhones, and related software and hardware. All product announcements should be sent to <a href="mailto:releases@tidbits.com">releases@tidbits.com</a>.</div></div>
<div class="tbf_left">URL</div><div class="tbf_right"><input type="text" value="" name="tip_link_url" tabindex="3"><span class="tip_description"><br>Enter the URL to a Web page that supports your tip.</span></div>
</div>
<div class="spacer"></div>
<div class="tbf_row">
<div class="tbf_left">Linked text</div><div class="tbf_right"><input type="text" value="" name="tip_link_label" tabindex="4"><span class="tip_description"><br>Enter the name of the page linked above.</span></div>
<div class="tbf_wide"><input type="submit" value="Preview Your Tip" name="preview_tip" onClick="fill_preview('tipbits_enclosure_preview', 'ts', this.form); return false;" tabindex="7"> <input type="submit" value="Send Us Your Tip!" name="submit_this_tip" onClick="handle_tip_submission('ts', '', this.form, 'tip'); return false;" tabindex="8"></div>
</div>
<div class="spacer"></div>
<div class="tbf_row">
<div class="tbf_wide"><span class="fine_print">When you submit a tip, you give us permission to use it. Read <a href="javascript:void(0)" onClick="generic_show_hide('tip_terms')">our terms</a> for more details. All submissions are reviewed before publication.</span></div>
<div class="tbf_wide"><span class="fine_print">Our terms: By submitting a tip, you agree to assign TidBITS Publishing Inc., a non-exclusive, worldwide, perpetual license to reproduce, publish, and distribute your tip in connection with the TidBITS Web site and associated products in any media. You agree that you created the content you submitted, and that you have the right to assign us this license. You give us permission to use your name, but your email address won't be publicly displayed or shared. We review all submissions before publication, and reserve the right to select which submissions we feel are appropriate for our readers and to edit those we publish.</span></div>
<div id="comment_thanks" style="display:none" onClick="close_popup_thanks('comment_thanks', 'comm')"><br>Thanks for submitting a comment! Please check your email for a link that, when clicked, will verify that you're a real person and cause your comment to appear immediately. <div class="x_close" id="comment_upper_right"><a href="javascript:void(0)" onmousedown="close_popup_thanks('comment_thanks', 'comm'); return true;">Close</a></div></div>
<div class="tbf_wide"><span class="fine_print">Our terms: We reserve the right to edit or delete any comment, so please post thoughtfully. We use your email address <i>only</i> to send you a one-time verification message confirming that you posted this comment. We also store your address to allow you to verify using other Web browsers in the future. For more info, see our <a href="http://db.tidbits.com/privacy.html">privacy policy</a>.</span></div>
<li><a href="/feeds/tidbits.rss" title="Subscribe via RSS" class="gettb">RSS <img src="/images/feed-icon-12x12.gif" width="12" height="12" border="0" class="nav_img" alt="Subscribe via RSS"></a></li>
<li><a href="http://itunes.apple.com/WebObjects/MZStore.woa/wa/viewPodcast?id=276986548" title="Subscribe to the podcast" class="gettb">Podcast <img src="/images/feed-icon-12x12_podcast.gif" width="12" height="12" border="0" class="nav_img" alt="Subscribe to the postcast"></a></li>
<li><a href="http://www.twitter.com/TidBITS" title="Get Article Updates via Twitter" class="gettb">Twitter <img src="/images/feed_icon_12x12_twitter.png" width="12" height="12" border="0" class="nav_img" alt="Get Article Updates via Twitter"></a></li>
<li><a href="http://www.facebook.com/pages/TidBITS/195314925519" title="Go to the TidBITS Page at Facebook" class="gettb">Facebook <img src="/images/feed_icon_12x12_facebook.gif" width="12" height="12" border="0" class="nav_img" alt="Go to the TidBITS Page at Facebook"></a></li>
<li><a href="javascript:void(0)" title="Sections" class="tabhead" onClick="return showhide('articleslist')">Sections <span id="articleslist_triangle"><img src="/images/nav_triangle_open.gif" width="9" height="9" border="0" class="navtriangle" id="articleslist_tri_image" alt="Click to show or hide the contents of this section."></span></a></li>
<li><a href="javascript:void(0)" onClick="return showhide('stafflist')" title="Staff" class="tabhead">Staff <span id="stafflist_triangle"><img src="/images/nav_triangle_closed.gif" width="9" height="9" border="0" class="navtriangle" id="stafflist_tri_image" alt="Click to show or hide the contents of this section."></span></a></li>
<li><a href="javascript:void(0)" title="Issues" class="tabhead" onClick="return showhide('issuelist')">Weekly Issues <span id="issuelist_triangle"><img src="/images/nav_triangle_closed.gif" width="9" height="9" border="0" class="navtriangle" id="issuelist_tri_image" alt="Click to show or hide the contents of this section."></span></a></li>
<li><a href="javascript:void(0)" onClick="return showhide('abouttidbits')" title="About TidBITS" class="tabhead">About TidBITS <span id="abouttidbits_triangle"><img src="/images/nav_triangle_closed.gif" width="9" height="9" border="0" class="navtriangle" id="abouttidbits_tri_image" alt="Click to show or hide the contents of this section."></span></a></li>
<li><a href="http://www.tidbits.com/about/support/contributors.html">Readers Like You!</a></li>
</ul><div class='sponsor_sidebox_bottom'> </div>
</div>
<!-- end sponsor_sidebox -->
</div> <!-- end leftcolumn div -->
<!-- end left column -->
<!-- begin centercolumn_border -->
<div id="centercolumn_border">
<div class="center_top">Thoughtful, detailed coverage of the Mac, iPhone, and iPad, plus the best-selling <a href="http://www.takecontrolbooks.com/?pt=TB-TAGLINE" style="color:yellow">Take Control</a> ebooks.</div>
<!-- begin centercolumn -->
<div id="centercolumn">
<!-- begin rightcolumn_container -->
<div id="rightcolumn_container">
<!-- begin rightcolumn -->
<!-- rightcolumn is embedded within centercolumn so featured text wraps around it -->
</div><!-- end tearoffbox_wide_container for watchlist items -->
<!-- begin tearoff box wide -->
<div class="tearoffbox_wide_container">
<div class="tearoffbox_wide_tips">
<div class="tip_display">
<div class="tips_sponsor_logo">
</div>
<h6>Option-Click AirPort Menu for Network Details</h6>
<p>If you hold down the Option key while clicking the AirPort menu in Mac OS X 10.5 Leopard, you'll see not just the names of nearby Wi-Fi networks, but additional details about the selected network. Details include the MAC address of the network, the channel used by the base station, the signal strength (a negative number; the closer to zero it is, the stronger the signal), and the transmit rate in megabits per second showing actual network throughput. If you hover the cursor over the name of a network to which you're not connected, a little yellow pop-up shows the signal strength and type of encryption.</p>
</div>
<div class="tearoffbox_wide_bottom_tips">
<div style="padding-bottom:35px"><div class="tip_display" style="float:left"><p><br><a href="/tipbits/83">Link to this tip</a></p></div><div class="tip_display" style="float:right; width:150px">
<p class="credit">Written by<br><a href="/author/Adam%20C.%20Engst">Adam C. Engst</a></p></div></div>
<div class="tbf_wide_80" id="hc_rc_2640">To help us avoid automated posts and misuse of our site, please enter the words below.</div><div class="x_close_row" id="hc_upper_right2_2640"><a href="javascript:void(0)" onmousedown="HidePopupContent('hc_2640', 'hc', '2640'); return true;">Close</a></div>
<div class="featured_meta"><div class="meta_article">26 Aug 1996 | <a href="/article/900?print_version=1">Print <span class="shift_up"><img src="/images/printer_icon.gif" alt="Printer-Friendly Version of This Article" border="0" width="9" height="10"></span></a></div></div>
<div id="article_box_2640"><P>My comments in <A HREF="http://www.tidbits.com/tb-issues/TidBITS-341.html">TidBITS-341</A> about building a database into the system for applications to use hit a chord with readers. A number of people wrote in with additional comments and ideas.</P><P><STRONG>Alex Sirota</STRONG> <<A HREF="mailto:adapple@apple.com">adapple@apple.com</A>> offers an additional requirement to my suggestions for what features are essential for a relational database system:</P><P>Another requirement that you didn't mention is a structured language with which to manipulate the contents of the database system. The power of an RDBMS (Relational Database Management System) over something like FileMaker Pro is the ability to manipulate the data, stored in tables, using a standard, accepted language such as SQL (Structured Query Language) and program the database procedurally with extensions to SQL that many RDBMSs support.</P><P><STRONG>Shay Telfer</STRONG> <<A HREF="mailto:shay@cs.uwa.edu.au">shay@cs.uwa.edu.au</A>> comments:<BR>The Newton uses a system-wide database that is accessible to any package running on it. Different applications can tightly integrate with your names, addresses, and appointments databases (known as "soups"), and can search or add information to each of these soups as appropriate. The database contains everything on the Newton, including code, graphics, etc., and it copes with people removing storage cards at will (even while the database is being searched). Such integration is extremely powerful and I think Apple should be aiming for this level of integration in the Mac OS (and I think it's what the people at Be are hoping for in the BeOS). The Newton is definitely a technology that was, and still is, ahead of its time.</P><P>Apple's Dylan implementation (may it rest in peace) was based around a database system where all the source code for each project was kept in a database. This made project revision control much easier, and was more sensible than the current way of thinking where functions are lumped together in a group of flat files on disk, which give little indication how the different parts of the software relate to each other. As far as I know, there are very few development environments out there which do this, other than Smalltalk, Prograph, and Frontier.</P><P><STRONG>David Charlesworth</STRONG> <<A HREF="mailto:davec@andyne.com">davec@andyne.com</A>> writes:<BR>I wanted to mention a few of things about using databases for storage at a system level:</P><UL><LI>Don't forget that Bento's structured storage (although I think it really targets a related set of problems) is part of OpenDoc.</UL><P><<A HREF="http://dev.info.apple.com/du/intro_to_opendoc/iod4_underlying_technology.html">http://dev.info.apple.com/du/intro_to_opendoc/ iod4_underlying_technology.html</A>></P><UL><LI><p>An additional benefit of a public database interface is that it provides a choice of tools to query and report on the data, repair problems, and extend the data. For example, if one of the PIM (personal information manager) producers used a standard database, then you could add additional tables and fields, and use "the right tool" (whatever that may be for you) to build reports, and still have the benefit of the user interface that the PIM provides. Just think how nice it would be if your PIM and your email program and your fax software shared the same database!</p><LI><p>There's the JET Engine shipped as part of Windows (ODBC interface, reasonable speed, full relational capability). When we wanted to build a prototype for a potential cross platform product recently, we built it on Windows because we could use the JET Engine for storage. This speeded our prototyping cycle, enabled us to ship to evaluators without licensing hassles, and enabled us to substitute other SQL-compliant databases for multi-user data sharing down the road. All of these are big wins. We spent zero time on reporting tools for it, zero time on storage-related optimizations, and had revision cycles of a few hours because we didn't need to rebuild our test data.</p></UL><P><STRONG>Marty Wachter</STRONG> <<A HREF="mailto:mwachter@ubmail.ubalt.edu">mwachter@ubmail.ubalt.edu</A>> adds:<BR>You should note that AOCE (more commonly known as PowerTalk) contained an OS object database for storing anything, however it was not widely known, and there were only low level routines documented to deal with it under the PowerTalk API. I think the developer API for the Catalog Manager (or whatever they wound up calling the thing) contains all of the info. The actual API was <EM>really</EM> ugly, and thus no one used it - even those of us who found it.</P><P><STRONG>Lawrence Conroy</STRONG> <<A HREF="mailto:lwc@roke.co.uk">lwc@roke.co.uk</A>> writes:<BR>As it happens, we are exploring system level databases for a project we're doing for a customer. I wholeheartedly agree with you that databases will be of increasing importance.</P><P>For instance, much as I say it through gritted teeth, Microsoft has a system level database of sorts in the Windows 95 Registry. It's rather like a collective preferences folder, so that applications can store their configurations setting there, rather than having a large number of application-specific .INI files. There is a "standard" way to access these database entries, and there's an included program (RegEdit) so users can browse and edit the entries.</P><P>There is another area where databases in a commonly understood format will be useful: databases that are accessible <EM>remotely</EM>. Related work is being started in the IETF (Internet Engineering Task Force). For example, there's a group based at Carnegie Mellon University developing proposals for a protocol for access to a remote configuration database; other groups are also working on this kind of problem, notably in the Access, Searching and Indexing of Directories (ASID) group of the IETF.</P><P><<A HREF="http://andrew2.andrew.cmu.edu/cyrus/acap/">http://andrew2.andrew.cmu.edu/cyrus/acap/</A>><BR><<A HREF="http://www.ietf.org/html.charters/asid-charter.html">http://www.ietf.org/html.charters/asid- charter.html</A>></P><P>Microsoft has been active in the ASID group, proposing that the existing LDAP (Lightweight Directory Access Protocol) work be extended for dynamic databases using their User Location Service (ULS). This is, basically, an enhancement of their existing WINS directory that's at the heart of Windows Networks. Their Internet Draft is at:</P><P><<A HREF="ftp://ftp.ietf.org/internet-drafts/draft-ietf-asid-ldapv3ext-00.txt">ftp://ftp.ietf.org/internet-drafts/draft-ietf- asid-ldapv3ext-00.txt</A>></P><P>In an attempt to (among other things) reinvent the telephone network, a number of directory companies are setting up multi-user remote databases that show (a) whether a user has a particular program (like a certain flavor of Internet phone application), and (b) whether or not the user has the program running at the time of the query. This kind of generally-accessible database is necessary if such applications are going to find widespread use. Otherwise it's difficult to know whether or not you can talk to someone (at all), since different Internet phone programs usually don't talk to one another. Likewise, without a way of registering the running program at startup, it's difficult for callers to know whether or not the delay in response is due to their call request disappearing into the bit bucket, or because their intended correspondent isn't running the program at that time.</P><!-- System-Level Database Comments Adam C. Engst --></div>
<!-- end article text -->
<!-- PayBITS -->
<p> </p><div class="sponsorbox">
<div class="sponsortext"><A HREF="http://markspace.com/bits?source=tidbits"><IMG SRC="http://db.tidbits.com/images/badges/mark-space.gif" ALT="" HEIGHT="50" WIDTH="50" BORDER="0" ALIGN="left"></A>SYNC YOUR PHONE with The Missing Sync: Sync your calendar,<br />address book, music, photos and much more between your phone<br />and Mac. Supports ANDROID, BLACKBERRY, PALM PRE and many<br />other phones. <<a href="http://markspace.com/bits?source=tidbits">http://www.markspace.com/bits</a>></div>
