GIT: Updating the current branch in a non-bare repository is denied…

simple

February 23, 2012

Development

No Comment

Sometimes there are days when you just forget to configure your git repository on the server and that are the days when you run in awkward errors like that: [crayon-5c121ce537c66673207353/] The fix for this is simple, just configure your git repository on the server as a bare repository: [crayon-5c121ce537c6c907557217/] Then remove all files and directories, […]

Read More

Database: Migration from SQLite to MySQL

simple

September 6, 2011

Databases

No Comment

After working with some sqlite databases for one of my iOS projects lately, I have now decided to also add an online service for the project. But how can I migrate from sqlite to MySQL? Here are the basic three steps, I figured out that are needed to extract and modify the DDL to be […]

Read More

Oracle: How to get a formatted string from a date?

simple

September 2, 2011

Development

No Comment

If you work with SQL on Oracle you sometimes want to extract additional informations from a date field and also limit this result to a distinct set. So for example to get all distinct years of a date field from a data set, you can use the following statement, which uses a subquery: [crayon-5c121ce538cae174113043/] We […]

Read More

Oracle: Escape ampersand (&) characters in SQL*Plus

When importing a backup you might have run into the problem that the ampersands (&) or colon () characters are used as bind variables in PL/SQL. This is actually no real problem, as you can simply change the substitution character using the DEFINE setting in SQL*Plus: [crayon-5c121ce538fc5383013744/] The usual substitution mechanism an ampersands would trigger, […]

Read More

Oracle: Drop All Trigger and Drop All Database

To drop all triggers in a schema, simply execute: [crayon-5c121ce539326077821891/] To get drop queries for all tables in a schema, simply execute: [crayon-5c121ce53932c240883128/] or you can get drop queries for all user objects in a schema by executing: [crayon-5c121ce53932f893963304/]

Read More

Oracle: Disable ArchiveLog Mode

Sometimes it is unnecessary to use ArchiveLog mode with the Oracle database. If you do not know what ArchiveLog Mode is – here is a short statement: “Any Oracle database that contains important data should be running in ARCHIVELOG mode. Running in Archive log mode enables you to take hot backups and perform point-in-time recovery.” […]

Read More

How to drop multiple tables in MySQL

simple

February 9, 2011

Databases

No Comment

If you want to drop multiple tables in MySQL (current version 5.05 or before) you will find no command for that. But there is a simple way using some console commands, just hit your shell and simply paste this snippet: [crayon-5c121ce5395ca070767150/] Do not forget to replace [USER], [PASSWORD] and [DATABASE] with your settings. As always […]

Read More

iPhone OS: Enterprise Business Tools

If you need to manage iPhones or iPads in a big enterprise business, your should read Apples Support Documents: http://www.apple.com/de/support/iphone/enterprise/ and in any case download the iPhone Configuration Tools for Mac OS X: http://support.apple.com/kb/DL851 and for Windows: http://support.apple.com/kb/DL926 You can then setup configuration profiles, that reflect the setup of your environment: • Passcode-Richtlinien • Funktions-Einschränkungen […]

Read More

iPhone OS: Design a nice InApp Purchase View

To get up a nice InAppPurchase View for Apple’s AppStore, we first need some good looking buttons: http://code.google.com/p/iphonegradientbuttons/ http://undefinedvalue.com/2010/02/27/shiny-iphone-buttons-without-photoshop/ http://iphonedevelopment.blogspot.com/2010/05/improved-gradient-buttons.html http://stackoverflow.com/questions/422066/gradients-on-uiview-and-uilabels-on-iphone/ There are also some tweaks for the UITableView you might consider using: http://stackoverflow.com/questions/400965/how-to-customize-the-background-border-colors-of-a-grouped-table-view/ http://stackoverflow.com/questions/986392/programmatically-force-a-uiscrollview-to-stop-scrolling-for-sharing-a-table-view/ more information upcoming…

Read More

iPhone OS: Setup an additional Security Layer

As you might already know the iPhone is itself not that secure that people might think (news is german): http://www.heise.de/security/meldung/Luecke-in-Datenverschluesselung-des-iPhones-1007818.html How do you prevent intrusion of your customers data? As a really pragmatic approach, we can just set up additional encryption for our application data: http://stackoverflow.com/questions/2579453/nsdata-aes-class-encryption-decryption-in-cocoa http://iphonedevelopment.blogspot.com/2009/02/strong-encryption-for-cocoa-cocoa-touch.html http://pastie.org/974094/ So if you use for example core […]

Read More