LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 03-16-2015, 04:52 PM   #1
ShermW0829
LQ Newbie
 
Registered: Mar 2013
Posts: 2

Rep: Reputation: Disabled
Which database for PERL on Linux and WIndows?


I'm writing this program for my own edification. I want to write and retrieve from a database. I will start on Linux and probably use MySql. After I get the program working on Linux I would like to be able to use it on a Windows 7 or 8 platform. Here are some sample entries I would like to write to and draw from. Which database would you use? Does MySql work on both Linux and Windows?

Casino Date Buy-in time-at-table exit-monies
Binions 05/05/2015 200 3.5 -400
Wynns 05/06/2015 200 5.0 +400

Trip Total -200

Thank you;

Sherman
 
Old 03-16-2015, 05:56 PM   #2
Pearlseattle
Member
 
Registered: Aug 2007
Location: Zurich, Switzerland
Distribution: Gentoo
Posts: 934

Rep: Reputation: 104Reputation: 104
Hi
Quote:
Does MySql work on both Linux and Windows?
Yes

But:
MySql now belongs to Oracle and as Mr. Ellison is hardcore commercial, the focus of MySQL is/will probably to push you towards some kind of paid license.

Recommendation
0)
It doesn't matter very much what you'll put into the DB - the "what you want to do with it" is more important.
1):
use "MariaDB", which is the open-source fork of MySQL.
(I think that I read on wikipedia that "My" was the name of the first child of the guy who created "MySQL" and "Maria" was the other child - or maybe I'm just stupid to believe that)
In any case the recommendation stands - I'm using it for some tables that hold a couple of million rows and it's working fine.
2)
Use some abstract layer.
I used "PDO" with PHP and I didn't regret it.
I have no clue about Perl - from what I'm finding now you might want to use "PDI", just have a loook around.
 
Old 03-16-2015, 06:29 PM   #3
smallpond
Senior Member
 
Registered: Feb 2011
Location: Massachusetts, USA
Distribution: CentOS 6 (pre-systemd)
Posts: 2,614

Rep: Reputation: 703Reputation: 703Reputation: 703Reputation: 703Reputation: 703Reputation: 703Reputation: 703
If you program to the abstract DBI module, then you can use the DBD driver for any database on the back end. There are a lot of DBDs supporting everything from Excel to Oracle.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
database and Perl/tk umesh_linuxq Linux - General 3 04-06-2012 09:59 AM
database Conenctivity between Linux & Windows ddmohapatra Linux - Newbie 1 05-18-2009 04:15 PM
Windows Oracle database access from Linux edsalvador Linux - Networking 1 03-16-2008 12:54 PM
Need help with database perl silhoutte Linux - Newbie 4 05-24-2005 12:12 AM


All times are GMT -5. The time now is 02:28 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration