Author Topic: The Qur'an in .sqlite format  (Read 1635 times)

عوني

  • Advanced Truth Seeker
  • ****
  • Posts: 1306
  • Karma +0/-0
  • Gender: Male
The Qur'an in .sqlite format
« on: January 31, 2017, 06:41:27 AM »
Any other developer around? I'm wondering if you know where I can find the Qur'an (on all translations in English) in .sqlite format? I've tried looking and haven't been able to find one, and trying to convert one from .sql to .sqlite is giving errors

Aladin from Azra tribe

  • Apprentice
  • **
  • Posts: 305
  • Karma +0/-0
  • Gender: Male
Re: The Qur'an in .sqlite format
« Reply #1 on: January 31, 2017, 08:04:06 AM »
There cannot be both opinion and knowledge
of the same thing at the same time

"The First Teacher", Aristotle

Aladin from Azra tribe

  • Apprentice
  • **
  • Posts: 305
  • Karma +0/-0
  • Gender: Male
Re: The Qur'an in .sqlite format
« Reply #2 on: January 31, 2017, 08:05:44 AM »
I'm not using SQL Lite, but if you need any help maybe I can help you. I'm currently working on some project for myself and I'm using Delphi and php, with mySQL and txt/ini files.
There cannot be both opinion and knowledge
of the same thing at the same time

"The First Teacher", Aristotle

Bender

  • Wise One / Burnout
  • *****
  • Posts: 2587
  • Karma +0/-0
  • Gender: Male
Re: The Qur'an in .sqlite format
« Reply #3 on: January 31, 2017, 11:13:11 AM »
I am not a developer but is it not possible to import the data via excel?
May I ask why you need it in .sqlite?
Alhamdu lillahi rabbi al-alameen

Cerberus

  • Truth Seeker
  • ***
  • Posts: 640
  • Karma +1/-0
  • Gender: Male
Re: The Qur'an in .sqlite format
« Reply #4 on: January 31, 2017, 01:03:59 PM »
I'm not into back end development (yet) but I think you can get a JSON format of the quran using one of the plenty available Quran APIs, and then try to convert the JSON object to a SQLite. Stackoverflow might help you.

Timotheus

  • Truth Seeker
  • ***
  • Posts: 852
  • Karma +0/-0
  • Gender: Male
Re: The Qur'an in .sqlite format
« Reply #5 on: January 31, 2017, 02:09:07 PM »
Peace,

Should be relatively easy to covert using the right tools, what have you tried, and what errors do you get?
What could i say that is better than what God has already informed us of?
Follow God
Seek His guidance, the only guidance
Glory and Praise be to God, rabbil Aalameen

عوني

  • Advanced Truth Seeker
  • ****
  • Posts: 1306
  • Karma +0/-0
  • Gender: Male
Re: The Qur'an in .sqlite format
« Reply #6 on: February 01, 2017, 06:39:48 PM »
Thanks all for answering.. I tried the qurandatabase site before but sadly couldn't find for .sqlite format. I managed to solve it though, I converted it from .sql into a .csv file and then finally to sqlite and it worked like a charm. The reason why I want .sqlite format is because I'm building a software for a friend that's similar to corpus qur'an and I don't want to use MySQL for example to look up verses in the software since it requires you to be connected to a server and therefor not a good practise and is pretty slow (especially the one for C#) when you open a connection.. Sqlite is faster and I want to keep it to SQL since I know the syntax very well, having used it for years now so I went with sqlite.




I'm not into back end development (yet) but I think you can get a JSON format of the quran using one of the plenty available Quran APIs, and then try to convert the JSON object to a SQLite. Stackoverflow might help you.

The JSON option might be possible but I did something similar and it worked and yep honestly I was considering Stackoverflow after all the frustration of trying to convert it.



Peace,

Should be relatively easy to covert using the right tools, what have you tried, and what errors do you get?

It was definently not easy. The tools I used to convert from .sql to .sqlite didin't really convert it into an .sqlite format, it only changed the file type while leaving the content the same.




savage_carrot

  • Administrator
  • Wise One / Burnout
  • *****
  • Posts: 6683
  • Karma +16/-2
Re: The Qur'an in .sqlite format
« Reply #7 on: February 01, 2017, 09:36:38 PM »
Well done Awni :)
God has a plan, Gaius. He has a plan for everything and everyone.

Timotheus

  • Truth Seeker
  • ***
  • Posts: 852
  • Karma +0/-0
  • Gender: Male
Re: The Qur'an in .sqlite format
« Reply #8 on: February 01, 2017, 09:45:44 PM »
Peace,

What kind of software are you developing? I've been thinking lately of an Android app to simplify study
What could i say that is better than what God has already informed us of?
Follow God
Seek His guidance, the only guidance
Glory and Praise be to God, rabbil Aalameen

عوني

  • Advanced Truth Seeker
  • ****
  • Posts: 1306
  • Karma +0/-0
  • Gender: Male
Re: The Qur'an in .sqlite format
« Reply #9 on: February 02, 2017, 11:38:11 AM »
Well done Awni :)

Thank you :)

And so people know it's Savage_Carrot's idea to create the software so all credits goes to her. 8) It's an awesome idea 


Peace,

What kind of software are you developing? I've been thinking lately of an Android app to simplify study

Just a software that will make it easier for you to study the Qur'an.. Similar to Corpus Qur'an