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
-
excel anyone know the cengage test?
Cengage Learning Testing Powered by Cognero is a full-featured, online assessment system that allows instructors to create tests from publisher-provided content as well as write new questions.TM
-
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
-
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
-
Will a startup only focused cloud accounting software work that also provides metrics for the startup?
What financial metrics would startups use?
Recently launched Subleger http://subledger.com/ is trying to do some or all of what you describe. It doesn't mean that there isn't room for others but consider that many early-stage companies don't have complex revenue in-flow so the core of what you're describing (converting or merging income into other operational metrics) might not have a wide appeal especially for startups. Hopefully you get some good answers here but really whatever anyone (myself included) says here is far less valuable than asking startup CEOs what their financial painpoints are with respect to reconciling their app's internal metrics with revenue and expenses. Finally, the question "is the market big enough" is too open-ended to answer for you. Big enough for what? To attract significant outside funding? Maybe not big enough. But to build a great income for you and a few others? Perhaps! Happy to discuss this with you further to help you in your evaluation of the opportunity but as I say, best thing to do is canvass the potential market first.TW
-
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
the startups.com platform
Copyright © 2025 Startups.com. All rights reserved.