|
Should I be storing the raw SQL queries in my c# code, or should I be delegating them to stored functions in the Postgres Backend?
If I should be storing them in code, since they can get quite long, what is the optimal way to store them (ie. as constants...
Started by lozzar on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
You could have double....
Quite how you format that text file is up to you, of course .
I quite like storing SQL in text files embedded as resources into the assembly (when I absolutely have to have a significant number of them; I'm an ORM man normally).
|
|
I am storing a Java object as an byte in a blob of a table. The java object is customized object. How can I construct the java object and use it in the stored procedure?
Started by V.Anand on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
That said, this is usually considered_INCREMENT, name VARCHAR, age INTEGER )
Edit as a reply on your comment: you thus basically want to store.
store in the DB using CallableStatement#setBinaryStream() .
|
|
Hi, We are using SQL Server 2005. I want to create the file of the output of the stored procedure.
Started by Miral on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
If you are using MySQL you may want to start from the following:
DELIMITER $$ CREATE PROCEDURE export_dynamic(IN file_path char(64)) BEGIN SET @sql = CONCAT('SELECT * INTO OUTFILE ', "'", file_path, "'", ' FROM Table1'); PREPARE stmt1 FROM @sql; EXECUTE... .
|
Ask your Facebook Friends
|
I am looking for nosql key value stores that also provide for storing/maintaining relationships between stored entities. I know Google App Engine's datastore allows for owned and unowned relationships between entities. Does any of the popular nosql store...
Started by Ritesh M Nayak on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
It does provide, however, a simple form of inter.
As key/value stores is a document database, not a key/value store.
store" and then your actual question narrows this down to "nosql key value store".
|
|
I have been working on a cURL script and I am finally done, yay! Basically, right now, I am grabbing the error / success message and storing it, but how should I store it? Should I store it in a .txt file or MySQL. What is a efficient/common practice?...
Started by Doug on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
So if you just want to store errors I say stay with the text file attempts and the date of the last ....
If you're just grabbing an error/success message, just store it to a log and deployment effort on your part.
A bit over the top to me.
|
|
Helo,
My question is I have one Stored Procedure in SQL Server that returns counts of a field. I want to store the results of this Stored Procedure in a variable (scalar?) of a different stored procedure.
sp_My_Other_SP: CREATE PROCEDURE [dbo].sp_My_Other...
Started by Phil on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Well, the easiest way to fix this is to recode the stored proc so that the select statement that returns the 'other' result set you don't want in this case is conditionally extecuted, only when you are NOT asking for the count
Add another parameter....
|
|
Hello,
I am wondering whats more efficient, to store temporary data (related to that session) in a session using say $_SESSION variable in PHP or store and retrieve from an SQL database?
Thank you for your time.
Started by Alec Smart on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
If you need to scale....
It really depends on the volume of data you intend to store and the amount of traffic of the webserver.
What's more efficient will depend on the amount of data you want to store and what do you plan and the database.
|
|
Typically file servers are used to store images for a web application. For more security and control you'd go for storing images in database. But this proves to be complex and slow.
Are there other mainstream options available other than db/file server...
Started by Satya on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
SQL Server 2008 offers the Filestream storage wich allows you to store data in the filesystem, yet.
|
|
Our application will be serving a large number of small, thumbnail-size images (about 6-12KB in size) through HTTP. I've been asked to investigate whether using a NoSQL data store is a viable solution for data storage. Ideally, we would like our data ...
Started by Wayne See on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
In general:
To store there aren't the traditional constraints....
Whether or not to store images in a DB or the filesystem is sometime one of those "holy war" type of debates; each side feels their way of doing things is the one right way.
|
|
I know that one of the differences between classes and structs is that struct instances get stored on stack and class instances(objects) are stored on the heap.
Since classes and structs are very similar. Does anybody know the difference for this particular...
Started by ichiban on
, 11 posts
by 11 people.
Answer Snippets (Read the full thread at stackoverflow):
Eric Lippert recently....
However, it's worth noting that there's no fundamental guarantee that all structs will be placed on the stack .
It's useful in practice to be able to allocate memory on the stack for some purposes, since those allocations are very fast .
|
