How to install Yinkos Job Application Manager
Hi,
In this article, we will cover how to install Yinkos Job Application Manager (YJAM).
In addition to accessing and using YJAM in your web browser, you can also install the app on your mobile devices or computer for easier use.
Here’s how to do it:
Installing Yinkos Job Application Manager on Android
On your Android device, open Chrome
Visit https://job-application-manager.yinkos.com/
Press the “three dot” icon on the upper right to open the menu
Tap Install app
Click Install
Installing Yinkos Job Application Manager on iOS
A PWA can only be installed on iOS using the Safari web browser.
First, navigate to https://job-application-manager.yinkos.com/ on Safari.
Click Share icon.
Click Add to Home Screen.
Click Add.
Installing Yinkos Job Application Manager on a Windows PC or Mac
Both Google Chrome and Microsoft Edge can install PWAs on Windows and Mac. The instructions are very similar for both.
Navigate to https://job-application-manager.yinkos.com/
There should be an icon on the right side of the URL bar. Click the icon
Click Install.
Alternatively, you can install the PWA from the “three dot” menu.
On a Windows PC, Yinkos Job Application Manager will be available in the start menu.
On a Mac, Yinkos Job Application Manager will be in the launcher and in the spotlight search.
Chrome
Microsoft Edge
How to invoke Oracle sequence a specific number of times
Hi folks,
In this article I talk about how to invoke the next value an Oracle sequence specific number of times. Sequences are used to generate values for columns to produce auto-increment functionality.
We use the nextval to fetch the next value of a sequence.
To get the next value a number of times, say 10 times, run the following query
select level, mysequence.nextval from dual connect by level<=10;
That’s all for now. Till next time, happy software development.
How to manage software development teams in an Agile manner
Hi folks,
In this blog I discuss a few practices that can help one manage a software development team effectively using the Agile methodology. They are as follows:
- Use good tools e.g. Jira or Trello to manage requirements.
- Use a backlog to store all requirements that may be useful to complete by the team but are not ready for current work.
- Clarify new requirements from business before presenting it to software development team – this can be done by development team lead or business analyst.
- Have your software devleopment team estimate efforts to complete requirements together as a group. You can use story points to estimate efforts where story points may be roughly mapped to days. it’s common for teams to use fibonacci sequence for story points.
- Break down large requirements into smaller tasks that can each be completed within a couple of days.
- Have daily stand-up calls to monitor progress of the software development team.
- Have periodic sprints of e.g. 1 week or 2 weeks to serve as checkpoints to monitor progress of the development team.
- Don’t drag requirements from sprint to sprint unnecessarily. Try to have the team complete requirements they have committed to complete in a given sprint.
- If you’re nearing the end of a sprint and a developer needs a task to pick up, you can look at any task in the backlog that can to be completed within the sprint and assign that task to the developer. If there’s no such task, you can look at sub-tasks of any larger tasks in the backlog that can be completed in the sprint. You can then convert that sub-task into a regular task (you can update the task title to indicate it’s a sub-task of the parent for easier tracking). Then assign the new task to the developer.
- Perform retrospectives from time to time to get feedback from developers on how they’re faring with work.
- Have frequent software releases to production. Don’t let features pile up too much otherwise it could lead to difficult in troubleshooting issues.
Till next time, happy software development.
How to add hymns with Yinkos Hymns Manager
Hi folks,
In this article we will cover how to add hymns or any other kind of songs with Yinkos Hymns Manager.
First, log in to the app.
Go to the Hymns screen by clicking the Hymns button or by clicking on Hymns Management > Hymns from the top menu.
Next, click the Upload button. You will be taken to the Add a new hymn screen.
Enter details for the hymn/song and select the audio file. You can enter just hymn number if creating a hymn entry. You can also enter a custom title.
Click Save when done.
That’s all you need to add a hymn with Yinkos Hymns Manager.
Till next time, happy music management.
How to record music with Yinkos Hymns Manager
Hi folks,
In this article we will cover how to record hymns with Yinkos Hymns Manager.
First, log in to the app.
Go to the Hymns screen.
Next, click the Record button
You will be taken Record a new hymn screen
To start recording, press the Start button
If doing this for the first time, the browser will ask for your permission to record using your microphone. Make sure you grant permission. Once recording has started, you will see a message Recording… appear.
Once you have finished recording your music, press the stop button
To play your recording, press the Play button. A player will appear and play the song.
If you’re happy with the song, then enter the title of the song and version. Then click Save.
That’s all you need to record a song with Yinkos Hymns Manager.
Till next time, happy music management.
Database Trigger
Hi folks,
In this post I will talk about database trigger. A few days ago, a colleague working on a piece of software I develop tried to submit some code containing database triggers for review. I hadn’t seen any codebase with database triggers until that point. Another developer who looked at the code felt the triggers ought to be removed. This got me curious about what triggers are what they are used for.
What is a database trigger? A database trigger is procedural code that gets executed automatically when certain events happen on a table or view in a database. Triggers are mostly used for maintaining the integrity of the information in the database. E.g. When a new record (for a new worker) is added to the employees table, a trigger can be used to add new records to the taxes, vacations and salaries tables. Triggers can be used to log historical data too for auditing purpose.
Thinking about trigger, I feel they must be used with caution because it is easy for developers to not even know that the triggers exist. This could lead to surprises and lots of time debugging code. This problem can be minimized though through good documentation.
Also, the use of triggers mean the business logic is handled in not just the application source code but in the database which could make it more difficult to understand how the applcation works. Furthermore, it may take more effort to write and maintain automated tests for database triggers.
That’s all for now. Till next time, happy software development.
References
Database Trigger. Wikipedia. https://en.wikipedia.org/wiki/Database_trigger.