So, where's your data stored today?
__ DBFs
__ MS SQL Server
__ Azure
__ Postgres
__ My/MariaDB
__ Oracle
__ Excel
__ Other (please specify)
(P.S. Microsoft released an out-of-band (i.e., emergency) patch for Adobe Flash. You likely want to patch NOW. After answering the poll, of course.)
DBFs
MSSQL
Azure (for testing and playing around)
Excel (although I don't use it like a database, due to not being insane)
__ Other (please specify)
XML files for fitting data that NEVER changes. USA States and Countries are never changing data in my mind and something that is faster to pull off the website file instead of hitting the sql backend for it. I have plenty of others as well that fit our business/industry. Package type Plastic Type Customer type Carrier Type just as a short list.
On Fri, Oct 28, 2016 at 8:00 AM, Ted Roche tedroche@gmail.com wrote:
So, where's your data stored today?
__ DBFs
__ MS SQL Server
__ Azure
__ Postgres
__ My/MariaDB
__ Oracle
__ Excel
__ Other (please specify)
(P.S. Microsoft released an out-of-band (i.e., emergency) patch for Adobe Flash. You likely want to patch NOW. After answering the poll, of course.)
-- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com
[excessive quoting removed by server]
dbf
--- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
M$SQL 2012 VFP Databases SQLite
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Ted Roche Sent: 28 October 2016 14:01 To: profox@leafe.com Subject: Friday Poll (while dl'ing MS Flash Patch)
So, where's your data stored today?
__ DBFs
__ MS SQL Server
__ Azure
__ Postgres
__ My/MariaDB
__ Oracle
__ Excel
__ Other (please specify)
(P.S. Microsoft released an out-of-band (i.e., emergency) patch for Adobe Flash. You likely want to patch NOW. After answering the poll, of course.)
-- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com
[excessive quoting removed by server]
On Fri, Oct 28, 2016 at 9:54 AM, Dave Crozier DaveC@flexipol.co.uk wrote:
M$SQL 2012 VFP Databases SQLite
Dave
I don't see SQLite mentioned much. I've worked with it in a couple of situations (including a book by Whil Hentzen I edited) but haven't used it in a production system.
Ted, We use it to interface onto the Android tablets as it is obviously Android Native.
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Ted Roche Sent: 28 October 2016 16:20 To: profox@leafe.com Subject: Re: Friday Poll (while dl'ing MS Flash Patch)
On Fri, Oct 28, 2016 at 9:54 AM, Dave Crozier DaveC@flexipol.co.uk wrote:
M$SQL 2012 VFP Databases SQLite
Dave
I don't see SQLite mentioned much. I've worked with it in a couple of situations (including a book by Whil Hentzen I edited) but haven't used it in a production system.
[excessive quoting removed by server]
On Fri, 28 Oct 2016, at 04:20 PM, Ted Roche wrote:
I don't see SQLite mentioned much.
Single user and insecure so that kind of limits real-world usage to phone applications and similar local storage use cases, as far as I can see. You wouldn't be putting a big production database on it.
I don't see SQLite mentioned much.
Single user and insecure so that kind of limits real-world usage to
phone applications and similar local storage use cases, as far as I can see. You wouldn't be putting a big production database on it.
The following from the SQLite email list. Sent from the CEO of Expensify.
<snipped> Love SQLite? Wish you could use it to power your enterprise SaaS or web service? Now you can! Check out Expensify Bedrock, our distributed transaction layer built atop SQLite, powering Expensify's millions of users. More information is here:
Keep all the power and simplicity of SQLite, but wrapped in a package that provides network accessibility, WAN-optimized replication, and distributed ACID transactions. Under continuous development and operation for the past 8 years, now it's open sourced and ready for your production use.
Thank you to the SQLite team for not only producing such an incredible database, but helping with our countless questions and demanding requirements. I'm ecstatic to share this with you, and I hope you enjoy it too! </snipped>
Malcolm
DBFs - I'm old fashioned (and I don't have much data anymore)
John Weller 07976 393631 01380 723235 Sent from my iPhone
On 28 Oct 2016, at 14:00, Ted Roche tedroche@gmail.com wrote:
So, where's your data stored today?
__ DBFs
__ MS SQL Server
__ Azure
__ Postgres
__ My/MariaDB
__ Oracle
__ Excel
__ Other (please specify)
(P.S. Microsoft released an out-of-band (i.e., emergency) patch for Adobe Flash. You likely want to patch NOW. After answering the poll, of course.)
-- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com
[excessive quoting removed by server]
DBFs
MS Sql Server
Ajit Abraham
On 28-Oct-16 4:00 PM, Ted Roche wrote:
So, where's your data stored today?
__ DBFs
__ MS SQL Server
__ Azure
__ Postgres
__ My/MariaDB
__ Oracle
__ Excel
__ Other (please specify)
(P.S. Microsoft released an out-of-band (i.e., emergency) patch for Adobe Flash. You likely want to patch NOW. After answering the poll, of course.)
--- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
X PostgreSQL - CULLYTechs system runs on PostgreSQL for years now without a hiccup. Big fan.
X DBFs - I have a client that insisted I use DBFs for his desktop and Web-Connection site. It's run almost flawlessly since 2008 with the exception of the 'memo field bloat' issue. That's caught me a couple of times over the years hitting the 2G limit per file.
X MS SQL Server - For my day job with the County Govt, they are a Microsoft shop. Unfortunately. MSSQL is pretty good and stable, I must admit.
X JSON - When I save settings and other small infrequently saved items, I've been saving them as individual JSON files per user. Xojo makes it easy to load and save them and access them like a dictionary.
Side note: every time I visit a news site in Firefox and the Flash place-holder shows up where the flash media normally would have played, I smile a bit inside I wasn't subjected to the auto-play media.
-Kevin
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Ted Roche Sent: Friday, October 28, 2016 9:01 AM To: profox@leafe.com Subject: Friday Poll (while dl'ing MS Flash Patch)
So, where's your data stored today?
__ DBFs
__ MS SQL Server
__ Azure
__ Postgres
__ My/MariaDB
__ Oracle
__ Excel
__ Other (please specify)
(P.S. Microsoft released an out-of-band (i.e., emergency) patch for Adobe Flash. You likely want to patch NOW. After answering the poll, of course.)
-- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com
[excessive quoting removed by server]
In DBFs for work data and fixed reference values, and Oracle 11 for consolidated data.
Fernando D. Bozzo
2016-10-28 16:24 GMT+02:00 Kevin J Cully kjcully@cherokeega.com:
X PostgreSQL - CULLYTechs system runs on PostgreSQL for years now without a hiccup. Big fan.
X DBFs - I have a client that insisted I use DBFs for his desktop and Web-Connection site. It's run almost flawlessly since 2008 with the exception of the 'memo field bloat' issue. That's caught me a couple of times over the years hitting the 2G limit per file.
X MS SQL Server - For my day job with the County Govt, they are a Microsoft shop. Unfortunately. MSSQL is pretty good and stable, I must admit.
X JSON - When I save settings and other small infrequently saved items, I've been saving them as individual JSON files per user. Xojo makes it easy to load and save them and access them like a dictionary.
Side note: every time I visit a news site in Firefox and the Flash place-holder shows up where the flash media normally would have played, I smile a bit inside I wasn't subjected to the auto-play media.
-Kevin
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Ted Roche Sent: Friday, October 28, 2016 9:01 AM To: profox@leafe.com Subject: Friday Poll (while dl'ing MS Flash Patch)
So, where's your data stored today?
__ DBFs
__ MS SQL Server
__ Azure
__ Postgres
__ My/MariaDB
__ Oracle
__ Excel
__ Other (please specify)
(P.S. Microsoft released an out-of-band (i.e., emergency) patch for Adobe Flash. You likely want to patch NOW. After answering the poll, of course.)
-- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com
[excessive quoting removed by server]
On 2016-10-28 10:24, Kevin J Cully wrote:
X DBFs - I have a client that insisted I use DBFs for his desktop and Web-Connection site. It's run almost flawlessly since 2008 with the exception of the 'memo field bloat' issue. That's caught me a couple of times over the years hitting the 2G limit per file.
I'm handling one of Jeff Johnson's (RIP) clients and having this issue. I was about to create a simple utility for the end-user to grab the table and pack it, but curious if you've got a better idea?
tia, --Mike
On 10/28/2016 06:00 AM, Ted Roche wrote:
So, where's your data stored today?
X_ DBFs
__ MS SQL Server
__ Azure
__ Postgres
__ My/MariaDB
__ Oracle
__ Excel
__ Other (please specify)
(P.S. Microsoft released an out-of-band (i.e., emergency) patch for Adobe Flash. You likely want to patch NOW. After answering the poll, of course.)
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
On 28/10/2016 14:00, Ted Roche wrote:
So, where's your data stored today?
__ DBFs
Yup - sooner or later we will look to move to SQL but we don't want to rush into things
Peter
This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715
London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
Rush??? I suspect, however, you meant that kind of 'tongue in cheek'.
Regards, Kurt Wendt Senior Systems Analyst
Tel. +1-212-747-9100 www.GlobeTax.com
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Peter Cushing Sent: Friday, October 28, 2016 11:00 AM To: profoxtech@leafe.com Subject: Re: Friday Poll (while dl'ing MS Flash Patch)
On 28/10/2016 14:00, Ted Roche wrote:
So, where's your data stored today?
__ DBFs
Yup - sooner or later we will look to move to SQL but we don't want to rush into things
Peter
This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715
London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
[excessive quoting removed by server]
__ DBFs 80% clients
__ MS SQL Server 20% clients
Jose Enrique Llopis www.multilinkcrm.com
-----Mensaje original----- De: ProFox [mailto:profox-bounces@leafe.com] En nombre de Ted Roche Enviado el: viernes, 28 de octubre de 2016 15:01 Para: profox@leafe.com Asunto: Friday Poll (while dl'ing MS Flash Patch)
So, where's your data stored today?
__ DBFs
__ MS SQL Server
__ Azure
__ Postgres
__ My/MariaDB
__ Oracle
__ Excel
__ Other (please specify)
(P.S. Microsoft released an out-of-band (i.e., emergency) patch for Adobe Flash. You likely want to patch NOW. After answering the poll, of course.)
X_ MS SQL Server
In fact - I just completed a 4-day class last week at the Learning Tree on M$ SQL. It was kinda Nuts - as they jammed TOO Much into a 4-day class - would have been better to be 5 or 6 days! And, some of you may find it peculiar - since I've been working this job for 1.5 years now and working w/M$ SQL on the job ever since starting here. That being said - I did learn a LOT of new things in the class - so it was indeed worthwhile.
Regards, Kurt Wendt Senior Systems Analyst
Tel. +1-212-747-9100 www.GlobeTax.com
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Ted Roche Sent: Friday, October 28, 2016 9:01 AM To: profoxtech@leafe.com Subject: Friday Poll (while dl'ing MS Flash Patch)
So, where's your data stored today?
__ DBFs
__ MS SQL Server
__ Azure
__ Postgres
__ My/MariaDB
__ Oracle
__ Excel
__ Other (please specify)
(P.S. Microsoft released an out-of-band (i.e., emergency) patch for Adobe Flash. You likely want to patch NOW. After answering the poll, of course.)
-- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com
[excessive quoting removed by server]
On 2016-10-28 09:00, Ted Roche wrote:
So, where's your data stored today?
__ DBFs
__ MS SQL Server
__ Azure
__ Postgres
__ My/MariaDB
__ Oracle
__ Excel
__ Other (please specify)
My backend data of choice for MBSS has been MySQL, and then MariaDB since it forked off from MySQL. Corporate gig loves SQL Server, and I crafted a slick DBF app too.
-
Ajit Abraham -
Alan Bourke -
Carl Lindner -
Dave Crozier -
Fernando D. Bozzo -
John R. Sowden -
John Weller -
José Enrique Llopis -
Kevin J Cully -
Kurt Wendt -
Malcolm Greene -
mbsoftwaresolutions＠mbsoftwaresolutions.com -
Peter Cushing -
Stephen Russell -
Ted Roche -
Vince Teachout