Simple site for editing simple data

Apr 22 2020


As a developer I often have a settings table which is only editable by database tools (e.g. sql or text editor) and often only on the backend server. It would be nice to have a solution to allow easy editing while not being on the backend.


A small xcopy:able web site or application.
For database data it could have a connection string to the server and for text files it could have a path.

It should be able to figure out some meta data by itself but then, with local settings, override them to a more user friendly format.
For instance, if settings is a CSV table, the local settings could have definitions for separator characters, column headers and column data types.

This suggested solution is not for production but would solve the problem during development and even for production time backend manipulation in the right, careful hands. The same hands that otherwise would write sql queries to do the same task.

No responses yet

A ski or snow board binding that stretches higher than today

Feb 17 2020

All slalom ski boots or snow board bindings only stretch so far up.
We do want a fix position, so we might want to make the slalom boot higher or snow board binding higher; maybe to almost below the knee.

No responses yet

Snow board bindings that can rotate easily when required

Feb 17 2020

When riding snowboard the bindings should not rotate but be i a fix x degrees angle.
When kicking the snowboard with the rear foot loose and the front foot fastened the angle should be straight forward (or at another angle).

Why not have a simple manually operated lock/lever that lets the rider loosen the binding to rotate.

Then, when about to ride again, use the same lock/lever to lock the binding in position?

No responses yet

A height distance tool for cutting food to a certain depth

Jan 28 2020

When making hasselbackspotatis one cuts the potato almost through.

Instead of cutting carefully or holding the knife at a certain angle why not surround the potato with wooden blocks of the same certain height.

Change the potato to a carrot and a block on each side to achieve the same result.

Exchange the potato or carrot to anything.

No responses yet

Everything on this site is creative commons

Dec 28 2019

This site contains ideas and solutions for the world to use and not own.

No responses yet

A car roof rack that is easy to put on and take off

Dec 28 2019

A problem that was solved ages ago, how to mount and remove a roof rack with a click or the turn of a knob, has become unsolved.

Today’s solution is to have special nuts (threaded holes) in the car’s roof and screws to match.
This means every car model has its own setup and it is quite a lot of job, possibly with a special tool, to mount the roof rack.

I suggest, in lieu of the classic drop list, to keep the threaded holes but to have an adapter to mount.
Normally the adapter should be taken off as soon as possible but if it is not, it is stream lined and creates as little drag as possible.

On this adapter the roof rack can be mounted with ease, and not screws.

This way the car can be as stream lined as possible. Then, when need arises and with a little work it can be prepared for roof racks. Finally the roof racks can be mounted and removed quickly and with ease.

No responses yet

An alarm clock that does not wake your spouse

Sep 26 2018

I do not always rise at the same time as my spouse who is sleeping next to me.

I have the idea of an alarm clock that makes you wake but not your spouse.

One response so far

Centre punch that does not glide

Aug 24 2018

When using a centre punch in a wood like fir it is very common it slides of the brown line into the lighter brown part. The brown line is winter? wood and harder.

I want a centre punch that doesn’t do this but instead makes the hole exactly where I put it; want it.

One solution can be to have a tube, think drinking straw, but in metal, but sharpened in the business end. Pressing it against wood would make a round mark. Since it is a couple of millimeters in diameter there is a good chance it gets a grip so it doesn’t skid off any brown line. Marking with a centre punch is often done for drilling so marking a 4mm ring does not create any damage if one intends to drill with a +4mm drill; or an even wider mark if a screw head will cover.

Inside this tube is a sharpened rod. So when the tube has a good grip, just press the rod down, and now you have a centred mark.

If it is hard to centre the tube one could start with letting the rod protrude and put where wanted; but without the pressure that will make it skid; and then lower the tube so it grips, and finally press the rod.
Or one could have a template or jig, say a see-through piece of plastic with a hole exactly fitting the tube. Adjust the jig/template by eye, it should be easy with these small distances, insert the tube and press down the rod.
If the precision is not enough, have a see through inset with a cross hair. Adjust the jig/template with the exact crosshaired inset in place. Remove the inset. Place the tube. Press the rod.

I have seen semi automatic spring loaded centre punches but they all lack the sharpened tube.

Another solution, that won’t mark around the single mark we want is to have a see through plastic template with a, say 10mm hole in it. In this hole is placed an inset with a crosshair to align exactly. Then the inset is removed and the punch is inserted and pressed. This solution is very similar to the one above but relies on the template staying in place instead of the sharpened tube doing it.

No responses yet

Note paper with QR codes for backing up

Aug 21 2018

For taking notes, paper and pen beats any computer. But taking backups of paper notes is a task. Not a difficult task or a task that takes long time but still a task taking long enough to never be done.

So let’s give some incitament.

First let the cellular take care of backing up. Everyone nowadays, at least anyone that should be interested in this idea, has a cellular with a camera good enough for taking a recognisable photo of a sheet of paper.

Ordinary photo copier paper is quite good for writing so let’s use that. It is cheap and the copying machine is already stuffed with it.

Print a paper with a QR code in two corners. Let this QR code have some info in it that is identifiable by an app (or system). Say it contains a consecutive Number for Your id. Print 30 of them the first of the month and stick in your binder. If you are on a note taking spree, print some more. The app just makes up new, recognisable, QR codes. The QR codes also makes it easier for the app to recognise the corners of the paper sheet so you don’t have to be so thorough when photographing the paper.

Take a photograph of it with you cellular and the app and wham bam it gets backuped. The time line is known. If you go back and edit an older paper, take a photo and it is backup’ed in complement to the older backup.

Put in some OCR and maybe maybe your handwriting can be recognised.

Put in some simple boxes to tick the date or some icons to mark for different meanings. “Backup secretly, I will destroy this original paper.”, “Send as email attachment to myself”, “Send as email link to Ms Moneypenny.”, “Store in personal stack”, “Store in office stack.”

While we’re at it. Print your name and number on every sheet. Print some light grey markings so you can draw right angles. Print heavier black lines on the backside. These will shine through when writing but not when photo copying or backing up with the cellular camera.

One response so far

Electric bicycle trailer that pushes its own weight but not more

Aug 20 2018

With my electric cargo bike I can carry only so much cargo. I have an idea about an electric trailer that doesn’t push or help with the forward movement in any way but stay totally neutral. This way there is less chance of breaking any bicycling laws. Let it also have a maximum speed of 25 km/h to surely and totally stay inside the frames of law.

In a very simple solution it can be connected like any other bicycle trailer but it is sensitive to push and pull forces on the hitch. It can have a short play and fast reaction or long play an slower reaction. With the latter a normal PDI regulator might work. Or even a P regulator, albeit with a logaritmic curve. When the tow bar gets pulled, longer, the motor accelerates. When the tow bar gets pushed, compressed, the motor breaks.

It is possible it does not work, that it will play the forces in such a way it will try to throw the bicycle of balance; but why should it? An unpowered bicycle trailer will try to tilt the bicycle as soon as a wheel hits a pothole or one has to break downhill; and they seem to be doing alright.


No responses yet

« Newer - Older »