Loading...
Answers
MenuNeed easy cloud based SQL service for non-SQL user.
I want to download a set of data into excel, about 50,000 records, which can only be downloaded using SQL. What cloud based, or other service could I use? I need bi-monthly updates and need the data converted to Excel.
Answers
PhpMyAdmin would probably work for this.
http://www.phpmyadmin.net/home_page/index.php
Lots of hosts have it pre-installed.
Excel can import CSV files, and most databases can dump data as CSV. You could potentially use something like Sequel Pro locally to do this.
Honestly, without knowing the WHY behind the need, it's tough to say what the right solution is.
Really, manually syncing an Excel document back and forth with a database seems like a complex and fragile solution to a problem. Is it possible you could remove the Excel sheet from the equation? Or use Google Sheets to make it available collaboratively online?
Depending on the problem you're trying to solve, there's probably a much easier solution that a SQL import/export.
I'd be happy to go over solutions and help you find a simpler way to solve this problem if you'd like. Just tag me for a quick call.
Good luck!
Lot of missing info in this question.
Like, how data will be accessed (frequency).
This will determine your SQL storage engine type + table structure.
You can also adjust your table structure to protect against duplicate entries.
This is important, if it takes a long time to load your data. If you setup your structure to only allow unique data, then you can just upload your new data, without having to "drop" (destroy) your old data.
This can potentially speed up your data loads considerably, especially if you're using cheap/slow hosting for your database.
Likely good to give equal consideration to how data is used first + data loading.
Related Questions
-
What type of people are hiring companies to build mobile/web/cloud applications? Which of them have a good budget?
There's 2 types of customers for this segment that have a decent budget. 1) Funded tech startups (i.e. Anyone that recently closed a round on www.angel.co) 2) Digital agencies (or their clients) who want to build a mobile app for marketing or convenience purposes. So for #1, you can target anyone who likes sites like Angel List, Gust, etc. For #2, you can get a list of digital media agencies and run ads against them. All that being said, the best way to pull them into your funnel is to create some AMAZING free content like an infographic, video or webinar that demonstrates why you guys are the best company out there. So teach them something about mobile marketing that they had no clue about - then close them at the end. Hope that helps.DM
-
I would like to pursue a career as a business analyst. I have experience on the business side but none in SQL or databases, how should I get started?
Easy... Contact companies you would want to work for and offer to intern or work for free for a few days/week under someone with that experience. Soak in the info. Help them in other areas. Ask a lot of questions as if you are completely new to the field.MM
-
Where can I learn SQL for business professionals? I need only the reporting part. I can run basic queries, but want to do more heavy queries.
There are a few options. If you've done the basics through Codecademy, then you're ready to move on to the specifics of a platform (such as PostgreSQL as you've mentioned). Though this can equally be a minefield. The reporting engines/formats differ from platform to platform. As does SQL believe it or not, in the sense each of the mainstream vendors adds their own specific bits to the standard. They are all compliant for the basics though. All of them will support the latest version of SQL (ANSI standard 2011), but PL/SQL is different to Transact-SQL in the way it uses cursors. In addition, each has an even bigger variation when it comes to multidimensional queries such as MDX, since there is no standard for MDX and some vendors use their own expressions and languages to carry out such queries. I can certainly help with tutoring, having been working in SQL since 1997 (and still do), although I think it's worth focussing on getting a little better at the specifics of the SQL vendor extensions you want to use, including their Cube, Pivot and Grouping functions as well as more complex joins, as they'll be the baseline skills for future reporting exercises, including analytical processing.EA
-
What kind of setup with a load balancer and servers would be needed to accept a million emails from SparkPost using WebHooks?
Likely this is the wrong question, so my response is just a guess... from doing software development since 1982... Best to tool your infrastructure, so no load balancers are required. If you design your code where your most accessed data remains memory resident + moving data from persistent storage (disk) into memory is fast, you'll have no requirement for load balancing. You give no information about the size of payload (in bytes) which will be requested, so no way to guess sizing of your net connection. Also you say 1 million status calls + give no time frame over which these calls must be processed. Based on your question, likely your best starting point will be to hire a seasoned developer to design your system to maximize memory resident data. Also, using webhooks may be a poor choice, as this makes code extremely complex, so only a few developers will be able to maintain + extend your code, so you'll pay more for development + have difficulty finding developers. Stick with a LAMP stack allowing Apache to manage threads, rather than Webhooks + your life will be easier + your budget lower.DF
-
Sou novo na plataforma e como poderia receber mais chamadas com interesse em Excel?
Olá! Boas-vindas à plataforma! Entendo que você é novo e quer atrair mais chamadas de pessoas interessadas em Excel. Para te ajudar a receber mais contatos relevantes, aqui estão algumas estratégias que você pode implementar: 1. Otimize seu Perfil: Título Claro e Conciso: Use um título que descreva exatamente o que você oferece em relação ao Excel. Exemplos: "Especialista em Excel | Aulas Particulares | Consultoria", "Professor de Excel | Do Básico ao Avançado", "Desenvolvedor de Planilhas Excel | Automação e VBA". Descrição Detalhada: Descreva suas habilidades em Excel, sua experiência, os tipos de serviços que oferece (aulas, consultoria, desenvolvimento de planilhas, etc.) e para quem eles são direcionados. Destaque seus diferenciais e o que te torna único. Use palavras-chave relevantes como "fórmulas", "macros", "VBA", "Power Query", "Power Pivot", "dashboards", "automação", "planilhas financeiras", etc. Foto Profissional: Use uma foto de perfil profissional e amigável. Portfólio (se aplicável): Se você tiver exemplos de planilhas que criou ou projetos em que trabalhou, inclua-os em seu perfil. Isso demonstra sua expertise de forma concreta. 2. Utilize Palavras-chave Relevantes: Identifique as palavras-chave: Pense nos termos que as pessoas usariam para procurar por serviços relacionados a Excel. Exemplos: "aula excel online", "curso excel avançado", "consultoria excel empresarial", "desenvolver planilha excel", "automatizar tarefas excel". Incorpore as palavras-chave: Use essas palavras-chave em seu título, descrição, tags (se a plataforma permitir) e em qualquer conteúdo que você publique. 3. Ofereça Conteúdo de Valor: Publique conteúdo relevante: Compartilhe dicas, tutoriais, exemplos de planilhas, artigos ou vídeos sobre Excel. Isso demonstra seu conhecimento e atrai potenciais clientes. Interaja com a comunidade: Participe de fóruns, grupos de discussão ou responda a perguntas sobre Excel na plataforma. Isso aumenta sua visibilidade e te posiciona como um especialista. 4. Promova seus Serviços: Divulgue seu perfil: Compartilhe seu perfil em suas redes sociais e peça para amigos e contatos compartilharem também. Ofereça um "gancho" inicial: Considere oferecer uma primeira consulta gratuita, um desconto inicial ou um material gratuito (como um ebook ou um modelo de planilha) para atrair os primeiros clientes. 5. Seja Ativo na Plataforma: Responda prontamente às mensagens: Demonstre profissionalismo e interesse respondendo às mensagens o mais rápido possível. Mantenha seu perfil atualizado: Revise e atualize seu perfil regularmente para garantir que as informações estejam sempre corretas e relevantes. Exemplos de como aplicar as dicas: Em vez de: "Dou aulas." Use: "Professor particular de Excel com foco em planilhas financeiras e automação com VBA. Aulas online para todos os níveis." Em vez de: "Manjo de Excel." Use: "Consultor especializado em Excel com experiência em desenvolvimento de dashboards interativos e otimização de processos com Power Query e Power Pivot." Recursos Adicionais: Pesquise na própria plataforma por perfis de outros profissionais que oferecem serviços relacionados a Excel e veja o que eles estão fazendo bem. Explore ferramentas de pesquisa de palavras-chave (como o Google Keyword Planner) para identificar os termos mais buscados relacionados a Excel. Lembre-se que construir uma presença online forte leva tempo e consistência. Seja paciente, continue aprendendo e aprimorando suas habilidades, e os resultados virão. Boa sorte!AG
the startups.com platform
Copyright © 2025 Startups.com. All rights reserved.