Jump to content
Fivewin Brasil

Firebird x MySql


qiinfo

Recommended Posts

Olá Rossine,

Trabalhei com Firebird com Delphi, mais em Fivewin trabalho atualmente com Mysql, com o Firebird tive problema de lentidão que o torna inviável para conecção via web.

O Mysql é rapido via web e agora tem triggers que ajuda muito e é semelhante ao triggers do firebird que estava acostumado.

Esta que é so copiar o arquivo.fdb e o banco ja esta copiado é mentira, se estiver sendo usado o banco vem corrompido, dependendo da versão após um certo tamanho o arquivo corrompe, tem que estar de olho.

Se acessar um terminal com IP e outro com nome do servidor voce corre um sério risco de perder o arquivo, ele se perde e corrompe o arquivo.

Tirando a lentidao e estes probleminas ele é ótimo, voce instala e configura tudo automático com o innosetup.

Com o mysql estou vendo que além de mais rápido local é também via web, e tem muito mais informação o que ajuda muito.

Uso a versão 5.27 do mysql a um ano. e esta legal, só falta conseguir instalar e configurar o mysql de forma automática.

Daniel Segura

ciacpd@terra.com.br

Link to comment
Share on other sites

Rossine,

Eu pessoalmente prefiro o Firebird pela facilidade de instalação e manutenção, mas ambos os bancos de dados são muito bons e gratuitos.

O Firebird é bem menor e fácil de instalar, cria um unico arquivo para cada banco de dados (com as tabelas dentro), o chato dele na versão 1.5.x é que pra criar chaves estrangeiras ele precisa de acesso exclusivo. É fácil de embutir a instalação do FB com nossos programas.

Com relação ao MySQL, não posso falar muito, é muito comum em páginas web, em aplicativos desktop é mais difícil de se ver. Quando eu o testei há uns 2 ou 3 anos ele ainda tinha muitos pontos fracos, como a inexistência de chaves estrangeiras e integridade relacional, além de cada tabela e indice serem arquivos avulsos tao qual os DBF's. Ocupava um espação e não era tão trivial de se instalar, mas - como disse - não o testei atualmente e pelo que sei muitos desses problemas foram resolvidos...

[ ]'s

Maurilio

FWH 7.01 | xHB + SQLRDD | Workshop 4.5 | xDevStudio

Garça - SP

Link to comment
Share on other sites

Olá Daniel e Maurilio,

Obrigado pelas explicações que cada um tem nestes bancos de dados. Realmente eu prefiro automatizar todo processo de criação do banco de dados e importação dos dbf´s. No firebird já faço isto e pelo que vejo no mysql, o banco tem que ser criado dentro dele, pelos menos é o que já me informaram por aí. Por enquanto vou continuar com o firebird.

Obrigado a todos,

Rossine

FW 2.2c + @say + Clipper 5.2e + libs 5.3b / FWH 2.7 + @say + xHarbour Comercial 0.99.??

Divinópolis/ MG

Link to comment
Share on other sites

Srs. segue abaixo o script .iss que uso no innosetup com a versão 5.0.47 NO-INSTALL do MYSQL, tenho meu proprio instalador do MYSQL...chiq no urtimo !!!

Obs:apenas alterar pasta onde se encontra os arquivos do MYSQL

[setup]

MinVersion=4.1.2222,4.0.1381

AppCopyright=Mysql.org

AppName=Mysql 5.0.45

AppVerName=Mysql 5.0.45

UninstallLogMode=new

AppPublisherURL=http://www.mysqll.com/

UninstallDisplayName=Mysql 5.0.45

AppVersion=Mysql 5.0.45

VersionInfoCompany=Mysql 5.0.45

VersionInfoCopyright=Mysql.org

OutputManifestFile=D:\SYGECOM\CD\WindowsXP.Manifest

SetupIconFile=

DefaultDirName=C:\MYSQL

AllowRootDirectory=true

SourceDir=D:\SYGECOM\CD

OutputBaseFilename=Instalador_Mysql_5_0_45

VersionInfoDescription=Mysql 5.0.45

UninstallDisplayIcon=

AppComments=Mysql 5.0.45

DirExistsWarning=yes

VersionInfoTextVersion=Mysql 5.0.45

VersionInfoVersion=5.0.45

ShowLanguageDialog=yes

InternalCompressLevel=max

Encryption=false

WizardImageBackColor=clBlue

PrivilegesRequired=admin

DisableStartupPrompt=false

OutputDir=D:\SYGECOM\CD

ShowUndisplayableLanguages=true

ExtraDiskSpaceRequired=100

DisableDirPage=false

UsePreviousGroup=false

AppendDefaultGroupName=false

UsePreviousAppDir=true

AllowUNCPath=false

AppendDefaultDirName=false

UsePreviousTasks=false

[Languages]

Name: pt; MessagesFile: compiler:Languages\BrazilianPortuguese.isl

Name: en; MessagesFile: compiler:Default.isl

Name: sp; MessagesFile: compiler:Languages\Spanish.isl

[Messages]

pt.BeveledLabel=Português(Brasil)

en.BeveledLabel=English

sp.BeveledLabel=Spanish

[Run]

Filename: {app}\inicia.bat; WorkingDir: {app}; Flags: waituntilidle postinstall runminimized; Description: Inicio do Serviço do Mysql; StatusMsg: Aguarde em até que o Serviço seja iniciado...

[Dirs]

Name: {app}\bin

Name: {app}\data

Name: {app}\scripts

Name: {app}\share

Name: {app}\data\mysql

Name: {app}\data\sygecom

Name: {app}\data\test

Name: {app}\share\charsets

Name: {app}\share\czech

Name: {app}\share\danish

Name: {app}\share\dutch

Name: {app}\share\english

Name: {app}\share\estonian

Name: {app}\share\french

Name: {app}\share\german

Name: {app}\share\greek

Name: {app}\share\hungarian

Name: {app}\share\italian

Name: {app}\share\japanese

Name: {app}\share\japanese-sjis

Name: {app}\share\korean

Name: {app}\share\norwegian

Name: {app}\share\norwegian-ny

Name: {app}\share\polish

Name: {app}\share\portuguese

Name: {app}\share\romanian

Name: {app}\share\russian

Name: {app}\share\serbian

Name: {app}\share\slovak

Name: {app}\share\spanish

Name: {app}\share\swedish

Name: {app}\share\ukrainian

[Files]

Source: mysql\bin\mysql.exe; DestDir: {app}\bin

Source: mysql\bin\mysqladmin.exe; DestDir: {app}\bin

Source: mysql\bin\mysqld.exe; DestDir: {app}\bin

Source: mysql\bin\mysqld-nt.exe; DestDir: {app}\bin

Source: mysql\bin\mysqldump.exe; DestDir: {app}\bin

Source: mysql\data\mysql\columns_priv.frm; DestDir: {app}\data\mysql

Source: mysql\data\mysql\columns_priv.MYD; DestDir: {app}\data\mysql

Source: mysql\data\mysql\columns_priv.MYI; DestDir: {app}\data\mysql

Source: mysql\data\mysql\db.frm; DestDir: {app}\data\mysql

Source: mysql\data\mysql\db.MYD; DestDir: {app}\data\mysql

Source: mysql\data\mysql\db.MYI; DestDir: {app}\data\mysql

Source: mysql\data\mysql\func.frm; DestDir: {app}\data\mysql

Source: mysql\data\mysql\func.MYD; DestDir: {app}\data\mysql

Source: mysql\data\mysql\func.MYI; DestDir: {app}\data\mysql

Source: mysql\data\mysql\help_category.frm; DestDir: {app}\data\mysql

Source: mysql\data\mysql\help_category.MYD; DestDir: {app}\data\mysql

Source: mysql\data\mysql\help_category.MYI; DestDir: {app}\data\mysql

Source: mysql\data\mysql\help_keyword.frm; DestDir: {app}\data\mysql

Source: mysql\data\mysql\help_keyword.MYD; DestDir: {app}\data\mysql

Source: mysql\data\mysql\help_keyword.MYI; DestDir: {app}\data\mysql

Source: mysql\data\mysql\help_relation.frm; DestDir: {app}\data\mysql

Source: mysql\data\mysql\help_relation.MYD; DestDir: {app}\data\mysql

Source: mysql\data\mysql\help_relation.MYI; DestDir: {app}\data\mysql

Source: mysql\data\mysql\help_topic.frm; DestDir: {app}\data\mysql

Source: mysql\data\mysql\help_topic.MYD; DestDir: {app}\data\mysql

Source: mysql\data\mysql\help_topic.MYI; DestDir: {app}\data\mysql

Source: mysql\data\mysql\host.frm; DestDir: {app}\data\mysql

Source: mysql\data\mysql\host.MYD; DestDir: {app}\data\mysql

Source: mysql\data\mysql\host.MYI; DestDir: {app}\data\mysql

Source: mysql\data\mysql\proc.frm; DestDir: {app}\data\mysql

Source: mysql\data\mysql\proc.MYD; DestDir: {app}\data\mysql

Source: mysql\data\mysql\proc.MYI; DestDir: {app}\data\mysql

Source: mysql\data\mysql\procs_priv.frm; DestDir: {app}\data\mysql

Source: mysql\data\mysql\procs_priv.MYD; DestDir: {app}\data\mysql

Source: mysql\data\mysql\procs_priv.MYI; DestDir: {app}\data\mysql

Source: mysql\data\mysql\tables_priv.frm; DestDir: {app}\data\mysql

Source: mysql\data\mysql\tables_priv.MYD; DestDir: {app}\data\mysql

Source: mysql\data\mysql\tables_priv.MYI; DestDir: {app}\data\mysql

Source: mysql\data\mysql\time_zone.frm; DestDir: {app}\data\mysql

Source: mysql\data\mysql\time_zone.MYD; DestDir: {app}\data\mysql

Source: mysql\data\mysql\time_zone.MYI; DestDir: {app}\data\mysql

Source: mysql\data\mysql\time_zone_leap_second.frm; DestDir: {app}\data\mysql

Source: mysql\data\mysql\time_zone_leap_second.MYD; DestDir: {app}\data\mysql

Source: mysql\data\mysql\time_zone_leap_second.MYI; DestDir: {app}\data\mysql

Source: mysql\data\mysql\time_zone_name.frm; DestDir: {app}\data\mysql

Source: mysql\data\mysql\time_zone_name.MYD; DestDir: {app}\data\mysql

Source: mysql\data\mysql\time_zone_name.MYI; DestDir: {app}\data\mysql

Source: mysql\data\mysql\time_zone_transition.frm; DestDir: {app}\data\mysql

Source: mysql\data\mysql\time_zone_transition.MYD; DestDir: {app}\data\mysql

Source: mysql\data\mysql\time_zone_transition.MYI; DestDir: {app}\data\mysql

Source: mysql\data\mysql\time_zone_transition_type.frm; DestDir: {app}\data\mysql

Source: mysql\data\mysql\time_zone_transition_type.MYD; DestDir: {app}\data\mysql

Source: mysql\data\mysql\time_zone_transition_type.MYI; DestDir: {app}\data\mysql

Source: mysql\data\mysql\user.frm; DestDir: {app}\data\mysql

Source: mysql\data\mysql\user.MYD; DestDir: {app}\data\mysql

Source: mysql\data\mysql\user.MYI; DestDir: {app}\data\mysql

Source: mysql\data\ib_logfile0; DestDir: {app}\data

Source: mysql\data\ib_logfile1; DestDir: {app}\data

Source: mysql\data\ibdata1; DestDir: {app}\data

Source: mysql\data\NOTE.err; DestDir: {app}\data

Source: mysql\data\servidor.pid; DestDir: {app}\data

Source: mysql\scripts\cmake_install.cmake; DestDir: {app}\scripts

Source: mysql\scripts\CMakeLists.txt; DestDir: {app}\scripts

Source: mysql\scripts\comp_sql.c; DestDir: {app}\scripts

Source: mysql\scripts\comp_sql.vcproj; DestDir: {app}\scripts

Source: mysql\scripts\comp_sql.vcproj.cmake; DestDir: {app}\scripts

Source: mysql\scripts\GenFixPrivs.vcproj; DestDir: {app}\scripts

Source: mysql\scripts\GenFixPrivs.vcproj.cmake; DestDir: {app}\scripts

Source: mysql\scripts\INSTALL.vcproj; DestDir: {app}\scripts

Source: mysql\scripts\INSTALL.vcproj.cmake; DestDir: {app}\scripts

Source: mysql\scripts\make_binary_distribution; DestDir: {app}\scripts

Source: mysql\scripts\make_sharedlib_distribution; DestDir: {app}\scripts

Source: mysql\scripts\make_win_bin_dist; DestDir: {app}\scripts

Source: mysql\scripts\make_win_src_distribution; DestDir: {app}\scripts

Source: mysql\scripts\msql2mysql; DestDir: {app}\scripts

Source: mysql\scripts\mysql_config; DestDir: {app}\scripts

Source: mysql\scripts\mysql_convert_table_format; DestDir: {app}\scripts

Source: mysql\scripts\mysql_explain_log; DestDir: {app}\scripts

Source: mysql\scripts\mysql_find_rows; DestDir: {app}\scripts

Source: mysql\scripts\mysql_fix_extensions; DestDir: {app}\scripts

Source: mysql\scripts\mysql_fix_privilege_tables; DestDir: {app}\scripts

Source: mysql\scripts\mysql_fix_privilege_tables_sql.c; DestDir: {app}\scripts

Source: mysql\scripts\mysql_install_db; DestDir: {app}\scripts

Source: mysql\scripts\mysql_secure_installation; DestDir: {app}\scripts

Source: mysql\scripts\mysql_setpermission; DestDir: {app}\scripts

Source: mysql\scripts\mysql_tableinfo; DestDir: {app}\scripts

Source: mysql\scripts\mysql_upgrade_shell; DestDir: {app}\scripts

Source: mysql\scripts\mysql_zap; DestDir: {app}\scripts

Source: mysql\scripts\mysqlaccess; DestDir: {app}\scripts

Source: mysql\scripts\mysqlaccess.conf; DestDir: {app}\scripts

Source: mysql\scripts\mysqlbug; DestDir: {app}\scripts

Source: mysql\scripts\mysqld_multi; DestDir: {app}\scripts

Source: mysql\scripts\mysqld_safe; DestDir: {app}\scripts

Source: mysql\scripts\mysqldumpslow; DestDir: {app}\scripts

Source: mysql\scripts\mysqlhotcopy; DestDir: {app}\scripts

Source: mysql\share\charsets\armscii8.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\ascii.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\cp850.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\cp852.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\cp866.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\cp1250.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\cp1251.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\cp1256.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\cp1257.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\dec8.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\geostd8.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\greek.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\hebrew.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\hp8.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\Index.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\keybcs2.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\koi8r.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\koi8u.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\languages.html; DestDir: {app}\share\charsets

Source: mysql\share\charsets\latin1.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\latin2.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\latin5.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\latin7.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\macce.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\macroman.xml; DestDir: {app}\share\charsets

Source: mysql\share\charsets\README; DestDir: {app}\share\charsets

Source: mysql\share\charsets\swe7.xml; DestDir: {app}\share\charsets

Source: mysql\share\czech\errmsg.sys; DestDir: {app}\share\czech

Source: mysql\share\danish\errmsg.sys; DestDir: {app}\share\danish

Source: mysql\share\dutch\errmsg.sys; DestDir: {app}\share\dutch

Source: mysql\share\english\errmsg.sys; DestDir: {app}\share\english

Source: mysql\share\estonian\errmsg.sys; DestDir: {app}\share\estonian

Source: mysql\share\french\errmsg.sys; DestDir: {app}\share\french

Source: mysql\share\german\errmsg.sys; DestDir: {app}\share\german

Source: mysql\share\greek\errmsg.sys; DestDir: {app}\share\greek

Source: mysql\share\hungarian\errmsg.sys; DestDir: {app}\share\hungarian

Source: mysql\share\italian\errmsg.sys; DestDir: {app}\share\italian

Source: mysql\share\japanese\errmsg.sys; DestDir: {app}\share\japanese

Source: mysql\share\japanese-sjis\errmsg.sys; DestDir: {app}\share\japanese-sjis

Source: mysql\share\korean\errmsg.sys; DestDir: {app}\share\korean

Source: mysql\share\norwegian\errmsg.sys; DestDir: {app}\share\norwegian

Source: mysql\share\norwegian-ny\errmsg.sys; DestDir: {app}\share\norwegian-ny

Source: mysql\share\polish\errmsg.sys; DestDir: {app}\share\polish

Source: mysql\share\portuguese\errmsg.sys; DestDir: {app}\share\portuguese

Source: mysql\share\romanian\errmsg.sys; DestDir: {app}\share\romanian

Source: mysql\share\russian\errmsg.sys; DestDir: {app}\share\russian

Source: mysql\share\serbian\errmsg.sys; DestDir: {app}\share\serbian

Source: mysql\share\slovak\errmsg.sys; DestDir: {app}\share\slovak

Source: mysql\share\spanish\errmsg.sys; DestDir: {app}\share\spanish

Source: mysql\share\swedish\errmsg.sys; DestDir: {app}\share\swedish

Source: mysql\share\ukrainian\errmsg.sys; DestDir: {app}\share\ukrainian

Source: mysql\share\mysql_test_data_timezone.sql; DestDir: {app}\share

Source: mysql\share\errmsg.txt; DestDir: {app}\share

Source: mysql\share\fill_help_tables.sql; DestDir: {app}\share

Source: mysql\share\Makefile.am; DestDir: {app}\share

Source: mysql\share\Makefile.in; DestDir: {app}\share

Source: mysql\share\mysql_fix_privilege_tables.sql; DestDir: {app}\share

Source: mysql\share\mysql_system_tables.sql; DestDir: {app}\share

Source: mysql\share\mysql_system_tables_data.sql; DestDir: {app}\share

Source: mysql\share\mysql_system_tables_fix.sql; DestDir: {app}\share

Source: mysql\mysql_error.log; DestDir: {app}

Source: mysql\COPYING; DestDir: {app}

Source: mysql\EXCEPTIONS-CLIENT; DestDir: {app}

Source: mysql\inicia.bat; DestDir: {app}

Source: mysql\my-huge.ini; DestDir: {app}

Source: mysql\my-innodb-heavy-4G.ini; DestDir: {app}

Source: mysql\my-large.ini; DestDir: {app}

Source: mysql\my-medium.ini; DestDir: {app}

Source: mysql\my-small.ini; DestDir: {app}

Source: mysql\mysql.bmp; DestDir: {app}

Source: mysql\fim.bat; DestDir: {app}

[iNI]

Filename: {app}\my.ini; Section: client; Key: port; String: 3306

Filename: {app}\my.ini; Section: mysqld; Key: port; String: 3306

Filename: {app}\my.ini; Section: mysqld; Key: basedir; String: {app}; Languages:

Filename: {app}\my.ini; Section: mysqld; Key: log-error; String: {app}\mysql_error.log

Filename: {app}\my.ini; Section: mysqld; Key: datadir; String: {app}\data

Filename: {app}\my.ini; Section: mysqld; Key: default-character-set; String: latin1

Filename: {app}\my.ini; Section: mysqld; Key: max_connections; String: 255

Filename: {app}\my.ini; Section: mysqld; Key: query_cache_size; String: 8M

Filename: {app}\my.ini; Section: mysqld; Key: table_cache; String: 510

Filename: {app}\my.ini; Section: mysqld; Key: tmp_table_size; String: 13M

Filename: {app}\my.ini; Section: mysqld; Key: thread_cache_size; String: 12

Filename: {app}\my.ini; Section: mysqld; Key: myisam_max_sort_file_size; String: 100G

Filename: {app}\my.ini; Section: mysqld; Key: myisam_max_extra_sort_file_size; String: 100G

Filename: {app}\my.ini; Section: mysqld; Key: myisam_sort_buffer_size; String: 8M

Filename: {app}\my.ini; Section: mysqld; Key: key_buffer_size; String: 9M

Filename: {app}\my.ini; Section: mysqld; Key: read_buffer_size; String: 64K

Filename: {app}\my.ini; Section: mysqld; Key: read_rnd_buffer_size; String: 256K

Filename: {app}\my.ini; Section: mysqld; Key: sort_buffer_size; String: 203K

Filename: {app}\my.ini; Section: mysqld; Key: innodb_additional_mem_pool_size; String: 2M

Filename: {app}\my.ini; Section: mysqld; Key: innodb_flush_log_at_trx_commit; String: 1

Filename: {app}\my.ini; Section: mysqld; Key: innodb_log_buffer_size; String: 1M

Filename: {app}\my.ini; Section: mysqld; Key: innodb_buffer_pool_size; String: 15M

Filename: {app}\my.ini; Section: mysqld; Key: innodb_log_file_size; String: 10M

Filename: {app}\my.ini; Section: mysqld; Key: innodb_thread_concurrency; String: 8

[uninstallRun]

Filename: {app}\fim.bat; WorkingDir: {app}; Flags: runminimized

[uninstallDelete]

Name: {app}\my.ini; Type: files

// fim do script

Leonardo Machado

Porto Alegre-RS

Hwgui + Mysql / xHarbour 0.99.70 / BCC55 / Vrmm / xDev /Migrando aos Pouco para Fivewin 2.7 + PostgreSql

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...