Re: [Firebird-devel] Windows installer and ICU files
On Sat, Aug 14, 2021 at 11:14 AM Vlad Khorsun wrote: > 14.08.2021 15:54, Carlos H. Cantu wrote: > > Hi! > > > > I see Firebird 4.0 Windows Installer does not copy the ICU dlls when > > doing a client+tools or minimum client install. Speaking with Adriano, > > it seems that having tzdata files are not enough to assure that all > > time zones conversions will be handled correctly. For that, ICU dlls > > are needed too. > >IIRC, ICU needed to fbclient only to correctly display tz names. > I.e. not for conversions or something really important. If client > app requires ICU for own needs, it is not our deal. > > > So, I think installer should install them during client installs. > > > > Comments? > >Only by explicit user request, off by default. > > Firebird Windows installer is described as "Windows executable installer, recommended for first-time users". When only client/ and/or tools are installed, time zones usage experience is not fully correct. Compression also does not work. That's really bad for Firebird. It also does not make sense to install tzdata/*.res and does not install the library who reads them. It's certainly a bug, and that's ok. Bugs should be fixed. Both ICU and zlib must be installed. I'm fine that things could be configurable and anyone who wants to test their software with things stripped may have a working solution. But definitively that is not how things should work for first-time users. Also, a shared installed client is there to be used by multiple applications, so it should install something that works for all applications. Even for unknown applications not yet stalled that will be installed in the future. It's bad that first-time users will run away because Firebird developers want (for what?) to strip a few megabytes, and it's funny that happening in an OS well known to be one of the most bloated. Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] File and table sizes in Firebird 4.0
I think it's a good idea to keep not only limits but the formulas for their calculations. сб, 14 авг. 2021 г. в 10:32, Mark Rotteveel : > > On 14-08-2021 09:12, Dmitry Yemanov wrote: > > 14.08.2021 10:02, Mark Rotteveel пишет: > >> > >>> Now I see you mentioned 32 TB as the database size limit. How was it > >>> calculated? It should be the same 128 TB, AFAIK. > >> > >> The 32 TB is the old value on the page, when the entire page was for > >> Firebird 2.5. I have no idea who wrote the previous version of that > >> page or if that value was correct for Firebird 2.5. > > > > It was correct: 2^31 (page number was signed) * 16 KB = 32 TB. > > > > For FB 3.0 it should be: 2^32 * 16 KB = 64 TB. > > Ok, I have made what I think are the final updates to the page: > https://firebirdsql.org/en/firebird-technical-specifications/ > > Mark > > -- > Mark Rotteveel > > > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Roman Simakov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Windows installer and ICU files
14.08.2021 15:54, Carlos H. Cantu wrote: Hi! I see Firebird 4.0 Windows Installer does not copy the ICU dlls when doing a client+tools or minimum client install. Speaking with Adriano, it seems that having tzdata files are not enough to assure that all time zones conversions will be handled correctly. For that, ICU dlls are needed too. IIRC, ICU needed to fbclient only to correctly display tz names. I.e. not for conversions or something really important. If client app requires ICU for own needs, it is not our deal. So, I think installer should install them during client installs. Comments? Only by explicit user request, off by default. Regards, Vlad Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Windows installer and ICU files
Hi! I see Firebird 4.0 Windows Installer does not copy the ICU dlls when doing a client+tools or minimum client install. Speaking with Adriano, it seems that having tzdata files are not enough to assure that all time zones conversions will be handled correctly. For that, ICU dlls are needed too. So, I think installer should install them during client installs. Comments? []s Carlos http://www.firebirdnews.org FireBase - http://www.FireBase.com.br Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] File and table sizes in Firebird 4.0
On 14-08-2021 09:12, Dmitry Yemanov wrote: 14.08.2021 10:02, Mark Rotteveel пишет: Now I see you mentioned 32 TB as the database size limit. How was it calculated? It should be the same 128 TB, AFAIK. The 32 TB is the old value on the page, when the entire page was for Firebird 2.5. I have no idea who wrote the previous version of that page or if that value was correct for Firebird 2.5. It was correct: 2^31 (page number was signed) * 16 KB = 32 TB. For FB 3.0 it should be: 2^32 * 16 KB = 64 TB. Ok, I have made what I think are the final updates to the page: https://firebirdsql.org/en/firebird-technical-specifications/ Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] File and table sizes in Firebird 4.0
14.08.2021 10:02, Mark Rotteveel пишет: Now I see you mentioned 32 TB as the database size limit. How was it calculated? It should be the same 128 TB, AFAIK. The 32 TB is the old value on the page, when the entire page was for Firebird 2.5. I have no idea who wrote the previous version of that page or if that value was correct for Firebird 2.5. It was correct: 2^31 (page number was signed) * 16 KB = 32 TB. For FB 3.0 it should be: 2^32 * 16 KB = 64 TB. Dmitry Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] File and table sizes in Firebird 4.0
On 14-08-2021 08:49, Dmitry Yemanov wrote: 13.08.2021 10:04, Mark Rotteveel wrote: I'd still like an answer to the following questions (assume page size 32KB for all): - What is the maximum file size of a Firebird 4 database Theoretically unlimited (depends on OS and filesystem). Practically, it cannot be bigger than 128 TB (2^32 pages * 32KB). Now I see you mentioned 32 TB as the database size limit. How was it calculated? It should be the same 128 TB, AFAIK. The 32 TB is the old value on the page, when the entire page was for Firebird 2.5. I have no idea who wrote the previous version of that page or if that value was correct for Firebird 2.5. - What is the maximum size of a single table? It wasn't changed, so should be ~18 TB (my quick calculation shows 22 TB actually, but it could be a mistake of mine). - What are the maximum number of rows per table? Still the same (2^40). Max blob size for 32 KB page should be around 512 GB, IIRC. Thanks -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] File and table sizes in Firebird 4.0
13.08.2021 10:04, Mark Rotteveel wrote: I'd still like an answer to the following questions (assume page size 32KB for all): - What is the maximum file size of a Firebird 4 database Theoretically unlimited (depends on OS and filesystem). Practically, it cannot be bigger than 128 TB (2^32 pages * 32KB). Now I see you mentioned 32 TB as the database size limit. How was it calculated? It should be the same 128 TB, AFAIK. - What is the maximum size of a single table? It wasn't changed, so should be ~18 TB (my quick calculation shows 22 TB actually, but it could be a mistake of mine). - What are the maximum number of rows per table? Still the same (2^40). Max blob size for 32 KB page should be around 512 GB, IIRC. Dmitry Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel