New topic: what is the Best PostgreSQL or MySQL
<http://forums.realsoftware.com/viewtopic.php?t=47880> Page 1 of 1 [ 15 posts ] Previous topic | Next topic Author Message jetpr Post subject: what is the Best PostgreSQL or MySQLPosted: Tue May 14, 2013 12:59 pm Joined: Wed Sep 20, 2006 5:12 pm Posts: 662 Location: Puerto Rico Hello which is the most comprehensive option with less trouble DataBase to works with RS Help i am stock with this i need to convert app from RealSQLDataBase to PostgreSQL or MySQL thanks _________________ Thanks for any contribution and God blesses all (I start Using RS in 10/12/2010) Mac Mini with Lion v10.7.5 and Real Studio 2012r1 Pro And Windows 7 RS2012r1 Personal and Linux RS2012r1 Personal Register user my Hobbies R/C Turbines Jets Models Top Thom McGrath Post subject: Re: what is the Best PostgreSQL or MySQLPosted: Tue May 14, 2013 1:07 pm Site Admin Joined: Tue May 06, 2008 1:07 pm Posts: 1458 Location: NotEvenOnTheMap, CT MySQL will probably be easier to transition for SQLite, as it is more forgiving. However for a database engine, more forgiving isn't usually a good thing. PostgreSQL, for all it's frustrations, is very strict. That's a feature, not a weakness. You can trust PostgreSQL to take strict care of the data going into and coming out of your database. For example, let's say you have a column whose type is VARCHAR(10) and you're trying to insert 20 characters into it. Do you know what will happen under each engine? SQLite: All 20 characters will be stored. MySQL: Only the first 10 characters will be stored. PostgreSQL: An error will be triggered. In my opinion of the three, only PostgreSQL does something sane in this case. _________________ Thom McGrath - @tekcor Web Framework Architect, Real Software, Inc. Top taylor-design Post subject: Re: what is the Best PostgreSQL or MySQLPosted: Tue May 14, 2013 1:30 pm Joined: Wed Mar 22, 2006 11:15 am Posts: 686 Location: Southern California Thom McGrath wrote:In my opinion of the three, only PostgreSQL does something sane in this case. One of several reasons why Postgres is my favorite database. _________________ Daniel L. Taylor Custom Controls for Real Studio WE! Visit: http://www.webcustomcontrols.com/ Top simulanics Post subject: Re: what is the Best PostgreSQL or MySQLPosted: Tue May 14, 2013 2:28 pm Joined: Sun Aug 12, 2007 10:10 am Posts: 1075 Location: Boiling Springs, SC jetpr wrote:Hello which is the most comprehensive option with less trouble DataBase to works with RS Help i am stock with this i need to convert app from RealSQLDataBase to PostgreSQL or MySQL thanks Why not settle for cubeSQL if you're already using realsqldatabase?..that way you won't have to modify your application extensively. it's pretty cheap..and for unlimited connections is now $99 (limited time) _________________ Matthew A. Combatti Real Studio 2012 r1.2 Visit Xojo Developer's Spot! Systems I Use: Windows XP/Windows Vista/Windows Server 2008 r2/Windows 7/Windows 8 Mac OSX 10.5/Mac OSX 10.6/Mac OSX Server/Ubuntu/Debian/Suse/Red Hat/ Windows Server 2011/CentOS 5.4 /ReactOS/SimOS ~All Xojo Compatible~ Top Thom McGrath Post subject: Re: what is the Best PostgreSQL or MySQLPosted: Tue May 14, 2013 2:48 pm Site Admin Joined: Tue May 06, 2008 1:07 pm Posts: 1458 Location: NotEvenOnTheMap, CT simulanics wrote:Why not settle for cubeSQL if you're already using realsqldatabase?..that way you won't have to modify your application extensively. it's pretty cheap..and for unlimited connections is now $99 (limited time) While that's a good quick option, SQLite's lack of type checking is a bigger and bigger issue as your database grows. _________________ Thom McGrath - @tekcor Web Framework Architect, Real Software, Inc. Top gisborne Post subject: Re: what is the Best PostgreSQL or MySQLPosted: Tue May 14, 2013 3:50 pm Joined: Tue Feb 06, 2007 11:34 pm Posts: 192 Location: Austin, TX Discussion of why Postgres beats MySQL in every possible way. _________________ Read my book, Real OOP with REALbasic Guyren G Howe Relevant Logic LLC guyren-at-relevantlogic.com ~ http://relevantlogic.com REALbasic, PHP, Ruby/Rails, Python programming PostgreSQL, MySQL database design and consulting Technical writing and training Top jetpr Post subject: Re: what is the Best PostgreSQL or MySQLPosted: Tue May 14, 2013 3:54 pm Joined: Wed Sep 20, 2006 5:12 pm Posts: 662 Location: Puerto Rico thanks to all i start with Postgresql but i have problem is no working the rollback way. i go to test MySql to see is the same. RS 2012v2.1 _________________ Thanks for any contribution and God blesses all (I start Using RS in 10/12/2010) Mac Mini with Lion v10.7.5 and Real Studio 2012r1 Pro And Windows 7 RS2012r1 Personal and Linux RS2012r1 Personal Register user my Hobbies R/C Turbines Jets Models Top Thom McGrath Post subject: Re: what is the Best PostgreSQL or MySQLPosted: Tue May 14, 2013 3:58 pm Site Admin Joined: Tue May 06, 2008 1:07 pm Posts: 1458 Location: NotEvenOnTheMap, CT jetpr wrote:thanks to all i start with Postgresql but i have problem is no working the rollback way. i go to test MySql to see is the same. Rollback definitely works. Post some code, we can help. _________________ Thom McGrath - @tekcor Web Framework Architect, Real Software, Inc. Top jetpr Post subject: Re: what is the Best PostgreSQL or MySQLPosted: Tue May 14, 2013 5:12 pm Joined: Wed Sep 20, 2006 5:12 pm Posts: 662 Location: Puerto Rico in one of this two InsertRecord if a error go on any of the table can be save Dim CajaID As Integer Dim Rd As DatabaseRecord Dim RdGas As DatabaseRecord Dim Rs As RecordSet Dim RsGas As RecordSet Dim CntDate As New Date Dim User01 As String SqlStr=" Select * From CajaReg Where DateOpen='" + ProssesDate + "' And Status='Open'" Rs=DbConn.SQLSelect(SqlStr) if DbConn.Error then MsgBox "Error >> " + DbConn.ErrorMessage Exit end if IF Rs.RecordCount=0 then CajaID=AutoNumChk("CajaReg") ActiveCajaReg=CajaID Rd=New DatabaseRecord Rd.IntegerColumn("CntID")=CajaID Rd.Column("DateOpen")=ProssesDate Rd.DoubleColumn("OpenBalance")=CDbl(TxtAmount.Text) Rd.DoubleColumn("CloseBalance")=0 Rd.DoubleColumn("Balance")=0 Rd.DoubleColumn("Debito")=0 Rd.DoubleColumn("Credito")=0 Rd.Column("StationID")=vStationID Rd.Column("UserID")=TxtId.Text Rd.Column("Status")="Open" Rd.DoubleColumn("CashOut")=0 Rd.IntegerColumn("TurnoNum")=Val(TxtTurno.Text.Trim) vSalePersonID=TxtId.Text.Trim DbConn.InsertRecord("CajaReg",Rd) If DbConn.Error Then MsgBox "Error " + DbConn.ErrorMessage End If RdGas=New DatabaseRecord RdGas.IntegerColumn("GasolinaR")=Val(TxtRegular.Text) RdGas.IntegerColumn("GasolinaP")=Val(TxtPremium.Text) RdGas.IntegerColumn("Dieasel")=Val(TxtDiesel.Text) RdGas.Column("Fecha")=ProssesDate RdGas.Column("Hora")=CntDate.ShortTime RdGas.Column("StationID")=vStationID RdGas.Column("UserId")=TxtId.Text RdGas.Column("Tipo")="G" 'G=Galones L=Litros RdGas.Column("Cuenta")="Venta" 'Venta,Compra RdGas.IntegerColumn("CajaReg")=ActiveCajaReg DbConn.InsertRecord("GasolinaInfo",RdGas) If DbConn.Error Then MsgBox "Error " + DbConn.ErrorMessage End If DbConn.Commit if DbConn.Error Then DbConn.Rollback MsgBox " Error " + DbConn.ErrorMessage end if End if _________________ Thanks for any contribution and God blesses all (I start Using RS in 10/12/2010) Mac Mini with Lion v10.7.5 and Real Studio 2012r1 Pro And Windows 7 RS2012r1 Personal and Linux RS2012r1 Personal Register user my Hobbies R/C Turbines Jets Models Top Thom McGrath Post subject: Re: what is the Best PostgreSQL or MySQLPosted: Tue May 14, 2013 5:15 pm Site Admin Joined: Tue May 06, 2008 1:07 pm Posts: 1458 Location: NotEvenOnTheMap, CT You should explicitly begin a transaction. If you run into an error, do the rollback and exit. Do not even try the commit if any error has happened. _________________ Thom McGrath - @tekcor Web Framework Architect, Real Software, Inc. Top jetpr Post subject: Re: what is the Best PostgreSQL or MySQLPosted: Tue May 14, 2013 6:31 pm Joined: Wed Sep 20, 2006 5:12 pm Posts: 662 Location: Puerto Rico so who i begin a transaction _________________ Thanks for any contribution and God blesses all (I start Using RS in 10/12/2010) Mac Mini with Lion v10.7.5 and Real Studio 2012r1 Pro And Windows 7 RS2012r1 Personal and Linux RS2012r1 Personal Register user my Hobbies R/C Turbines Jets Models Top Thom McGrath Post subject: Re: what is the Best PostgreSQL or MySQLPosted: Tue May 14, 2013 6:56 pm Site Admin Joined: Tue May 06, 2008 1:07 pm Posts: 1458 Location: NotEvenOnTheMap, CT SQLExecute("BEGIN TRANSACTION") _________________ Thom McGrath - @tekcor Web Framework Architect, Real Software, Inc. Top jetpr Post subject: Re: what is the Best PostgreSQL or MySQLPosted: Tue May 14, 2013 8:28 pm Joined: Wed Sep 20, 2006 5:12 pm Posts: 662 Location: Puerto Rico thanks i get it working _________________ Thanks for any contribution and God blesses all (I start Using RS in 10/12/2010) Mac Mini with Lion v10.7.5 and Real Studio 2012r1 Pro And Windows 7 RS2012r1 Personal and Linux RS2012r1 Personal Register user my Hobbies R/C Turbines Jets Models Top jetpr Post subject: Re: what is the Best PostgreSQL or MySQLPosted: Wed May 15, 2013 5:01 pm Joined: Wed Sep 20, 2006 5:12 pm Posts: 662 Location: Puerto Rico i move to MySql can i use this SQLExecute("BEGIN TRANSACTION") on mysql or no _________________ Thanks for any contribution and God blesses all (I start Using RS in 10/12/2010) Mac Mini with Lion v10.7.5 and Real Studio 2012r1 Pro And Windows 7 RS2012r1 Personal and Linux RS2012r1 Personal Register user my Hobbies R/C Turbines Jets Models Top Thom McGrath Post subject: Re: what is the Best PostgreSQL or MySQLPosted: Wed May 15, 2013 5:07 pm Site Admin Joined: Tue May 06, 2008 1:07 pm Posts: 1458 Location: NotEvenOnTheMap, CT Yes, it is standard SQL. _________________ Thom McGrath - @tekcor Web Framework Architect, Real Software, Inc. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 15 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
