The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

    Mastodon

  • Twitter Updates

  • My Flickr Stream

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now20140424-VMware-Fusion-6.0.3.-no-reclaimable
    More Photos

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,860 other subscribers

Archive for the ‘IKEA hacks’ Category

« Previous Entries

10-inch racks have apparently been a thing for the last few years. Some links.

Posted by jpluimers on 2025/05/13

When at look at a local Amazon site, they have plenty of stuff: [Wayback/Archive] Amazon.de : 10 inch rack

2023 example via [Wayback/Archive] Ikea Eket DIY 10″ Rack (UK) [build showcase] · Issue #22 · geerlingguy/mini-rack · GitHub:

Via [WaybackSave/Archive] Jeff Geerling on X: “Everyone in #Homelab knows about the DIY 19″ IKEA LACK rack… but did you know IKEA makes the perfect mini rack furniture, too? Presenting stirkage’s Eket rack! …”

[Wayback/Archive] Tweet JSON (image on the right).

That tweet and [WaybackSave/Archive] Jeff Geerling on X: “Indeed… there’s gotta be some nerd at @IKEA who’s ensuring certain furniture fits standard sized rackmount gear, right?” (image below via [Wayback/Archive] Tweet JSON) have some interesting replies, making the list of usable IKEA products at least this:

Read the rest of this entry »

Posted in Development, Hardware Development, IKEA hacks, LifeHacker, Power User | Tagged: , | Leave a Comment »

Smart idea: (re)use a solar panel as balcony power plant table

Posted by jpluimers on 2024/08/20

Still to do for Michael: put the inverter on the underside of the table-top.

[Wayback/Archive] Michael Eberhard on Twitter: “Nachdem wir eh einen neuen Tisch auf unserer Dachterrasse brauchten, gibt es nun einen Balkonkraftwerk-Tisch. Bloß der Wechselrichter muss noch unter der Tischplatte verträumt werden.”

The picture is below; this is the part list: [Wayback/Archive] Michael Eberhard on Twitter: “@TuckiTina @MatthiasVialon AlphaSolar Komplettpaket ca. 500€ Ikea Tischbeine 60€ Holz aus dem Bestand.” / Twitter

  • AlphaSolar full system ~500€
  • Ikea Table legs ~60€
  • Spare wood

Yield is not bad: [Wayback/Archive] Michael Eberhard on Twitter: “@truewhitemount Ich habe einen einfachen Zähler dazwischen. Gerade jetzt produziert der Tisch zwischen 180 und 230 Watt. In Summe bin ich im den letzten Tagen auf 0,6 – 0,8 kWh pro Tag gekommen. Noch ist die Motivation da, jeden Abend den Zähler abzulesen…” / Twitter

Read the rest of this entry »

Posted in Development, DIY, Electronics Development, Hardware Development, IKEA hacks, LifeHacker, Power User, Solar Power | Leave a Comment »

Some links on measuring CO2 and Volatile Organic Compounds in the air

Posted by jpluimers on 2023/05/02

Some links on measuring these:

I was triggered by some messages in a thread:

Read the rest of this entry »

Posted in Development, ESP32, Hardware Development, Hardware Interfacing, IKEA hacks, LifeHacker, Power User | Leave a Comment »

Operame: Dutch open source CO2 sensor device for indoor usage: shows green/yellow/red for good/okay/bad CO2 ppm levels

Posted by jpluimers on 2021/12/15

Since all information is in Dutch, I keep only the title and this short explanation in English.

[Archive.is] Sebastian Oort on Twitter: “Gaat jouw school binnenkort weer open? Wil je jouw klas veiliger maken? Hang een CO2 sensor op. Ze zijn weer op voorraad bij OperameNL ! We hebben nog ruim 100 stuks op voorraad en maandag komen de volgende 250 binnen! @OperameNL van @revspacenl… “

 

Read the rest of this entry »

Posted in Development, ESP32, Hardware Development, Hardware Interfacing, IKEA hacks, LifeHacker, Power User, Software Development | Leave a Comment »

The IDEA project – an ongoing series of nonverbal algorithm assembly instructions

Posted by jpluimers on 2021/12/10

I wonder how many new algorithms were added, as the first 6 were really impressive: [WayBack] IDEA on Twitter: “Excited to announce the IDEA project – an ongoing series of nonverbal algorithm assembly instructions: https://t.co/zOAyfOAv3l… https://t.co/epQfBBdzdF”

While originally scheduling this, these were added:

Read the rest of this entry »

Posted in Algorithms, Conference Topics, Conferences, Development, Event, IKEA hacks, LifeHacker, Power User, Software Development | Leave a Comment »

LED bulbs in IKEA track lighting systems lie SANSA or LINA – SM2YER Goran’s Homepage

Posted by jpluimers on 2020/05/01

It is easy to replace the halogen bulbs in IKEA track lighting systems like IKEA SANSA or IKEA LINA by LED bulbs (Sansa uses 5.3mm spaced MR16 fitting compatible with both GX5.3 and GU5.3 bulbs, I think LINA uses the same): [WayBack] SM2YER Goran’s Homepage.

There are many other fittings; [WayBack] LED fitting welke moet ik kiezen? | Lampfittingen overzicht has a good list, mentioning these:

  • E14
  • E27
  • GU10
  • MR11 (which has slightly thicker pins than G4 and GU4)
  • G4 and GU4
    (with varying pin thickness)
  • G5.3, GX5.3, GU5.3
    (with varying pin thickness)
  • G6.35, GX6.535, GY6.35, GZ6.35
    (with varying pin thickness)
  • MR16
  • G9
  • GU10
  • AR111

The problem is the power supplies. They do not like the low wattage, or even burn with low wattage. Two solutions:

  • Use at least one 10W bulb, or
  • Use a 12V power supply from a laptop or other device that delivers far less power.

Fitting references:

--jeroen

Posted in Development, Hardware Development, IKEA hacks, LifeHacker, Power User | Leave a Comment »

IKEA TRÅDFRI lamps [1] when equipped with Firmware >= 1.2.217 integrate with Philips Hue and vice versa…

Posted by jpluimers on 2019/08/05

Reminder to self [WayBack] Just a small FTR. Yes, the IKEA TRÅDFRI lamps [1] when equipped with Firmware >= 1.2.217 intergrate seamlessly into the Philips Hue system, thanks to t… – Jan Wildeboer – Google+:

  • IKEA lamps integrate with Philips Hue
  • Philips Hue lamps integrate with the
  • IKEA lamps pair to the remote that you paired with the gateway before: no need to bring the lamp close to the gateway first
  • Philips tries the same
  • Remotes have a 10-decide limit

Links:

--jeroen

Posted in IKEA hacks, IoT Internet of Things, LifeHacker, Network-and-equipment, Power User | Leave a Comment »

Vloerkleden l Tapijten l IKEA

Posted by jpluimers on 2019/03/04

Read the rest of this entry »

Posted in IKEA hacks, LifeHacker, Power User | Leave a Comment »

Generating a million sequential numbers on the fly in a Firebird query – some solutions and speed measurements

Posted by jpluimers on 2018/07/19

The testing was done with Firebird 2.5.x x86 on Windows 7 x64.

Where other relational database platforms have plenty of opportunities to generate sequences (see for instance the below links on Oracle and SQL Server), with Firebird you can use a WITH RECURSIVE query construct that normally is being used to manage tree structures ([WayBack] PkLab – Firebird: Tree data mangement with recursive CTE).

However, that uses query stack which has a depth limit of 1024 levels. When you reach the limit, Firebird gives you an error like this:

with 
  recursive 
  sequence(n) as (        
    -- When you select more than 1024 values, this error occurs:
    -- Error while fetching data:  Too many concurrent executions of the same request    
    select 0 -- start
    from rdb$database
    union all
    select sequence.n + 1
    from sequence
    where sequence.n < 1023 -- finish
  )
select sequence.n 
from sequence
--where sequence.n in (24, 38) 
order by sequence.n

It however is a pretty quick and CU bound solution: on my system ([WayBack] AMD A8-7600 @ 3.1 Ghz), it runs 1000 records within ~0.1 seconds.

In such a short time, it’s hard to see how the speed is bound, so I wanted to go for some orders of magnitude more. In ~0.1 seconds, the processor executes about 0.3 * 10^9 cycles generating 1000 numbers which is ~ 300-thousand cycles per number. That sounds like a lot of cycles for so few numbers. Would this become a better ratio for more numbers?

Read the rest of this entry »

Posted in Database Development, Development, Firebird, IKEA hacks, OracleDB, SQL, SQL Server | Leave a Comment »

Teardown of an IKEA Koppla USB power supply. – YouTube

Posted by jpluimers on 2018/04/06

Seems like  a good USB power supply:

Posted in IKEA hacks, LifeHacker, Power User, USB | Leave a Comment »

« Previous Entries