Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
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!


  Search this Thread
Old 03-16-2015, 03:52 PM   #1
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;

Old 03-16-2015, 04:56 PM   #2
Registered: Aug 2007
Location: Zurich, Switzerland
Distribution: Gentoo
Posts: 978

Rep: Reputation: 118Reputation: 118
Does MySql work on both Linux and Windows?

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.

It doesn't matter very much what you'll put into the DB - the "what you want to do with it" is more important.
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.
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, 05:29 PM   #3
Senior Member
Registered: Feb 2011
Location: Massachusetts, USA
Distribution: CentOS 6 (pre-systemd)
Posts: 2,799

Rep: Reputation: 749Reputation: 749Reputation: 749Reputation: 749Reputation: 749Reputation: 749Reputation: 749
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.


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 08:59 AM
database Conenctivity between Linux & Windows ddmohapatra Linux - Newbie 1 05-18-2009 03:15 PM
Windows Oracle database access from Linux edsalvador Linux - Networking 1 03-16-2008 11:54 AM
Need help with database perl silhoutte Linux - Newbie 4 05-23-2005 11:12 PM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 12:46 AM.

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