database

26 Articles

Mobile phone reading an NFC tag with information on a garden plant

NFC Puts A Stake In The Ground

August 15, 2023 by 20 Comments

Sometimes we have a new part or piece of tech that we want to use, and it feels like a solution looking for a problem. Upon first encountering NFC Tags, [nalanj] was looking for an application and thought they might make a great update to old-fashioned plant markers in a garden. Those are usually small and, being outside 24/7, the elements tend to wear away at what little information they hold.

traditional plant marker

[nalanj] used a freeform data structuring service called Cardinal to set up text information fields for each plant and even photos. Once a template has been created, every entry gets a unique URL that’s perfect for writing to an NFC tag. See the blog post on Cardinal’s site for the whole process, the thought behind the physical design of the NFC tag holder, and a great application of a pause in the 3D print to encapsulate the tags.

NFC tags are super hackable, though, so you don’t have to limit yourself to lookups in a plant database. Heck, you could throw away your door keys.

Using Excel To Manage A Commodore 64

June 8, 2023 by 16 Comments

The “save” icon for plenty of modern computer programs, including Microsoft Office, still looks like a floppy disk, despite the fact that these have been effectively obsolete for well over a decade. As fewer and fewer people recognize what this icon represents, a challenge is growing for retrocomputing enthusiasts that rely on floppy disk technology to load any programs into their machines. For some older computers that often didn’t have hard disk drives at all, like the Commodore 64, it’s one of the few ways to load programs into computer memory. And, rather than maintaining an enormous collection of floppy discs, [RaspberryPioneer] built a way to load programs on a Commodore using Microsoft Excel instead.

The Excel sheet that manages this task uses Visual Basic for Applications (VBA), an event-driven programming language built into Office, to handle the library of applications for the Commodore (or Commodore-compatible clone) including D64, PRG, and T64 files. This also includes details about the software including original cover art and any notes the user needs to make about them. Using VBA, it also communicates to an attached Arduino, which is itself programmed to act as a disk drive for the Commodore. The neceessary configuration needed to interface with the Arduino is handled within the spreadsheet as well. Some additional hardware is needed to interface the Arduino to the Commodore’s communications port but as long as the Arduino is a 5V version and not a 3.3V one, this is fairly straightforward and the code for it can be found on its GitHub project page.

With all of that built right into Excel, and with an Arduino acting as the hard drive, this is one of the easiest ways we’ve seen to manage a large software library for a retrocomputer like the Commodore 64. Of course, emulating disk drives for older machines is not uncommon, but we like that this one can be much more dynamic and simplifies the transfer of files from a modern computer to a functionally obsolete one. One of the things we like about builds like this, or this custom Game Boy cartridge, is how easy it can be to get huge amounts of storage that the original users of these machines could have only dreamed of in their time.

Squish That Stack With Rampart

November 24, 2022 by 18 Comments

[P B Richards] and [Aaron Flin] were bemoaning the resource hunger of modern JavaScript environments and planned to produce a system that was much stingier with memory and CPU, that would fit better on lower-end platforms. Think Nginx, NodeJS, and your flavour of database and how much resource that all needs to run properly. Now try wedge that lot onto a Raspberry Pi Zero. Well, they did, creating Rampart: a JavaScript-based complete stack development environment.

The usual web applications have lots of tricks to optimise for speed, but according to the developers, Rampart is still pretty fast. Its reason for existence is purely about resource usage, and looking at a screen grab, the Rampart HTTP server weighs in at less than 10 MB of RAM. It appears to support a decent slew of technologies, such as HTTPS, WebSockets, SQL search, REDIS, as well as various utility and OS functions, so shouldn’t be so lightweight as to make developing non-trivial applications too much work. One interesting point they make is that in making Rampart so frugal when deployed onto modern server farms it could be rather efficient. Anyway, it may be worth a look if you have a reasonable application to wedge onto a small platform.

We’ve seen many JavaScript runtimes over the years, like this recent effort, but there’s always room for one more.

ERRF 22: Building A Library Of Filament Colors

October 20, 2022 by 10 Comments

If you’ve ever paged through the color samples at the hardware store trying to match a particular color, you know how hard it can be. Not only are there nearly limitless color variations, but each manufacturer has their own formulas and tints. Often times, the only way to get the exact color you need is to get it custom mixed.

Unfortunately, that’s not really an option when it comes to filament for your 3D printer. Will that roll of orange from Hatchbox actually match the orange from Overture? That’s where the Filament Librarian comes in. Created by [Joe Kaufeld], the project aims to catalog and photograph as many 3D printer filaments as possible so you can see exactly what you’re getting.

Now of course, if it was as easy as looking at pictures of filament swatches on your computer, you wouldn’t need this service to begin with. So what’s the trick? A custom automated camera rig, powered by the Raspberry Pi, is used to position, light, and photograph each filament sample in the library. So while [Joe] can’t promise your monitor is showing a perfect representation of each filament’s color, you can at least be sure they will all look correct in relation to each other. So for example, the site can help you figure out if the local Microcenter stocks anything that comes close to matching Prusament’s Galaxy Silver PLA.

[Joe] brought a collection of his samples along with his slick camera setup to the 2022 East Coast RepRap Festival so attendees could see first-hand how he adds a new filament to the database. With an easy-to-use touch-screen interface, it takes just seconds to get the camera ready for the next shot.

Now that he’s got the hardware and the procedure down, [Joe] is asking the community to help out by providing him with filament samples to process. It doesn’t take much: all he asks is you snip him off a couple meters of filament, write down what it is and who makes it on a pre-made form, and drop it in the mail. If you’re in the US, you can send it directly to his address in Indiana, and for those on the other side of the globe, he’s got a drop point in the Netherlands you can use.

We love a good passion project here at Hackaday, so here’s hoping that the Filament Librarian receives plenty of new filament samples from all over the planet to feed into that fancy camera setup of his.

Never Too Rich Or Thin: Compress Sqlite 80%

August 1, 2022 by 11 Comments

We are big fans of using SQLite for anything of even moderate complexity where you might otherwise use a file. The advantages are numerous, but sometimes you want to be lean on file storage. [Phiresky] has a great answer to that: the sqlite-zstd extension offers transparent row-level compression for SQLite.

There are other options, of course, but as the post mentions, each of these have some drawbacks. However, by compressing each row of a table, you can retain random access without some of the drawbacks of other methods.

Continue reading “Never Too Rich Or Thin: Compress Sqlite 80%” →

Screenshot of the website, showing the sidebar with technology types on the left, and an entry about modifying LCD polarizers on the right, with a video showing an art piece using LCD polarizers

Alternative Display Technologies And Where To Find Them

June 1, 2022 by 13 Comments

[Blair Neal] has been working on an information database for artists and hackers – a collection of non-conventional display technologies available to us. We’ve covered this repository before, six years ago – since then, it’s moved to a more suitable platform, almost doubled in size, and currently covers over 40+ display technology types and related tricks. This database is something you should check out even if you’re not looking for a new way to display things right now, however, for its sheer educational and entertainment value alone.

[Blair] doesn’t just provide a list of links, like the “awesome-X” directories we see a lot of. Each entry is a small story that goes into detail on what makes the technology tick, its benefits and fundamental limitations, linking to illustrative videos where appropriate. It’s as if this guide is meant to give you an extensive learning course on all the ways you can visualize things on your creative journey. All of these categories have quite a few examples to draw from, highlighting individual artworks that have made use of any technology or trick in a particular way.

If you’re ever wondered about the current state of technology when it comes to flexible or transparent displays, or looked for good examples of volumetric projection done in a variety of ways, this is the place to go. It also talks about interesting experimental technologies, like drone displays, plasma combustion or scanning fiber optics. Overall, if you’re looking to spend about half an hour learning about all the ways there are to visualize something, this database is worth a read. And, if there’s a display technology the author might’ve missed and you know something about, contributions are welcome!

Someone setting out to compile information about an extensive topic is always appreciated, and helps many hackers on their path. We’ve seen that done with 3D printer resin settings and SMD part codes, to name just a few. What’s your favourite hacker-maintained database?

Open Database Shares Resin 3D Printing Settings

May 13, 2022 by 3 Comments

3D printing is much like CNC milling or welding or just about any physical manufacturing process, in that good results fundamentally come down to having the right settings. In an effort to aid those working in the resin printing space, [Adam Bute] has put together a community database of resin printing settings.

The site has sections relevant to a variety of resin 3D printers, sorted by manufacturer. Those eager to find the right settings for their given resin and printer merely need to click through and look up the appropriate data. The settings are crowdsourced, provided by manufacturers, community members, and users of [Adam]’s Maker Trainer website.

While it’s still important to run validation tests on a resin printer to get the best results, having a community-sourced list of settings can help users get up and running much more quickly than they otherwise might. It appears that community contributions can’t directly be made yet, but we suspect such a feature is in the works.

We’ve seen similar material databases before for melty-plastic printers, and those have proven to be valuable to the community. We’re sure this resin database will be received in much the same way. If you know about other great resources for printing tips and tricks, do drop us a line!