Questions tagged [sql]

Structured Query Language - a language designed for interacting with databases.

Filter by
Sorted by
Tagged with
0
votes
0answers
2 views

What is the best stack for a gene to disease database

I am the founder of a Genomics Diagnostic company and I am interested in understanding if anybody have built databases using Grakn and what their experience is. Kind Regards Gitte Pedersen CEO and ...
0
votes
0answers
19 views

Looking SQL Query tool

I am looking for an SQL tool that I can manage preset SQL queries. I have some SQL queries but that I need to use randomly but it would help if there any tool that will have preset SQL query and I ...
0
votes
0answers
6 views

Software to export SQL database as a graph of entity

Working on Symfony with Doctrine + SQL database, I want to export all entities of the selected table in order to allow a graph visualization. My question is : is there a software/library/bundle that ...
0
votes
1answer
23 views

Best option/opinion on how to load website data - Html/PHP into a SQL Server Database?

I have been thinking and trying to expand my knowledge of different tools. One thing I have never had personal experience with is getting website data that users enter, and have that loaded into a SQL ...
0
votes
0answers
10 views

SQL “live backup”

We are trying to achieve the following but I'm unable to find any documentation: We have a database with many 150+ tables where clients input data daily, if the devs run queries on the DB, the DB ...
0
votes
1answer
17 views

How do I store/share data between diferent devices?

I am creating an IoT system of sensors etc. for my house. Each sensor is run on a Raspberry Pi Zero. I want all the data to be stored somewhere so that a separate Zero can run a web app using flask ...
0
votes
0answers
11 views

SQL/NoSQL Engine for storing scientific data (now represented as CSV files)

I have a lot of CSV files which contain up to 20 columns with float numbers. Right now I am keeping these files in a folder. Every files is related to specific user and specific date. Files usually ...
0
votes
0answers
25 views

RDBMS to efficiently store 250k 12-bit images

I generate about 250k 1360x1024 12 bit images per year. The images are really just 1360x1024x1 arrays, and each pixel is a 12 bit value. When saved as a csv, the images are 4.6MB. Our default ...
0
votes
0answers
19 views

Tool that guides converting / mapping JSON, XML, Excel based data to various SQL Table Formats

I would hope this tool would let me select columns for import from excel and then rigidly apply data type rules, allow custom conversion functions, and provide some sort of "workflow" that retains the ...
0
votes
0answers
37 views

Looking for a database server on an embedded system

So I'm looking for a database server which needs to run with the following requirements: Run on Windows XP. Log in via TCP/IP. Authentication. Expose custom stored procedures. It will be running on ...
0
votes
0answers
22 views

Which front end SQL client should I use with a Windows front end configured to a Postgresql back end?

I want it to be open source and runs on Windows. I have a Linux server running Postgres. Which free application is versatile, easy-to-use and secure? TOAD is not free. There are other open-source ...
0
votes
0answers
17 views

Converting create table statements from Oracle SQL to PostgreSQL

I am looking for a program that can converting create table statements from Oracle SQL to PostgreSQL (e.g., choose the closest type for each column). Any OS, any license, any price is fine. CLI or ...
0
votes
0answers
30 views

Compare script output from remote server with local result

I want to run this SQL on the local and remote host: select concat_ws('.', table_schema, table_name, column_name) as column_name from information_schema.columns where table_schema not in ('...
-1
votes
1answer
14 views

format column values during sql select query

I have a table with name, gender and address. Gender is stored as integer, 1 for male, and 2 for female. Now when I want to show the table, in PHP, during drawing the table I check for gender with (if ...
-1
votes
1answer
58 views

which database is better for my case? sql? nosql? newsql?

right now i have project which is about gathering information about country wide real estate active dealers and etc. the goal is to create an information system for real estate activists, the data ...
-1
votes
1answer
18 views

How can I check if my SQL query is right without executing it?

Its similar to https://stackoverflow.com/questions/377883/how-to-check-if-mysql-query-is-valid-without-executing-it But its for Go and I want a solution in Python. It will be better if there is a ...
-1
votes
1answer
30 views

Should I learn MySQL and SQL server together for learning SQL? [closed]

I am starting to learn SQL so I was wondering which RDBMS should I use, i.e. MySQL or SQL Server, so I can also mention that tool in my resume to give good impression to get a job here in India. So ...
-1
votes
1answer
8 views

Adapting to Python/R as a SAS expert

I'm learning Python and R, because so many companies demand those skill sets now. This is me shamelessly looking for training wheels because my older habits are taking time to unlearn. I am an ...
-1
votes
1answer
9 views

What Database type should I use for a scraped data comes from many websites?

I'm building a REST API using NodeJS storing a scraped data that comes from many websites ( the API I'm building is about selling - buying used cars ) There's a potential to scale in the future ...
-1
votes
1answer
21 views

SSRS - SQL Server Reporting Services Possibility?

Currently, we have SQL Server 2012 R2. Looking to produce some reports and have them automatically run and have converted to PDF with the possibility of automating an email to send to subscribers of ...

1 2 3 4