Categories
OpenBSD

HP Ink Tank Wireless 410 Printer on OpenBSD 6.7

Recently i have successfully printing a test page from my HP printer on my OpenBSD 6.7 laptop after reading and practicing an article on website of mp-5 text editor (see it on my other post). I use following step.

1. add required packages using pkg_add cups gtk+3-cups hpcups hplip.

2. edit /etc/rc.conf.local as follow on pkg_scripts section.

3. restart openbsd.

Categories
editor linux OpenBSD

Minimum Profit : A Programmer Text Editor

Minimum Profit is a text editor for programmer available to download from https://triptico.com/software/mp.html. I accidentally found this software from article related to OpenBSD and the author is the creator of this mp editor. The downloads are available in source and windows executable (Wow).

I managed to compile mp 5.38 on debian 10 using ncursesw driver which is already available on my laptop. Compilation step as follow.

Categories
OpenBSD

Upgrade OpenBSD 6.6 to 6.7

This is my first time upgrading OpenBSD. Usually i do full reinstall but it just too time wasting, so i tried these step.

  1. sysupgrade
  2. pkg_add -u

sysupgrade will update your OpenBSD by rebooting and download installation package from internet (i think). Then pkg_add -u will update all of installed program (take a long time). Its a successful upgrade. Thanks to OpenBSD developer who make it so seamless and work beautifully. Great work.

Categories
mysql postgresql

Postgresql/Mysql : Selecting random rows

Let say we have a table containing famous quote and we want to show a random quote. How do that in postgresql ? Try this.

Select * from quote order by random() limit 1;

for Mysql use rand instead.

Select * from quote order by rand() limit 1;

 

Categories
editor linux

Playing with Emacs – Open file, edit, save file.

Emacs is an editor, but not just it. Thats what i read on internet. Emacs like in a battle with Vim, another editor. I have play with vi so many years ago, but with emacs  it is just recently i learned to use it basic function.

Install it on ubuntu we can choose GUI or terminal version. I like the terminal version because it will be handy during my engagement with VM/Cloud which only can use terminal to manage it.

Open Emacs by typing on terminal emacs and press enter, it will show a welcome page like below.

We can move cursor to a hyperlink and press enter to go to particular subject, like tutorial or manual. Tutorial can also accessed using key combination C-h t, which mean press Ctrl and hold then press h, release keys, then press t. C is Ctrl and M is Meta (Alt/Esc).