|
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).
|
|
Apple is planning to open a new store-within-a-store concept at the legendary Harrods department store on Brompton Road in London, according to 9to5Mac .
Harrods boasts more than 1 million square feet of selling space across 330 departments -- plenty ...
Started by MacRumors on
, 25 posts
by 19 people.
Answer Snippets (Read the full thread at macrumors):
Wirelessly posted (Mozilla/5.0 (iPhone; CPU iPhone Safari/7534.48.3)
The store....
I'm all for expanding the mac user base, but store-within-a-store gives that the staff are trained by Apple Store trainers.
This is getting silly now.
|
|
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() .
|
Ask your Facebook Friends
|
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... .
|
|
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.
|
