Access Skype SQLite Database

I was working for Online Radio Server setup with Icecast and Skype. This Radio Station was using Skype Group Calls with real listeners of station then I have to feed Live Skype Audio to Icecast Radio Server as Input. Radio Setup Tools Online Radio Schedule with Skype & Icecast – SAM Broadcaster – Icecast Server … Read more

SQL: The Essential Database Language

Structured Query Language (SQL) is a specialised programming language designed for use with databases. SQL is a standard language when working with relational databases, allowing rapid sorting of large databases. If you are serious about a career in IT, then SQL training is essential, even if you don’t plan on becoming a database specialist. There … Read more

Importing data from non-wordpress mysql database

You have to create an import php file to get the Questions/Answers from a non-wordpress database and bring them into posts in wordpress. Question Table <?php /// non-wordpress database connection string here require(‘./wp-load.php’); $results = mysql_query(“SELECT * FROM questions”); while ($row = mysql_fetch_assoc($results)) {     $post_information = array( ‘post_title’ => wp_strip_all_tags( $row[‘question’] ), ‘post_content’ => $row[‘answer’], … Read more

SQL OR NOSQL?

If you are searching for SQL or noSQL solutions, it is very difficult to decide among top SQL / noSQL Databases. MySQL is the best for multi-document transactions, complex security, complex join, extreme compression. NoSQL is good for linear scalability, high performance, schema flexibility. But both depend on data need to manage 😉 Scalability MySQL … Read more