Removing Expiration Date of Oracle Express Database

oracle_sqlplus

I currently work on a project that uses Oracle database. For the local development, I installed it with Docker. I’ve found a handy docker file of Oracle Database Express Edition 11g published by wnameless in Github or in the official page in Docker Hub.

It’s so easy to use, that I just need to type sudo docker start oracle to get it up and running. Of course by reading the Readme first.

But then I noticed an error: ORA-28002: the password will expire within 7 days. Although it doesn’t affect the app, I feel a bit annoyed. So I googled it, and found the solution afterward. But I lost the URL. My bad!

Just take a look at above picture. I won’t type in the command here, as you can found it somewhere in Stackoverflow, actually. 😀

Advertisements

Hello, Vim!

Yeah, eventually I’ve got a chance to meet Vim more intensively from now on. Who is she? No worries! She is not a girl nor a lady. You’re still the one for me. 😀

“Vim is a highly configurable text editor built to enable efficient text editing. It is an improved version of the vi editor distributed with most UNIX systems.” That’s how she describes herself. 1 So, basically Vim is a text editor. Period.

Then, comes a question, why Vim? Umm, frankly, it’s hot lately. I wonder how awesome it is. And yes, it is. Also, considering my needs of text (code) editing, and the hardware spec I have, I think Vim worth trying. Initially I have Atom, as I want something more legal than Sublime Text, that often (I mean always) remind me to purchase it. But with a lot of plugins I installed, it became more laggy. So I broke my idealism to avoid ST, and make use of it instead, until now sometimes. But ST is quite memory-greedy for my 2 gigs laptop, that I also regularly needs browser to run hand in hand while coding. I’m a coder by the way. 😀

Then the hero eventually came in. It’s Vim that now becomes my main text editor. Although I just already use it intensively since 2 or 3 weeks earlier. In other words, I am still getting used to it as a newbie Vim-er, of course. So I haven’t found it’s real hidden magic either. I’m sure with consistency and persistence, I’ll have it’s main enticement: productivity. And for now, I have to get along with her more. Wish me luck. 😀

Speaking of which, I use Vim in my Fedora KDE Spin, and run it in the beloved Konsole app. Here’s my screenshot of Vim.

Screenshot_20170816_101047.png
Vim with NERDTree plugin, makes it looks like GUI-based text editor with left pane

QR Code Scanner with Qt Framework + OpenCV

I need a program for scanning QR code and processing the data. For this purpose, there are several libraries which can help saving my time for developing it. For instance, ZXing library, or ZBar. For web developers, there are also corresponding library for scanning QR code, that are both client side (JavaScript) and server side (PHP). Continue reading QR Code Scanner with Qt Framework + OpenCV

Auto build Launchpad Project on Commit

If you have a project hosted on Canonical’s Launchpad, then you have a choice to build it as soon as you push its Bazaar commit. The automatic build process is conducted by a “recipe”. Cited from official explanation, there are two options for when recipes get built:

Built daily
A build will be scheduled automatically once a change in any of the branches used in the recipe is detected.
Built on request
Builds of the recipe have to be manually requested using the “Request build” action.

You can create a recipe from project page, and look for “Create packaging recipe”. Then you need to choose the “Built daily” option to automatically build the DEB binary from source when you push the commit.

Build recipe Launchpad Canonical Ubuntu
Build recipe Launchpad Canonical Ubuntu

Then you can compose the packaging recipe by refering to the official documentation here: https://help.launchpad.net/Packaging/SourceBuilds/Recipes

HTML5 App for Desktop Using Qt WebKit

Qt WebKit HTML5 App
Qt WebKit HTML5 App

It’s been a long time since the last time I wrote about Qt programming. This time I’d like to share my recent activity on developing the desktop version of my Android webapp, Hafal Quran. You can download it from Google Play Store by clicking this badge:
Android app on Google Play

My purpose is that the app can run on most platform. So it led me to choose HTML5 approach. And finally I come up with the app website which everyone can play it on http://hq.amzone.web.id. The Android app is the first platform-specific release of Hafal Quran.

While it looks like already reaches the final version, it actually lacks an important aspect, i.e dis-connectivity. We have to connect to internet to play it. Of course we cannot play it when go offline. So now, I continue its development to the next step: offline mode.

The first development should be focused on the Android version, as the users of mobile devices are the most and growing. But for now, I will make the offline version for desktop first. In this case, I choose to deploy it for Ubuntu Linux distro and the derivatives, particularly Grombyang OS Edu.

Technical overview

I utilize Qt framework for the development because I have some experiences in it. Besides, I decided to use Webkit as the engine of the app. And actually it is part of Qt framework itself. Webkit is the infamous engine for most popular browser, including Safari, Chrome, and even Opera.

But unfortunately, QWebKit module is now being deprecated since Qt 5. And it is now superceded by QWebEngine module. So, for now, I will still use QWebKit module of Qt4.

The drawbacks of using Webkit is probably about the memory usage. Since Qt modules are quite greedy in terms of consuming RAM.


FYI, the Android app was one of 50 apps that were selected at Finding Top50 Local Apps event, which was held by Baidu Indonesia last year.

Debugging android cordova/phonegap apps with Chrome

Check this out! It’s totally awesome tips for Cordova / PhoneGap developers (who have some limitations).

Gonzalo Ayuso | Web Architect

Maybe this post can be obvious but I’ve spoken about it with various developers who don’t know it. It really improves the developing process of cordova/phonegap apps with android at least for me.

With android we can see the log with “adb logcat” but it’s a nightmare. Huge amount of information about our app and also about the operating system. If we’re grep ninjas we can handle it, but as well as I’m not a ninja I prefer another solution. Do you know “chrome://inspect/”? If not, have a look as soon as possible to this tool. We can see the browser’s console of our android in our desktop browser. We only need to enable “usb remote debugger” within our android device and plug with a USB cable. Chrome will detect the remote browser and we can see the console in the same way than we see it when we use…

View original post 127 more words

Adakah ini akhir dari Nokia? Awal yang baru, kata mereka

Jadi ini ceritanya mau belajar bikin aplikasi buat Nokia Asha S40. Sudah agak lama sih. Sudah ketinggalan jaman yah? Memang. Sudah susah-susah install SDK di Ubuntu, eh, dapat email dari Nokia: judulnya “New beginnings for classic Nokia phone developers“. Email pada gambar tersebut memberitahu bahwa Nokia Store akan mengalihkan aplikasi-aplikasinya ke Opera Mobile Store. Proses akan selesai pada semester awal tahun depan. Sudah tahu kan kalau Microsoft sudah mengambil alih divisi Nokia Mobile. Mengubah merk Nokia Lumia menjadi Lumia saja. Dan pada akhirnya menghilangkan dukungan pada platform yang lebih lawas. Termasuk platform Asha, dan juga Nokia X sang pengusung Android di keluarga Nokia.

Perlu diketahui bahwa pengguna ponsel “bodoh” (lawan dari ponsel pintar) masih banyak saat ini. Sebagai patokan, lihat pada web app yang saya upload ke Nokia Store, termasuk feed reader resmi blog ini (link ada di sidebar kiri). Statistik unduhan setiap harinya menunjukkan stabilitas jumlah (saat tulisan ini dibuat, rata-rata perhari antara 300-400 unduhan, total 3 web app). Itu adalah jumlah untuk aplikasi yang tidak populer. Bagaimana dengan aplikasi yang sedang ngetren? Anda mungkin bisa mengira-ngira sendiri. Continue reading Adakah ini akhir dari Nokia? Awal yang baru, kata mereka